Handling Syntax error in SQL Query
Database
3
Posts
3
Posters
0
Views
1
Watching
-
hi, I m creating a Dynamic Query in Procedure on that time if some Syntax Error Occurs due to unformatted input how can I handle It in side procedure.If any one can guide me please help.
rup
I had to cast datetime-parameters to an nvarchar(50) to make the dynamic query work. Note: This had to be done within the query-string. I also had to specify the length of an varchar-parameter to make it work. Maybe this could help you, too.
-
hi, I m creating a Dynamic Query in Procedure on that time if some Syntax Error Occurs due to unformatted input how can I handle It in side procedure.If any one can guide me please help.
rup