2011-03-16
3,169 reads
T-SQL
SQL Server CASE Law
SQLs CASE expressions can be powerful magic, but can trap the unwary that are used to the more familiar CASE statements of procedural languages.
2011-03-14
6,011 reads
2011-03-11
2,646 reads
The EXCEPT and INTERSECT Operators in SQL Server
The UNION, EXCEPT and INTERSECT operators of SQL enable you to combine more than one SELECT statement to form a single result set. Rob Sheldon explains all, with plenty of examples.
2011-03-10
6,323 reads
Displaying Sorted Hierarchies (SQL Spackle)
Learn how you can query a hierarchy of data and also return the results in an ordered fashion. A handy T-SQL skill that you will use over and over again.
2024-08-02 (first published: 2011-03-10)
24,289 reads
2011-03-08
2,597 reads
2011-02-28
3,549 reads
Top 10 Transact-SQL Statements a SQL Server DBA Should Know
Microsoft SQL Server is a feature rich database management system product, with an enormous number of T-SQL commands. With each feature supporting its own list of commands, it can be difficult to remember them all. MAK shares his top 10 T-SQL statements that a DBA should know.
2011-02-24
11,251 reads
2011-02-15
3,253 reads
Automatically Generate Stored Procedures
This article will show you how to automatically generate insert, update, and delete procedures for tables in your database
2013-01-01 (first published: 2011-02-10)
30,531 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