Tuesday, March 25, 2014

BCP OUT WITH PARAMETERS NOT WORKING


SET @strbcpcmd = 'bcp "select * from ##tmpJsonTable" queryout "'+@path+'" -w -C OEM -t"$" -T -S'+@@servername


You should listen to Erland to print out your string command since you have a working non-variable version. You are missing two single quotes to connect your path variable in the string.

No comments:

Post a Comment