2012-05-07
2,544 reads
T-SQL
2012-05-03
2,861 reads
Selecting from hierarchies like Managers and Employees
Chuck Hoffman shows a technique using sets for selecting records from hierarchies such as Manager / Employee structures.
2012-05-03
9,713 reads
2012-04-26
3,013 reads
2012-04-24
2,689 reads
Get a range of numbers
If you need to get a range sequence of numbers this script can help you to acomplish it. For example : the sequency of numbers between -5 and 5 or 1 and 200, etc..
2023-07-18 (first published: 2012-04-23)
1,475 reads
2012-05-09 (first published: 2012-04-19)
1,347 reads
2012-04-17
2,640 reads
2012-04-13
3,250 reads
TSQL TestBits function for rapidly testing multiple switch settings
Are multiple binary switches becoming hard to manage? The TestBits function can help with that.
2012-04-09
4,223 reads
Blogs
Why Databases Still Fascinate Me
By Chris Yates
I get asked a lot about why or how I began working with databases...
Monday Monitor Tips: ServiceNow Integration
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
Inspecting TSQL Abstract Syntax Trees
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Forums
How Do I Choose a Good Ophthalmologist in Dubai for Eye Checkups?
Choosing the right Ophthalmologist in Dubai starts with checking credentials, experience with children, and...
SQL Server 2025 Unveiled: The AI-Ready Enterprise Database with Microsoft Fabric Integration
Comments posted to this topic are about the item SQL Server 2025 Unveiled: The...
Cannot get KB959420
Hi, we lost our sever sql2000 To restore database to a new one we...
Question of the Day
The New Database CheckDB
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers