Sep 15, 2008 · The CASE statement is the closest to IF in SQL and is supported on all versions of SQL Server. SELECT CAST( CASE WHEN Obsolete = 'N' or InStock = 'Y' THEN 1 ELSE 0 …

I have this query with MySQL: select * from table1 LIMIT 10,20 How can I do this with SQL Server?

Feb 13, 2020 · Beginning with SQL Server Management Studio (SSMS) 18.7, Azure Data Studio is automatically installed alongside SSMS. Source Update: Actually Azure Data Studio is in …

Apr 6, 2017 · 96 I have downloaded the SQL Server Management Studio (SSMS) 2016 to recover a huge .bak file which is an old backup of a database. But first of all I need to connect to a DB …

Mar 21, 2014 · How can I connect to SQL Server from command prompt using Windows authentication? This command Sqlcmd -u username -p password assumes a username & …

Sep 26, 2008 · Is there a query in SQL Server 2005 I can use to get the server's IP or name?

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

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 …

Nov 9, 2012 · How can I send an email using T-SQL but email address is stored in a table? I want to loop through the table and be able to send email. I cannot find a good example of doing this …

Simple question, how do you list the primary key of a table with T-SQL? I know how to get indexes on a table, but can't remember how to get the PK.