tsql Archives - Page 12 of 17

SELECT INTO a table variable in T-SQL

Got a complex SELECT query, from which I would like to insert all rows into a table variable, but T-SQL doesn’t allow it. ...

May 7, 2022
0 Comments

Select statement to find duplicates on certain fields

Can you help me with SQL statements to find duplicates on multiple fields? For example, in pseudo code: select count(field1,field2,field3) from table where ...

May 7, 2022
0 Comments

How to set a default value for an existing column

This isn’t working in SQL Server 2008: ALTER TABLE Employee ALTER COLUMN CityBorn SET DEFAULT 'SANDNES' The error is: Incorrect syntax near the ...

May 7, 2022
0 Comments

SQL Server: Difference between PARTITION BY and GROUP BY

I’ve been using GROUP BY for all types of aggregate queries over the years. Recently, I’ve been reverse-engineering some code that uses PARTITION ...

May 6, 2022
0 Comments

SQL Server SELECT into existing table

I am trying to select some fields from one table and insert them into an existing table from a stored procedure. Here is ...

May 6, 2022
0 Comments

What is the use of GO in SQL Server Management Studio & Transact SQL?

SQL Server Management Studio always inserts a GO command when I create a query using the right click “Script As” menu. Why? What ...

May 6, 2022
0 Comments

What is the meaning of the prefix N in T-SQL statements and when should I use it?

I have seen prefix N in some insert T-SQL queries. Many people have used N before inserting the value in a table. I ...

May 5, 2022
0 Comments

how can I Update top 100 records in sql server

I want to update the top 100 records in SQL Server. I have a table T1 with fields F1 and F2. T1 has ...

May 5, 2022
0 Comments

SQL MAX of multiple columns?

How do you return 1 value per row of the max of several columns: TableName...

May 5, 2022
0 Comments

Replace a newline in TSQL

I would like to replace (or remove) a newline character in a TSQL-string. Any Ideas? The obvious REPLACE(@string, CHAR(13), '') just won’t do ...

May 5, 2022
0 Comments