sql-server Archives - Page 29 of 39

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

Conversion of a datetime2 data type to a datetime data type results out-of-range value

I’ve got a datatable with 5 columns, where a row is being filled with data then saved to the database via a transaction. ...

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

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 avoid the “divide by zero” error in SQL?

I have this error message: Msg 8134, Level 16, State 1, Line 1 Divide by zero error encountered. What is the best way ...

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