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. ![]() 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. |