All Columns from user tables and views
This script lists the columns with type and length. It eliminates system tables.
2001-12-13
751 reads
List all primary keys
Thanks to Raul Sharma for his brilliant ideas. This is a modification of one of his scripts. The script takes only the user tables. Those tables which does not have PK are not listed!
2001-12-13
719 reads
Blogs
Goal Progress–November 2020
By Steve Jones
This is my report, which continues on from the Oct report. It’s getting near...
Azure Synapse Analytics is GA!
By James-Serra
(Note: I will give a demo on Azure Synapse Analytics this Saturday Dec 5th...
5 Things You Should Know About Azure SQL
By John
Azure SQL offers up a world of benefits that can be captured by consumers...
Forums
Get data from last line and merge into data stream before removing
This script reads thru a file and removes the last line, but before it...
Firewall access for Availability Group listeners
Hello experts, I have a noob question as I never feel like I understand...
conversion of excel formula to case statement in tsql
Hi all, need your help on conversion of excel formula into case statement. i...
Ask SSC