Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-18 : 09:24:11
|
| Mala writes "Hi,Please let me know what the maximum lenth we can pass to procedure as a parameter., because it is giving me error as 'identifier value............ cann't be more than 128 ', though i have declare that parameter as varchar(4000). If i reduced the length of the value i am passing, it is accepting and executing procedure. Is there any restriction for the length ? If so, how can i overcome that, as i will be passing columns name dynamically.Thanks in advance.Bye,Mala" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-06-18 : 09:26:17
|
| Varchar data in SQL is delimited with a single quote ('), not a double quote ("). Chances are you're using the double quote to delimit the string value, and SQL Server is interpreting it as an identifier (column name, table name, etc.)If you have embedded apostrophes in your string, you can replace them with double apostrophes ('') and SQL Server will translate them correctly. Also look at the QUOTENAME() function in Books Online, it will help converting strings for you. |
 |
|
|
|
|
|
Parameter Length