How do I escape a single quote in SQL Server?
Single quotes are escaped by doubling them up, just as you’ve shown us in your example. The following SQL illustrates this functionality. I tested it on SQL Server 2008: Results
tsql
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. You only need to use the CAST operator if you want the result as a Boolean value. If you are happy with an int, this works: CASE statements can be embedded in other CASE statements and even included in aggregates. SQL Server Denali (SQL … Read more
What is the use of GO in SQL Server Management Studio & Transact SQL?
It is a batch terminator, you can however change it to whatever you want
T-SQL split string based on delimiter
May be this will help you.
How do I escape a single quote in SQL Server?
Single quotes are escaped by doubling them up, just as you’ve shown us in your example. The following SQL illustrates this functionality. I tested it on SQL Server 2008: Results
Function to Calculate Median in SQL Server
019 UPDATE: In the 10 years since I wrote this answer, more solutions have been uncovered that may yield better results. Also, SQL Server releases since then (especially SQL 2012) have introduced new T-SQL features that can be used to calculate medians. SQL Server releases have also improved its query optimizer which may affect perf of … Read more
SQL Query with NOT LIKE IN
You cannot combine like and in. The statement below would do the job though:
Function to Calculate Median in SQL Server
2019 UPDATE: In the 10 years since I wrote this answer, more solutions have been uncovered that may yield better results. Also, SQL Server releases since then (especially SQL 2012) have introduced new T-SQL features that can be used to calculate medians. SQL Server releases have also improved its query optimizer which may affect perf of … Read more
T-SQL split string
I’ve used this SQL before which may work for you:- and to use it:-
How can I do an UPDATE statement with JOIN in SQL Server?
Syntax strictly depends on which SQL DBMS you’re using. Here are some ways to do it in ANSI/ISO (aka should work on any SQL DBMS), MySQL, SQL Server, and Oracle. Be advised that my suggested ANSI/ISO method will typically be much slower than the other two methods, but if you’re using a SQL DBMS other … Read more