INFORMATION_SCHEMA.101
Get information about the objects in your database using these ANSI standard, multi-platform views.
2011-10-04
6,109 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,584 reads
2008-03-03
12,648 reads
Blogs
T-SQL Tuesday Live–7 Apr 2020
By Steve Jones
Last week went a little crazy, and I learned something: don’t post a Zoom...
Getting Your dbatools Version–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
SQL Server and VMware Resource Pools
By kleegeek
Resource pools are used to hierarchically partition available CPU and memory resources, and are...
Forums
Tools for DISA's SQL Server STIGs
Is it possible to request a review of a tool I created to automate...
bcp format file and import fixed width text file
I'm trying to set up a format file using bcp but I'm unsure of...
insert random value from predefined list of possible values
Hi all, My need is to insert random value from predefined list of possible...
Ask SSC