Timeline for Syntax error in SQL Server while making Dynamic SQL
Current License: CC BY-SA 4.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 11, 2018 at 7:22 | vote | accept | Aayush Dahal | ||
| Oct 10, 2018 at 11:31 | answer | added | Aaron Bertrand | timeline score: 1 | |
| Oct 10, 2018 at 11:26 | history | edited | Scott Hodgin - Retired | CC BY-SA 4.0 |
Corrected spelling in title.
|
| S Oct 10, 2018 at 10:40 | history | suggested | Adam Miklosi | CC BY-SA 4.0 |
I've corrected some spelling mistakes.
|
| Oct 10, 2018 at 10:33 | answer | added | Marcello Miorelli | timeline score: 2 | |
| Oct 10, 2018 at 9:39 | review | Suggested edits | |||
| S Oct 10, 2018 at 10:40 | |||||
| Oct 10, 2018 at 9:09 | comment | added | Scott Hodgin - Retired | Check out Conditional Order By for some options | |
| Oct 10, 2018 at 8:59 | history | edited | user1822 |
edited tags
|
|
| Oct 10, 2018 at 8:58 | comment | added | sepupic |
you CANNOT use variables in ORDER BY. Your code now looks like ORDER BY @sort_col @sort_dir but it's not supported syntax
|
|
| Oct 10, 2018 at 8:52 | comment | added | Aayush Dahal |
Msg 208, Level 16, State 1, Line 4 Invalid object name 'dbo.base_voter'.
|
|
| Oct 10, 2018 at 8:32 | history | edited | Aayush Dahal | CC BY-SA 4.0 |
added 12 characters in body
|
| Oct 10, 2018 at 8:26 | history | asked | Aayush Dahal | CC BY-SA 4.0 |