Skip to content

60 Second Dev

60 second software development tutorials and demos, and short blog posts.

  • Blog

60 Second Dev

60 second software development tutorials and demos, and short blog posts.

  • Blog

60 Second Dev

60 second software development tutorials and demos, and short blog posts.

Tag: sql server

2021-08-112022-01-16sql server

Drop Database in SQL Server

 If you’re working locally, building a new app from scratch, you might […]

2021-08-112022-01-16sql server

GZip CLR Functions

Looks like SQL Server 2016 finally introduced a COMPRESS function. If you’re […]

2021-08-112022-01-16sql server

Cursors in SQL Server

Here’s my preferred syntax for a simple one-way readonly cursor: It uses […]

2021-08-112022-01-16sql server

Cursor for update in SQL Server

When you’re working through a cursor, if you need to update each […]

2021-08-112022-01-16sql server

Case-sensitive column in SQL Server

To make a column case-sensitive instead of the default case-insensitive, just add […]

2021-08-112022-01-07sql server

Disable all constraints

Sometimes you just need to disable all constraints on a database. Maybe […]

2021-08-102022-01-16sql server

Basic XML Examples in SQL Server

Select values from an XML column declare @tbl table (id int, xval […]

2021-08-042022-01-14sql server

GUID nonclustered index

Need a globally unique key for a table, but don’t want to […]

2021-08-042022-01-14sql server

Base-64 conversion in SQL Server

create function dbo.ConvertFromBase64String (@Base64Value varchar(max))returns varbinary(max)asbegin return cast(” as xml).value(‘xs:base64Binary(sql:variable(“@Base64Value”))’, ‘varbinary(max)’);end;gocreate function […]

2021-06-232022-01-14sql server

View Job History in SQL Server

create procedure util.ViewJobHistory( @ExecutionDate date = null ,@JobName sysname = null)asbegin declare […]

Posts navigation

Previous 1 2 3 … 6 Next

.net ajax asp.net async authentication aws azure batch brotli c# cloud cryptography css csv deno dependency injection email entity framework exif guid gzip html images javascript jquery json linq linux mercurial mustache mvc nodejs pdf records scss serialization smtp sqlite sql server strings temporal tables typescript windows wsl xml

If you learned something today

Buy Me a Coffee

© 2022 60 Second Dev. Proudly powered by Sydney