Is there a way in SQL Server Management Studio 2005 (or later) to change the Windows Authentication user (as you could in SQL Server 2000 and older)? This is the general connection properties dialog(note the greyed out UID/PWD when selecting Windows Auth): FYI – One workaround is to use runas but I’m looking for a … Read more
I need to search a SQL server 2008 for stored procedures containing where maybe the name of a database field or variable name. 23 Answers 23
I just need to select the first day of the month of a given DateTime variable. I know it’s quite easy to do using this kind of code: select CAST(CAST(YEAR(@mydate) AS VARCHAR(4)) + “https://stackoverflow.com/” + CAST(MONTH(@mydate) AS VARCHAR(2)) + ‘/01’ AS DATETIME) But unfortunately, this is not very elegant, and not very fast either. Is … Read more
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 is a generated value. INSERT INTO table (name) VALUES(‘bob’); Now I want to get the id back in the same step. How is this done? We’re using Microsoft SQL Server 2008. 14 … Read more
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 the combination of field1, field2, field3 occurs multiple times and from the above statement if there are multiple occurrences I would like to select every record except the first one. 8 Answers … Read more
I have this error message: Msg 8134, Level 16, State 1, Line 1 Divide by zero error encountered. What is the best way to write SQL code so that I will never see this error message again? I could do either of the following: Add a where clause so that my divisor is never zero … Read more
This isn’t working in SQL Server 2008: ALTER TABLE Employee ALTER COLUMN CityBorn SET DEFAULT ‘SANDNES’ The error is: Incorrect syntax near the keyword ‘SET’. What am I doing wrong? 14 Answers 14
I’m looking for an efficient way to convert rows to columns in SQL server, I heard that PIVOT is not very fast, and I need to deal with lot of records. This is my example: ——————————- | Id | Value | ColumnName | ——————————- | 1 | John | FirstName | | 2 | 2.4 … Read more
While studying for the 70-433 exam I noticed you can create a covering index in one of the following two ways. CREATE INDEX idx1 ON MyTable (Col1, Col2, Col3) — OR — CREATE INDEX idx1 ON MyTable (Col1) INCLUDE (Col2, Col3) The INCLUDE clause is new to me. Why would you use it and what … Read more
How can I delete duplicate rows where no unique row id exists? My table is col1 col2 col3 col4 col5 col6 col7 john 1 1 1 1 1 1 john 1 1 1 1 1 1 sally 2 2 2 2 2 2 sally 2 2 2 2 2 2 I want to be left … Read more
