sql-server Archives - Page 38 of 39

Is it just that nvarchar supports multibyte characters? If that is the case, is there really any point, other than storage concerns, to ...

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

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

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

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

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

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

I need to add a specific column if it does not exist. I have something like the following, but it always returns false: ...