sql-server Archives - Page 12 of 16

SQL Server Profiler – How to filter trace to only display events from one database?

How do I limit a SQL Server Profiler trace to a specific database? I can’t see how to filter the trace to not ...

May 8, 2022
0 Comments

SQL Server – inner join when updating [duplicate]

This question already has answers here: Update a table using JOIN in SQL Server? (13 answers) Closed 9 years ago. I have the ...

May 8, 2022
0 Comments

What’s the difference between a temp table and table variable in SQL Server?

In SQL Server 2005, we can create temp tables one of two ways: declare @tmp table (Col1 int, Col2 int); or create table ...

May 7, 2022
0 Comments

SQL Server Escape an Underscore

How do I escape the underscore character? I am writing something like the following where clause and want to be able to find ...

May 7, 2022
0 Comments

How to rename a table in SQL Server?

The SQL query that I have used is : ALTER TABLE oldtable RENAME TO newtable; But, it gives me an error. Server: Msg ...

May 7, 2022
0 Comments

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

Is there a Boolean data type in Microsoft SQL Server like there is in MySQL? [duplicate]

This question already has answers here: How do you create a yes/no boolean field in SQL server? (11 answers) Closed 1 year ago. ...

May 7, 2022
0 Comments

Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “Latin1_General_CI_AS” in the equal to operation

I have the following code SELECT tA.FieldName As [Field Name], COALESCE(tO_A.[desc], tO_B.[desc], tO_C.Name, tA.OldVAlue) AS [Old Value], COALESCE(tN_A.[desc], tN_B.[desc], tN_C.Name, tA.NewValue) AS...

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