sql Archives - Page 44 of 45

I want to delete using INNER JOIN in SQL Server 2008. But I get this error: Msg 156, Level 15, State 1, Line ...

What is the difference between UNION and UNION ALL? 2 22 UNION removes duplicate records (where all columns in the results are the ...

Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be ...

I am trying to INSERT INTO a table using the input from another table. Although this is entirely feasible for many database engines, ...

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

I want to query something with SQL’s like query: SELECT * FROM users WHERE name LIKE '%m%' How can I achieve the same ...

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

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

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