Dynamic Schema name in SQL View – This article will take you through the common SQL errors that you might […]
Tag: sql-server
How to force nolock hint for sql server logins
How to force nolock hint for sql server logins – This article will take you through the common SQL errors […]
When should I use CROSS APPLY over INNER JOIN?
When should I use CROSS APPLY over INNER JOIN? – This article will take you through the common SQL errors […]
converting Epoch timestamp to sql server(human readable format)
converting Epoch timestamp to sql server(human readable format) – This article will take you through the common SQL errors that […]
Use “result expression” from CASE expression in WHERE clause
Use “result expression” from CASE expression in WHERE clause – This article will take you through the common SQL errors […]
How do I drop a foreign key constraint only if it exists in sql server?
How do I drop a foreign key constraint only if it exists in sql server? – This article will take […]
Is it okay to have a lot of database views?
Is it okay to have a lot of database views? – This article will take you through the common SQL […]
Foreign Key Constraint in child table allows to insert values that doesn’t exists in the parent table
Foreign Key Constraint in child table allows to insert values that doesn’t exists in the parent table – This article […]
SQL: do we need ANY/SOME and ALL keywords?
SQL: do we need ANY/SOME and ALL keywords? – This article will take you through the common SQL errors that […]
Replace Unicode characters in T-SQL
Replace Unicode characters in T-SQL – This article will take you through the common SQL errors that you might encounter […]