sql-server Archives - Page 8 of 16

How can I select from list of values in SQL Server

I have very simple problem that I can’t solve. I need to do something like this: select distinct * from (1, 1, 1, ...

May 19, 2022
0 Comments

What makes a SQL statement sargable?

By definition (at least from what I’ve seen) sargable means that a query is capable of having the query engine optimize the execution ...

May 19, 2022
0 Comments

How can I escape square brackets in a LIKE clause?

I am trying to filter items with a stored procedure using like. The column is a varchar(15). The items I am trying to ...

May 18, 2022
0 Comments

Is there a way to loop through a table variable in TSQL without using a cursor?

Let’s say I have the following simple table variable: declare @databases table ( DatabaseID int, Name varchar(15), Server varchar(15) ) -- insert a ...

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

How do you kill all current connections to a SQL Server 2005 database?

I want to rename a database, but keep getting the error that ‘couldn’t get exclusive lock’ on the database, which implies there is ...

May 18, 2022
0 Comments

How to get a date in YYYY-MM-DD format from a TSQL datetime field?

How do I retrieve a date from SQL Server in YYYY-MM-DD format? I need this to work with SQL Server 2000 and up. ...

May 18, 2022
0 Comments

Find a value anywhere in a database

Given a number, how do I discover in what table and column it could be found within? I don’t care if it’s fast, ...

May 17, 2022
0 Comments

Remove all spaces from a string in SQL Server

What is the best way to remove all spaces from a string in SQL Server 2008? LTRIM(RTRIM(' a b ')) would remove all ...

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