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.

Category: sql server

2022-03-312022-05-07.net, sql server

ArithAbort in ADO.NET

Don’t ask me to explain it, but setting ARITHABORT in SQL Server […]

2022-01-282022-05-08sql server

SQL Server Error Handling

From the incredible website of Erland Sommarskog – Definitely a worthwhile read. […]

2021-08-182022-05-08sql server

SQL Server Numbers table

2021-08-182022-05-10sql server

Flatten in SQL Server

2021-08-182022-05-10sql server

Convert UTC to local time in SQL Server

Thanks to this StackOverflow answer:

2021-08-172022-05-12sql server

SQL Dates Table

2021-08-172022-05-12sql server

SQL Merge Insert/Update with output

2021-08-112022-01-16sql server

Is string an integer in SQL Server

SQL Server 2008 doesn’t yet have the TRY_PARSE function, so safely converting […]

2021-08-112022-01-16sql server

Insert with output in SQL Server

This can be an alternative to things like SCOPE_IDENTITY() or @@IDENTITY. declare […]

2021-08-112022-01-16sql server

Drop Database in SQL Server

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

Posts navigation

1 2 … 5 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