SQL Tips

  • Check if a column contains a string

SELECT [DatabaseId],[Category]
FROM [dbo].[SomeTable]
Where Category LIKE '%theString%'

  • Run a sql command multiple times

  INSERT INTO [dbo].[SomeTable] (
   	Type, Message,	Time
)
VALUES
    (
	'some type',' some message', '2022-04-27 09:51:22.0000000 +01:00'
	)
	
GO 10000000

  • Select all rows where a column value is not empty and not null

SELECT *
FROM [dbo].[SomeTable]
WHERE [TextColumnName]!='' AND [TextColumnName] IS NOT NULL

  • Select all records where a column value occurs more than once

SELECT  SomeColumn, COUNT(*) 
FROM [dbo].[SomeColumn]
group by SomeColumn
HAVING COUNT(*) > 1

  • Get the value of a property from JSON column

SELECT  JSON_VALUE(JsonColumnName,'$.propertyInsideJSON') as propertyInsideJSON
FROM  [dbo].[SomeTable]

  • Update the value of a property from JSON column

SELECT  JSON_MODIFY(JsonColumnName,'$.propertyInsideJSON') as propertyInsideJSON
FROM [dbo].[SomeTable]