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

Total Post:87

Points:615
 537  View(s)
Ratings:
Rate this:

Please give me a suitable example for it. 

  1. Post:286

    Points:2044
    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.