|
|
-
|
|
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...
|
|
-
|
|
CONCAT function can be used to concatenate two or more strings. This function is available before in other databases like Oracle,MySQL etc. This feature will offer below advantages over standard concatenation operator(+)
- If any of the string is nul...
|
|
-
|
|
The new SEQUENCE type in SQL Server 2012 will allows you to create sequential numbers. In general identity columns can be used to uniquely identify records in a table. But if we wants to maintain identity columns across multiple tables, or if we need th...
|
|
-
|
|
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 an ...
|
|
-
|
|
The new pagination support allows you to write queries that can return rows from specific position of the result set. For example: the following query returns rows 20 to 30 from the result set.
SELECT
*
FROM Customers
ORDER BY CustID ...
|
|