sql-server-2008 Archives - Page 6 of 7

Connect different Windows User in SQL Server Management Studio (2005 or later)

Is there a way in SQL Server Management Studio 2005 (or later) to change the Windows Authentication user (as you could in SQL ...

May 11, 2022
0 Comments

How do I find a stored procedure containing ?

I need to search a SQL server 2008 for stored procedures containing where maybe the name of a database field or variable name. ...

May 10, 2022
0 Comments

How can I select the first day of a month in SQL?

I just need to select the first day of the month of a given DateTime variable. I know it’s quite easy to do ...

May 9, 2022
0 Comments

SQL Server – Return value after INSERT

I’m trying to get a the key-value back after an INSERT-statement. Example: I’ve got a table with the attributes name and id. id ...

May 9, 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

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

Efficiently convert rows to columns in sql server

I’m looking for an efficient way to convert rows to columns in SQL server, I heard that PIVOT is not very fast, and ...

May 5, 2022
0 Comments

Why use the INCLUDE clause when creating an index?

While studying for the 70-433 exam I noticed you can create a covering index in one of the following two ways. CREATE INDEX ...

May 4, 2022
0 Comments

How to delete duplicate rows in SQL Server?

How can I delete duplicate rows where no unique row id exists? My table is col1 col2 col3 col4 col5 col6 col7 john ...

May 3, 2022
0 Comments