SQL Logs - Search localsearch

stackoverflow.com

https://stackoverflow.com/questions/87821/sql-if-c…

SQL: IF clause within WHERE clause - Stack Overflow

Is it possible to use an IF clause within a WHERE clause in MS SQL? Example: WHERE IF IsNumeric(@OrderNumber) = 1 OrderNumber = @OrderNumber ELSE OrderNumber LIKE '%' + @

stackoverflow.com

https://stackoverflow.com/questions/63447/how-do-i…

How do I perform an IF...THEN in an SQL SELECT?

The CASE statement is the closest to IF in SQL and is supported on all versions of SQL Server.

stackoverflow.com

https://stackoverflow.com/questions/194852/concate…

sql - Concatenate text from multiple rows into a single text string ...

Consider a database table holding names, with three rows: Peter Paul Mary Is there an easy way to turn this into a single string of Peter, Paul, Mary?

stackoverflow.com

https://stackoverflow.com/questions/141562/sql-to-…

SQL to find the number of distinct values in a column

SQL to find the number of distinct values in a column Asked 17 years, 2 months ago Modified 2 years, 7 months ago Viewed 826k times

stackoverflow.com

https://stackoverflow.com/questions/1781946/gettin…

Getting only Month and Year from SQL DATE - Stack Overflow

I need to access only Month.Year from Date field in SQL Server.

stackoverflow.com

https://stackoverflow.com/questions/20923015/login…

I am getting this error while trying to connect to the SQL Server. Microsoft SQL Server Error: 18456 Can anybody tell me what the error code means?

stackoverflow.com

https://stackoverflow.com/questions/39231102/sql-r…

SQL Replace multiple different characters in string

SQL Replace multiple different characters in string Asked 9 years, 3 months ago Modified 1 year, 4 months ago Viewed 224k times

stackoverflow.com

https://stackoverflow.com/questions/15029860/how-t…

How to convert a datetime to string in T-SQL - Stack Overflow

In addition to the CAST and CONVERT functions in the previous answers, if you are using SQL Server 2012 and above you use the FORMAT function to convert a DATETIME based type to a string.

stackoverflow.com

https://stackoverflow.com/questions/520967/databas…

sql server - Database stuck in "Restoring" state - Stack Overflow

Ran into a similar issue while restoring the database using SQL server management studio and it got stuck into restoring mode. After several hours of issue tracking, the following query worked for me.

stackoverflow.com

https://stackoverflow.com/questions/1521605/select…

sql - Selecting COUNT (*) with DISTINCT - Stack Overflow

In SQL Server 2005 I have a table cm_production that lists all the code that's been put into production. The table has a ticket_number, program_type, program_name and push_number along with some ot...