Showing posts with label SQL. Show all posts
Showing posts with label 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:
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...
Saturday, 10 March 2018

Strange behaviour converting NVARCHAR(MAX) to BINARY

›
Few days back I was writing a CLR function to be used for hashing string values. The only option was the CLR functions since T-SQL doesn’t h...
1 comment:
Tuesday, 18 October 2016

Always Encrypted feature in SQL Server 2016

›
With the introduction of SQL Server 2016 in June (Official Final Release), Microsoft had introduced few, new and very useful features in to ...
1 comment:
Sunday, 9 October 2016

Understanding JOINs in SQL Server

›
During my work I get the chance reviewing lots of T-SQL Procedures and Views and I often see that the SQL joins are mis-used in them. When I...
Wednesday, 7 September 2016

Native JSON Support in SQL Server 2016

›
When it comes to modern web development, JSON is one of the well known technologies when you require to exchange information between differe...
3 comments:
Saturday, 13 August 2016

Connecting to an MS SQL Instance using NodeJS (Fixing ConnectionError: Port for SQLServer not found in ServerName & Failed to connect to localhost:undefined in 15000ms)

›
After few debates and discussions on new technologies in the market and how to adapt to them, during the weekend I thought of exploring Node...
1 comment: