Friday, March 4, 2016

How to get schema from stored procedure sql server

ADO.NET

DataTable schema = reader.GetSchemaTable();

SQL


SELECT * FROM sys.dm_exec_describe_first_result_set ('qualified.storedprocname', @params, 0) ;

No comments:

Post a Comment