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
sql-server
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
INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
In your table dbo.Sup_Item_Cat, it has a foreign key reference to another table. The way a FK works is it cannot have a value in that column that is not also in the primary key column of the referenced table. If you have SQL Server Management Studio, open it up and sp_help ‘dbo.Sup_Item_Cat‘. See which column that FK … Read more
Nested select statement in SQL Server
You need to alias the subquery. or to be more explicit
Update multiple columns in SQL
The “tiresome way” is standard SQL and how mainstream RDBMS do it. With a 100+ columns, you mostly likely have a design problem… also, there are mitigating methods in client tools (eg generation UPDATE statements) or by using ORMs
The SQL OVER() clause – when and why is it useful?
You can use GROUP BY SalesOrderID. The difference is, with GROUP BY you can only have the aggregated values for the columns that are not included in GROUP BY. In contrast, using windowed aggregate functions instead of GROUP BY, you can retrieve both aggregated and non-aggregated values. That is, although you are not doing that in your example … Read more
Efficiently convert rows to columns in sql server
There are several ways that you can transform data from multiple rows into columns. Using PIVOT In SQL Server you can use the PIVOT function to transform the data from rows to columns: See Demo. Pivot with unknown number of columnnames If you have an unknown number of columnnames that you want to transpose, then you can use dynamic SQL: See Demo. Using … Read more
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
INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
In your table dbo.Sup_Item_Cat, it has a foreign key reference to another table. The way a FK works is it cannot have a value in that column that is not also in the primary key column of the referenced table. If you have SQL Server Management Studio, open it up and sp_help ‘dbo.Sup_Item_Cat‘. See which column that FK … Read more
Rename column SQL Server 2008
Use sp_rename See: SQL SERVER – How to Rename a Column Name or Table Name Documentation: sp_rename (Transact-SQL) For your case it would be: Remember to use single quotes to enclose your values.