One size does not fill all
Allowing your application to generate your SQL can be a really bad decision.
2014-03-06
201 reads
T-SQL
Stairway to T-SQL: Beyond The Basics Level 3: Building a Correlated Subquery
This stairway level will expand on the subquery topic by discussing a type of subquery known as a correlated subquery, and explores what a correlated subquery is and how it is different from a normal subquery.
2019-05-08 (first published: 2014-03-05)
20,654 reads
2014-03-04
2,385 reads
2015-03-25 (first published: 2014-02-25)
8,433 reads
2014-02-24
2,487 reads
A Quick Tour of sp_ExecuteSQL
sp_ExecuteSQL can be used to dynamically execute T-SQL code. Learn how to use it and how to add parameters to control what code is executed.
2014-02-24
10,572 reads
2014-02-19
2,649 reads
2014-02-13
2,612 reads
2014-02-12
2,581 reads
2014-02-10
2,456 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers