sql Archives - Page 30 of 45

I have a SQL table with a datetime field. The field in question can be null. I have a query and I want ...

This question already has answers here: Is there a combination of “LIKE” and “IN” in SQL? (25 answers) Closed 8 years ago. Is ...

I have a query which works fine in MySQL, but when I run it on Oracle I get the following error: SQL Error: ...

How can I have a dynamic variable setting the amount of rows to return in SQL Server? Below is not valid syntax in ...

I would like to write a single SQL command to drop multiple columns from a single table in one ALTER TABLE statement. From ...

Inspired by this question where there are differing views on SET NOCOUNT… Should we use SET NOCOUNT ON for SQL Server? If not, ...

I am using SQL Server 2008 Enterprise. I want to see any active SQL Server connections, and the related information of all the ...

In Microsoft SQL Server how can I get a query execution plan for a query / stored procedure? 13 Answers 13

Is there a way in SQL Server Management Studio 2005 (or later) to change the Windows Authentication user (as you could in SQL ...

What is the general guidance on when you should use CAST versus CONVERT? Is there any performance issues related to choosing one versus ...