sql server - How do I perform an IF...THEN in an SQL SELECT?
Sep 15, 2008 · The CASE statement is the closest to IF in SQL and is supported on all versions of SQL Server.
List the queries running on SQL Server - Stack Overflow
Is there a way to list the queries that are currently running on MS SQL Server (either through the Enterprise Manager or SQL) and/or who's connected? I think I've got a very long running …
How to implement LIMIT with SQL Server? - Stack Overflow
I have this query with MySQL: select * from table1 LIMIT 10,20 How can I do this with SQL Server?
How do I see active SQL Server connections? - Stack Overflow
Jan 21, 2019 · I am using SQL Server 2008 Enterprise. I want to see any active SQL Server connections, and the related information of all the connections, like from which IP address, …
How can I list all foreign keys referencing a given table in SQL …
Jan 27, 2009 · I need to remove a highly referenced table in a SQL Server database. How can I get a list of all the foreign key constraints I will need to remove in order to drop the table? (SQL …
SQL query to select dates between two dates - Stack Overflow
Feb 26, 2011 · SQL Server defaults a date without a time to 00:00:00. So won't this query return anything from 2011/02/25 and 2011/02/26 at midnight?
Create Local SQL Server database - Stack Overflow
Apr 11, 2017 · After installation you need to connect to Server Name : localhost to start using the local instance of SQL Server. Once you are connected to the local instance, right click on …
Unable to login to SQL Server + SQL Server Authentication + Error ...
I have created login account on my localhost\\sql2008 Server (Eg. User123) Mapped to Database (default) Authentication Mode on SQL Server is set to both (Windows and SQL) But login to …
sql server - Simple way to transpose columns and rows in SQL?
How do I simply switch columns with rows in SQL? Is there any simple command to transpose? ie turn this result: Paul | John | Tim | Eric Red 1 5 1 3 Green 8 ...
How to find server name of SQL Server Management Studio
Apr 18, 2013 · I installed Microsoft SQL Server 2008. When I start SQL Server Management Studio (SSMS), I get the Connect to Server login window with a blank textbox for Server …