INFORMATION_SCHEMA.101
Get information about the objects in your database using these ANSI standard, multi-platform views.
2011-10-04
6,317 reads
INFORMATION_SCHEMA
Query-generated Column Expressions
A technique from Bill Nicolich that allows you to target columns by data type for the same custom expression and easily build complex queries.
2010-05-25
8,595 reads
2008-03-03
14,070 reads
Blogs
Scary Scalar Functions - Part Two: Performance
By Zikato
Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Foreword In the second part of this...
Goal Progress for June 2022
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
Using Sessionize for Your User Group – Part 2
Now that your CFS has been setup it’s time to get the word out...
Forums
The July Fourth Anniversary
Comments posted to this topic are about the item The July Fourth Anniversary
Independence Day 2022
Comments posted to this topic are about the item Independence Day 2022
Employee Hierarchy Recursive CTE Different Top Level Directors Overtime
Hi, I have looked at some examples of Employee > Manager Hierarchy using Recursive...
Ask SSC