tsql Archives - Page 13 of 17

Select columns from result set of stored procedure

I have a stored procedure that returns 80 columns, and 300 rows. I want to write a select that gets 2 of those ...

May 4, 2022
0 Comments

Is it possible to specify condition in Count()?

Is it possible to specify a condition in Count()? I would like to count only the rows that have, for example, “Manager” in ...

May 3, 2022
0 Comments

Pad a string with leading zeros so it’s 3 characters long in SQL Server 2008

I have a string that is up to 3 characters long when it’s first created in SQL Server 2008 R2. I would like ...

May 3, 2022
0 Comments

How do I split a string so I can access item x?

Using SQL Server, how do I split a string so I can access item x? Take a string “Hello John Smith”. How can ...

May 3, 2022
0 Comments

What is the significance of 1/1/1753 in SQL Server?

Why 1753? What do they have against 1752? My great great great great great great great grandfather would be very offended. 6 s ...

May 2, 2022
0 Comments

T-SQL: Selecting rows to delete via joins

Scenario: Let’s say I have two tables, TableA and TableB. TableB’s primary key is a single column (BId), and is a foreign key ...

May 2, 2022
0 Comments

Selecting COUNT(*) with DISTINCT

In SQL Server 2005 I have a table cm_production that lists all the code that’s been put into production. The table has a ...

May 2, 2022
0 Comments

Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?

Using MSSQL2005, can I truncate a table with a foreign key constraint if I first truncate the child table (the table with the ...

May 2, 2022
0 Comments

Best approach to remove time part of datetime in SQL Server

Which method provides the best performance when removing the time portion from a datetime field in SQL Server? a) select DATEADD(dd, DATEDIFF(dd, 0, ...

May 1, 2022
0 Comments

Insert multiple rows WITHOUT repeating the “INSERT INTO …” part of the statement?

I know I’ve done this before years ago, but I can’t remember the syntax, and I can’t find it anywhere due to pulling ...

April 30, 2022
0 Comments