Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • Sys Commands in SQL

    @asmeen.jahan
    Recommendations Offline Message

    • 0
    • 2
    • 1
    • 1
    • 0
    • 0
    • 0
    • 0
    • 554
    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

    Sys Commands
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           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: