tsql Archives - Page 11 of 17

How do you change the datatype of a column in SQL Server?

I am trying to change a column from a varchar(50) to a nvarchar(200). What is the SQL command to alter this table? 10 ...

May 9, 2022
0 Comments

What is the equivalent of ‘describe table’ in SQL Server?

I have a SQL Server database and I want to know what columns and types it has. I’d prefer to do this through ...

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

What is the difference between SQL, PL-SQL and T-SQL?

What is the difference between SQL, PL-SQL and T-SQL? Can anyone explain what the differences between these three are, and provide scenarios where ...

May 9, 2022
0 Comments

List of all index & index columns in SQL Server DB

How do I get a list of all index & index columns in SQL Server 2005+? The closest I could get is: select ...

May 9, 2022
0 Comments

How to set variable from a SQL query?

I’m trying to set a variable from a SQL query: declare @ModelID uniqueidentifer Select @ModelID = select modelid from models where areaid = ...

May 9, 2022
0 Comments

Sleep Command in T-SQL?

Is there to way write a T-SQL command to just make it sleep for a period of time? I am writing a web ...

May 8, 2022
0 Comments

Selecting data from two different servers in SQL Server

How can I select data in the same query from two different databases that are on two different servers in SQL Server? 15 ...

May 8, 2022
0 Comments

How to do SQL Like % in Linq?

I have a procedure in SQL that I am trying to turn into Linq: SELECT O.Id, O.Name as Organization FROM Organizations O JOIN ...

May 8, 2022
0 Comments

Is there a combination of “LIKE” and “IN” in SQL?

In SQL I (sadly) often have to use “LIKE” conditions due to databases that violate nearly every rule of normalization. I can’t change ...

May 7, 2022
0 Comments