How can I get a column details and their data type by using stored procedure in SQL server ?

Total Post:73

Points:517
 494  View(s)
Ratings:
Rate this:

Please give me a suitable example for it. 

  1. Post:282

    Points:2008
    Re: How can I get a column details and their data type by using stored procedure in SQL server ?

    If you want to get Stored Procedure Result Column details and datatype Types use the following Script:

    EXEC sp_describe_first_result_set N'YourStoredProcedureName'
    

    If you want to get table Column details and datatype Types or Name use the following Script:

    exec sp_columns yourtablename
    


Answer

Please check, If you want to make this post sponsored

You are not a Sponsored Member. Click Here to Subscribe the Membership.