tsql Archives - Page 16 of 17

Check if table exists in SQL Server

I would like this to be the ultimate discussion on how to check if a table exists in SQL Server 2000/2005 using SQL ...

April 13, 2022
0 Comments

How can I remove duplicate rows?

What is the best way to remove duplicate rows from a fairly large SQL Server table (i.e. 300,000+ rows)? The rows, of course, ...

April 13, 2022
0 Comments

How can I do an UPDATE statement with JOIN in SQL Server?

I need to update this table in SQL Server with data from its ‘parent’ table, see below: Table: sale id (int) udid (int) ...

April 12, 2022
0 Comments

Find all tables containing column with specified name – MS SQL Server

Want to improve this post? Provide detailed answers to this question, including citations and an explanation of why your answer is correct. without ...

April 12, 2022
0 Comments

Get size of all tables in database

I have inherited a fairly large SQL Server database. It seems to take up more space than I would expect, given the data ...

April 12, 2022
0 Comments

How do I perform an IF…THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete="N" OR InStock = 'Y' ? 1 : 0) ...

April 11, 2022
0 Comments

Insert results of a stored procedure into a temporary table

How do I do a SELECT * INTO [temp table] FROM [stored procedure]? Not FROM [Table] and without defining...

April 11, 2022
0 Comments

Inserting multiple rows in a single SQL query? [duplicate]

This question already has answers here: Insert multiple rows WITHOUT repeating the “INSERT INTO …” part of the statement? (16 answers) Closed 8 ...

April 10, 2022
0 Comments

LEFT JOIN vs. LEFT OUTER JOIN in SQL Server

What is the difference between LEFT JOIN and LEFT OUTER JOIN? 12 As per the documentation: FROM (Transact-SQL): <join_type> ::=...

April 10, 2022
0 Comments

How to return only the Date from a SQL Server DateTime datatype

SELECT GETDATE() Returns: 2008-09-22 15:24:13.790 I want that date part without the time part: 2008-09-22 00:00:00.000 How can I get that? 4 44

April 10, 2022
0 Comments