Dynamic SQL calls

Question

Dynamic SQL calls

Steve Jones - SSC Editor

SSC Guru

Points: 738043
More actions
March 28, 2019 at 9:58 pm

#2033865

Comments posted to this topic are about the item Dynamic SQL calls

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Stewart "Arturius" Campbell SSC Guru Points: 72716 More actions · Answer 1

Nice, easy question to end the week on, thanks, Steve

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

HappyGeek SSCoach Points: 18729 More actions · Answer 2

HappyGeek

SSCoach

Points: 18729

March 29, 2019 at 2:13 am

#2034171

Good question, thanks Steve.

...

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Considering how much dynamic SQL I write where I work, this was a very easy question. I use sp_executesql extensively in my code where I need to run dynamic SQL.

johnfowler SSCommitted Points: 1521 More actions · Answer 4

It seems to me the second answer could be correct as well. If the DECLARE statement included a value for @CustomerKey then the query won't error. So, if the second DECLARE statement was changed to:
DECLARE @params NVARCHAR(1000) = '@CustomerKey int = 101';
Then the query wouldn't error out and would return rows if there were rows containing a customer key of 101.

RLilj33 SSCrazy Points: 2203 More actions · Answer 5

+1 to johnfowler. While adjusting the @params statement to include a fixed value may not be very useful, it still works.

This reply was modified 6 years, 1 month ago by RLilj33.

Dynamic SQL calls

Cookies on SQLServerCentral