|
|
-
|
|
SQL Server 2012 (Denali) discontinued support for SQL Mail. Database Mail feature is the suggested alternative to send emails from SQL Server. ...
|
|
-
|
|
SQL Server 2012 Denali does not support VIA protocol any more. Books Online suggests to use TCP instead of VIA protocol....
|
|
-
|
|
Code snippets is one of the very important feature that has been added in SQL Server 2012 SSMS, which greatly improves productivity. In SQL Server 2012, now you can create your own snippets and insert that snippets in your queries/stored procedures by u...
|
|
-
|
|
We often use some external tools to manage our task list, where we will add our tasks and will follow the tasks according to the task list. Now with SQL Server 2012, external tool is no longer required.
SQL Server 2012 provides task list, where we can ...
|
|
-
|
|
SQL Server 2012 SSMS has a new node “Sequences” in object explorer under Database-> programmability. This will allows you to create new sequences or update existing sequences by using GUI.
1. Go to Object Expolorer -> Expland database -> Programmabil...
|
|
-
|
|
Often in stored procedures/queries, we will use IF, BEGIN..END, WHILE statements. Now, In SQL Server 2012, SSMS provides an option “Surround with”, which simplifies in enclosing query statements with these blocks.
1. Right Click and choose “Surround w...
|
|
-
|
|
Often in various applications, we need the last date of a month. Previously we used to write various tricks to get this. SQL Server 2012 now provides a function EOMONTH(), which returns the last date of month of given date.
Example:
SELECT EOMONTH...
|
|
-
|
|
Parse() function will parse an value into specified datatype. This function relies on CLR. It will take some performance overhead. Use this function only
to convert strings to/from datetime and numeric values.
Example:
SELECT PARSE('Monday, 13 D...
|
|
-
|
|
If the parse operation is successful, this function returns the resultant value; Otherwise, it returns NULL value. This function will rely on CLR. Its advisable to use this function only to convert strings to/from datetime/numbers.
SELECT TRY_PARSE...
|
|
-
|
|
Often in queries, we can see conversion errors like "conversion failed when converting from .... " If we wants to hide these errors and instead of exception, if we want a NULL value, we can use this TRY_CONVERT() function.
If the cast is successful, th...
|
|