Lab Sql

I created a simple table as below: create table table1 ( col1 float(1), col2 float ) When I check … Read more On Creating A Table Column Of Type "float With Precision" Column Gets Created As "real" Type In Sql Server

I have a table that is used to log events. Two types specifically : ON and OFF. There are sometimes… Read more Find Next Record Where Status Field Is Different From Current

I need to find a continuous date in a string from column name Filename. The string has other number… Read more Tsql: Find A Date With Varying Characters In A String

I'm very familiar with the process of exporting from Azure SQL V12 down to my dev box and then … Read more Cannot Import Sql Azure Bacpac To 2016 Ctp

I have JSON in a field, but I need to check it's schema before I process it. I need to know if … Read more Find Json Schema In Sql Server

I have a stored procedure where I am getting the database name from a table and then trying to crea… Read more How To Loop A Query That Is Created Dynamically In Sql Server