Showing posts with label
T-SQL
.
Show all posts
Showing posts with label
T-SQL
.
Show all posts
Friday, 10 May 2019
Strange behavior on JSON_VALUE when table contains blank and non-blank values (JSON text is not properly formatted. Unexpected character '.' is found at position 0.)
›
Few days back we had a requirement to search whether a certain value exists in one of the table fields where the values are stored as JSON ...
6 comments:
Friday, 6 July 2018
Replacing sp_depends with sys.dm_sql_referencing_entities and sys.dm_sql_referenced_entities
›
sp_depends have been one of the most used system stored procedures in SQL Server. Infact many of us still use that even though Microsoft had...
Wednesday, 30 May 2018
Computed columns in SQL Server
›
Computed columns are type of columns which the values are derived based on one or more other columns. Hence the data type on the computed c...
Tuesday, 23 August 2016
DROP IF EXISTS in SQL Server 2016 (DIE)
›
Prior to SQL Server 2016, when we need to drop a SQL Object, it's the best practice to check whether the respective object exists or ...
›
Home
View web version
