|
|
-
|
|
This function accepts 3 parameters
1. Boolean Expression to Evaluate.
2. Expression to evaluate if Boolean expression is true.
3. Expression to evaluate if Boolean expression is false.
If the specified boolean expression is TRUE then it returns the re...
|
|
-
|
|
CHOOSE() function will returns the value based on the specified index from the list of values.
Example
DECLARE @Index INT,
@FirstValue VARCHAR(10),
@SecondValue VARCHAR(10),
@ThirdValue VARCHAR(10)
SET ...
|
|
-
|
|
This function returns a fully qualified DATETIME value based on the specified datetime parts such as year, month, day, hour, minute, seconds and milliseconds.
Example
DECLARE
@Year INT = 2011,
@Month INT = 11,
@Day INT = 29,
@Hour INT ...
|
|
-
|
|
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...
|
|