sql-server-2008 Archives - Page 5 of 7

Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)

I have a development database that re-deploy frequently from a Visual Studio Database project (via a TFS Auto Build). Sometimes when I run ...

May 18, 2022
0 Comments

Can I use multiple “with”?

Just for example: With DependencedIncidents AS ( SELECT INC.[RecTime],INC.[SQL] AS [str] FROM ( SELECT A.[RecTime] As [RecTime],X.[SQL] As [SQL] FROM...

May 18, 2022
0 Comments

How do I move a table into a schema in T-SQL

I want to move a table into a specific Schema using T-SQL? I am using SQL Server 2008. 2 Answers 2

May 18, 2022
0 Comments

SQL Server add auto increment primary key to existing table

As the title, I have an existing table which is already populated with 150000 records. I have added an Id column (which is ...

May 17, 2022
0 Comments

SQL Server SELECT INTO @variable?

I have the following code in one of my Sql (2008) Stored Procs which executes perfectly fine: CREATE PROCEDURE [dbo]....

May 17, 2022
0 Comments

How can I truncate a datetime in SQL Server?

What’s the best way to truncate a datetime value (as to remove hours minutes and seconds) in SQL Server 2008? For example: declare ...

May 16, 2022
0 Comments

Entity Framework: There is already an open DataReader associated with this Command

I am using Entity Framework and occasionally i will get this error. EntityCommandExecutionException {"There is already an open DataReader associated with this Command ...

May 16, 2022
0 Comments

SET versus SELECT when assigning variables?

What are the differences between the SET and SELECT statements when assigning variables in T-SQL? 4 Answers 4

May 15, 2022
0 Comments

SQL Server Insert if not exists

I want to insert data into my table, but insert only data that doesn’t already exist in my database. Here is my code: ...

May 13, 2022
0 Comments

How do I see active SQL Server connections?

I am using SQL Server 2008 Enterprise. I want to see any active SQL Server connections, and the related information of all the ...

May 11, 2022
0 Comments