tsql Archives - Page 8 of 17

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

NULL values inside NOT IN clause

This issue came up when I got different records counts for what I thought were identical queries one using a not in where ...

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

Syntax of for-loop in SQL Server

What is the syntax of a for loop in TSQL? 10 Answers 10

May 18, 2022
0 Comments

Why do you create a View in a database?

When and Why does some one decide that they need to create a View in their database? Why not just run a normal ...

May 18, 2022
0 Comments

Counting DISTINCT over multiple columns

Is there a better way of doing a query like this: SELECT COUNT(*) FROM (SELECT DISTINCT DocumentId, DocumentSessionId FROM DocumentOutputItems) AS internalQuery I ...

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 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

Turning a Comma Separated string into individual rows

May 17, 2022
0 Comments