Oct 15, 2010 · What are the differences between the SET and SELECT statements when assigning variables in T-SQL?

SQL Server still lets you use [square brackets], rather than forcing you to use "quotation marks". But with QUOTED_IDENTIFIER ON, you cannot use "double quote quotation mark around …

SET @ModelID = (SELECT m.modelid FROM MODELS m WHERE m.areaid = 'South Coast'); Then you can use SELECT to show the value of @ModelID or use the variable into your code.

Jan 31, 2012 · 26 The Update table1 set (a,b,c) = (select x,y,x) syntax is an example of the use of row-value constructors, Oracle supports this, MSSQL does not. (Connect item)

Feb 7, 2015 · I have some queries to find out the ddl of some objects from a schema. The result columns I am getting are truncated in the middle of the queries. How can I increase the width …

Cannot insert explicit value for identity column in table 'Baskets' when IDENTITY_INSERT is set to OFF.

Oct 22, 2008 · The arguments for using MERGE (including those in the post from sqlblog.com linked above) might be compelling, but one thing to consider might be that according to …

SET @sql = CONCAT(N'SELECT ', @RowTo, ' * 5'); But in your case you should use proper parameterization rather than concatenation. If you keep using concatenation, you will expose …

Feb 16, 2012 · I want a value to be set to NULL if nothing is put into the text box in the form I'm submitting. How can I make this happen? I've tried inserting 'NULL' but this just adds the word …

Jan 14, 2009 · How do I set a column value to NULL in SQL Server Management Studio? Asked 16 years, 10 months ago Modified 3 years, 5 months ago Viewed 1.5m times