![]() SELECT * FROM sys. SOLUTION 1 : For SQL Server 2012 and above using sys.dm_exec_describe_first_result_set However, I could not find a proper solution like sys.dm_exec_describe_first_result_set in the earlier version of SQL Server. In the Password field, type a password for the user. On the General page, in the Login name field, type the name for a new user. Click Serverinstancename > Security > Logins. Today, I came across an issue when I tried to get the metadata of a stored procedure in earlier version of SQL Server and wanted to use the list of columns for further manipulations. In the SQL Server Management Studio, open Object Explorer. (A new dynamic management view shipped with SQL Server 2012), it is very handy when you need to know the metadata of the first possible result set of any Transact SQL. In my earlier articles, I wrote about sys.dm_exec_describe_first_result_set
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |