2017-05-25
1,043 reads
T-SQL
The OUTPUT Clause for INSERT and DELETE Statements
In this article, I will provide a set of examples to show case the use of OUTPUT clause for INSERT and DELETE statements.
2019-03-15 (first published: 2017-05-25)
294,880 reads
Some of my greatest mistakes
You are never too experienced to make mistakes. An occasional dose of humble pie serves as a reminder to up our game.
2019-07-05 (first published: 2017-05-18)
10,440 reads
2017-05-02
1,361 reads
OUTPUT Clause Basics (For Inserts and Deletes)
When INSERTING or DELETING rows from a table, the OUTPUT clause can be used to return a dataset containing the changes made. Mat Richardson explains how.
2019-12-27 (first published: 2017-05-02)
9,694 reads
2017-04-24
1,117 reads
Should I Type * or 1 With the EXISTS Logical Operator
In my project I see that people writes different things with EXISTS logical operator (EXISTS (SELECT StarOrOne FROM...)). They are "*", "1" and even "TOP 1 1" or "TOP 1 *". The aim of this article to give a good explanation which option is the best.
2020-01-24 (first published: 2017-04-24)
14,824 reads
2017-04-21
1,238 reads
2017-04-14
1,194 reads
Nuance of datetime data type in SQL Server
One of the most confusing data types in SQL Server is the datetime datatype.
2017-04-13
2,312 reads
Blogs
Privacy Policy
We value your privacy. This policy explains what personal data we collect and why. What...
Why use XACT_ABORT?
This came up one day at my work when a developer was using it....
Using AI for Data Conversion
I’m sure I’ve never mentioned that I’m an amateur radio operator. Like Vegans and...
Forums
sp_lock memory leak
I spotted this in the release notes for CU17 in SQL Server 2022: KB3616559...
Migration related issue
I migrated DB server from 2017 enterprise to 2019 enterprise. After the migration, every...
How Much AI Code Would You Use?
Comments posted to this topic are about the item How Much AI Code Would...
Question of the Day
Browsing for Instances
I have a SQL Server instance that is not listening for connections on port 1433. By default, all ports are locked down on my server, except for the SQL Server port. What can I do to allow users to connect to the instance without knowing the port?
See possible answers