|
|
-
|
|
This function return a fully qualified TIME value based on the specified time parts such as hour, minute, seconds, fractions and precision .
The fraction value depends on the Precision value.
Example
DECLARE @Hour INT,
@Minute INT, ...
|
|
-
|
|
This function return a fully qualified DATE value based on the specified date parts such as year, month and day.
Example
DECLARE @Year INT,
@Month INT,
@Day INT
SET @Year = 2011
SET @Month = 11
SET @Day = 29
...
|
|
-
|
|
This function format the input value based on the specified format and optional culture input. If the culture value is not specified, then the language of the current session is used. This can be used to format the numbers and datetime values into requ...
|
|
-
|
|
SQL Server 2012 (Denali) no more supports the following backup commands.
- BACKUP DATABASE WITH PASSWORD
- BACKUP LOG WITH PASSWORD
- BACKUP DATABASE WITH MEDIAPASSWORD
- BACKUP LOG WITH MEDIAPASSWORD
However, RESTORE { DATABASE | LOG } WITH [...
|
|
-
|
|
The NEAR operator in the CONTAINS predicate is improved in SQL Server 2012 (Denali) to allow users to specify distance between two terms.
This allows a user to run queries such as:
SELECT candidate_name
FROM Candidates
WHERE CONTAINS(
...
|
|
-
|
|
The following excerpt is taken from the FTS team blog which explains new Full Text Search enhancements added to SQL Server 2012 - Denali.
> Besides performance and scale improvement, we also added support for property scoped searches over documents wi...
|
|
-
|
|
`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 docume...
|
|
-
|
|
The SQL Server columnstore index feature, code-named **Apollo**, stores data by columns instead of by rows, similar to a column-oriented DBMS. The columnstore index speeds up data warehouse query processing in SQL Server 2012 in many cases by a factor o...
|
|
-
|
|
Yet another Dynamic Management Function (DMF) introduced by SQL Server 2012 is `sys.dm_exec_describe_first_result_set_for_object`. The functionality is the same as [`sys.dm_exec_describe_first_result_set`][1], except that this function takes an `Object ...
|
|
-
|
|
SQL Server 2012 introduces a new Dynamic Management Function (DMF) which allows us to examine the metadata of the result set of a query, stored procedure etc.
This is very handy to examine the number of columns, column names, data types etc which is ot...
|
|