Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • Sys Commands in SQL

    • 0
    • 2
    • 1
    • 1
    • 0
    • 0
    • 0
    • 0
    • 552
    Comment on it

    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 'Procedures
    Name'

    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 'Table
    Name'

    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

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: