Sql Result Set Data Type. Sp_describe_first_result_set guarantees that if the procedure returns the first result-set metadata for a hypothetical batch A and if that batch A is subsequently executed then the batch will either 1 raises an optimization-time error 2 raises a run-time error 3 returns no result set or 4 returns a first result set with the same metadata described by sp_describe_first_result_set. It is very helpful when for any particular requirement you need to.
A data type is a set of representable values. Sp_describe_first_result_set guarantees that if the procedure returns the first result-set metadata for a hypothetical batch A and if that batch A is subsequently executed then the batch will either 1 raises an optimization-time error 2 raises a run-time error 3 returns no result set or 4 returns a first result set with the same metadata described by sp_describe_first_result_set. DECLARE Local_Variable_1 Local_Variable _2 SELECT Local_Variable _1 SELECT from where Rules.
SQL Server 2012 has released a new feature WITH RESULT SETS which allows column names and their data types to be changed in the result set of a stored procedure.
A script for data creation can be found in the code for this guide. You can use these data types while creating your tables. Otherwise the query will throw an error. The EMPLOYEE table stores one result Entity object.