Count and display number of rows in all tables
This script can be used to display the number of rows of all the tables in a database.
2003-01-02
299 reads
Script to get tables which have primary key
There isn't a convenient sp or tool in sql server to find out all the tables in a database which have primary keys. This script can help you to list all the tables with primary keys.
2002-10-21
431 reads
Blogs
Upgrading SQL Server 2017 Containers to 2019 non-root Containers with Data Volumes – Another Method
Yesterday in this post I described a method to correct permissions when upgrading a...
Power Platform Quick Tips – Episode 02: Dynamic Power Apps Form Headers
By Devin-Knight
Welcome back to my Power Platform Quick Tips series! In this second episode we...
Simple-Talk Article…Understanding Azure Storage Options
Simple- Talk is technical journal and community hub from Redgate. This week I have the pleasure of...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
Random number in results searching IDNUMBER >= '1000205830' and IDNUMBER
IDNUMBER >= '1000205830' and IDNUMBER <= '1000206010' ORDER BY ID_NUM DESC I'm also getting...
how to create triggers with delete and update
how to create triggers with delete and update i have a table called dbo.OrderDetail...
Ask SSC