![]() If set to 2, each query is analyzed as if it would be used in preparingor executing a cursor.This will return base table names as the sourcecolumn information. If set to 1, each query is analyzed as if it includes a FOR BROWSEoption on the query.If set to 0, no information is returned.Additional key columns and source table informationare returned. If set to 1, each query is analyzed as if it includes a FOR BROWSEoption on the query. Specifies if additional key columns and source table information arereturned. ![]() Parameters may be nvarchar(n)or nvarchar(max). It provides a declaration string for parameters for the Transact-SQLbatch, which is similar to sp_executesql. The DMF sys.dm_exec_describe_first_result_set was introduced in SQL Server 2012.This function has the following parameters: and table below has the descriptions of the parameters as found at the followingMicrosoft helplink.
0 Comments
Leave a Reply. |