Passing parameters to query without TVFs

This article looks at an interesting way to help your users get filtered data from a TVF instead of using a stored procedure or specialized view.

Capturing Data Changes

If you capture data changes with the OUTPUT clause, let us know today.

Decoding Set Options

ChatGPT in SQL Server - Practical examples

Introduction ChatGPT in SQL Server In this article, we will learn some basic examples of ChatGPT in SQL Server. In a previous article, we had an interview with ChatGPT an AI chatbot developed by OpenAI. If you do not know how to use it yet, you can go to that article. We will show some […]

Dropping One Table

Cross Database Context

Dropping Columns

A NOT NULL Default

Manage Data Over Time with SQL Server MERGE Statement

Once data is in a table it needs to be maintained....

The Growth of T-SQL

I saw this tweet recently, where Richie Rump asked what has changed in T-SQL since the SQL Server 2012 version. A few people from Microsoft responded that there were changes in all versions, and while I think some versions have few changes, I decided to look. SQL Server 2012 introduced the window functions with the […]