What is the difference between varchar and nvarchar?
Is it just that nvarchar supports multibyte characters? If that is the case, is there really any point, other than storage concerns, to … Read more
sql-server
How can I delete using INNER JOIN with SQL Server?
I want to delete using INNER JOIN in SQL Server 2008. But I get this error: Msg 156, Level 15, State 1, Line … Read more
Table Naming Dilemma: Singular vs. Plural Names [closed]
Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be … Read more
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) … Read more
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 [temp table]? Select all … Read more
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 … Read more
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> ::= [ { INNER … Read more
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
How to check if a column exists in a SQL Server table?
I need to add a specific column if it does not exist. I have something like the following, but it always returns false: … Read more
How to concatenate text from multiple rows into a single text string in SQL Server
Consider a database table holding names, with three rows: Peter Paul Mary Is there an easy way to turn this into a single … Read more