Timeline for Problem locating rows with dynamic SQL
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 8, 2020 at 3:54 | history | edited | Aaron Bertrand | CC BY-SA 4.0 |
deleted 33 characters in body
|
| Jul 7, 2015 at 18:41 | vote | accept | user3268054 | ||
| Jul 7, 2015 at 18:00 | comment | added | Aaron Bertrand | @user3268054 Try it now, just missed a string delimiter (again, this is another reason you should be learning the second form - less string escaping). | |
| Jul 7, 2015 at 17:59 | history | edited | Aaron Bertrand | CC BY-SA 3.0 |
edited body
|
| Jul 7, 2015 at 17:53 | comment | added | user3268054 | Ok, so I put the first section in (the escaping the values one) and I get an incorrect syntax near ' WHERE Room = ' ' error. Sorry, like I said, i'm new to SQL. The second one does work, but I need to work through the syntax so I know what's going on. | |
| Jul 7, 2015 at 17:30 | history | answered | Aaron Bertrand | CC BY-SA 3.0 |