about 9 years ago
Sys Commands :
1) How to count number of procedures in a table
USE [Database_Name] SELECT COUNT(*) as procedures FROM sys.procedures
2) How to get the attributes of procedure in a table
USE [DatabaseName] SELECT * FROM sys.procedures where name LIKE 'ProceduresName'
3) How to count number of tables in a database
USE [Database_Name] SELECT COUNT(*) FROM sys.tables
4) How to get the attributes of table in a database
USE [DatabaseName] SELECT * FROM sys.tables where name LIKE 'TableName'
5) How to count number of database
select COUNT(*) FROM sys.databases
6) How to get the attributes of database
SELECT * FROM sys.databases where name LIKE 'Database_Name'
7) How to count number of servers
select COUNT(*) from sys.servers
Starting with Chrome version 45, NPAPI is no longer supported for Google Chrome. For more information, see Chrome and NPAPI (blog.chromium.org).
Firefox and Microsoft Internet Explorer are recommended browsers for websites using java applets.
Chrome Version Support
Are you sure, you want to delete this comment?
Sign up using
0 Comment(s)