Search Knowledge Base
KB #240029: How to specify column and table names containing embedded spaces
Type: | Tip |
Summary: | |
Column and table names containing embedded spaces (blanks) must be enclosed in [brackets], not ‘quotes’, when passed as parameters to APIs. | |
Additional Information: | |
-- Correct: set @value = fn_n_decrypt_char([home phone], 0, 0, 1) -- Wrong: this will decrypt the literal value "home phone" set @value = fn_n_decrypt_char('home phone', 0, 0, 1) -- Correct: exec sp_n_encrypt_col [student table], [home phone], 1 -- Wrong: this will generate an error exec sp_n_encrypt_col 'student table', 'home phone', 1 Tip: It is always ok to enclose table or column names in [brackets] even if they do not contain embedded spaces: -- Both are correct: exec sp_n_encrypt_col students, telephone, 1 exec sp_n_encrypt_col [students], [telephone], 1 |
Last modified: 1/13/2016