|
|
-
Shivendra Kumar Yadav Liked 2 Years ago through What is New | 1 Point
`sp_describe_undeclared_parameters` is a new system stored procedure added in SQL Server 2012 (Denali). It returns a result set that contains metadata about undeclared parameters in a Transact-SQL batch.
*The following excerpt is taken from MSDN doc...
|
-
Shivendra Kumar Yadav Liked 2 Years ago through What is New | 1 Point
SQL Server 2012 enhanced the `EXECUTE` statement with an additional clause `WITH RESULT SETS` which allows you to convert/alter the columns and data types of the results produced by the `EXECUTE` statement.
Assume that your stored procedure returns ...
|
-
Shivendra Kumar Yadav usenow 2 Years ago through What is New | 1 Point
SQL Server 2012 enhanced the `EXECUTE` statement with an additional clause `WITH RESULT SETS` which allows you to convert/alter the columns and data types of the results produced by the `EXECUTE` statement.
Assume that your stored procedure returns ...
|
-
Shivendra Kumar Yadav Commented 2 Years ago through What is New | 1 Point
It's Good Ram
but, I have a doubt here the 4th column "Last5YrsRevenue"
should be "Next4YrsIncludingCurrentYrRevenue"...
|
|
|
|
|
-
Shivendra Kumar Yadav Liked 2 Years ago through What is New | 1 Point
PERCENT_RANK() function will returns the percentage value of rank of the element among its group.
PERCENT_RANK() function value will be
1. For first element in its group, it will be 0.
2. For last element in its group, it will be 1.
3. For remain...
|
-
Shivendra Kumar Yadav Liked 2 Years ago through What is New | 1 Point
Find out the new features and enhancements added into SQL Server 2012, codenamed "Denali"...
|