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 ...

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 ...

Silverlight applications provides option for ‘openFileDialog’ and ‘SaveFileDialog’ class to save and open file in silverlight application. OpenFIleDialog by default opens the documents and settings (user specific folder) whereas SaveFileDialog allows ...

While displaying a long word, some times it might broken into next line at wrong location. By using "wbr" tag, we can control the the places long word can be broken into next line. Suppose to display a word "FailOverClustering", if the word breaks a...

In HTML 5, Keygen tag has been introduced, which generates a pair of public key and private key. When the form is submitted, it stores the private key in local machine and sends the public key to server. Server can generate a certificate with public ...

By using Multi-server query, we can execute a query against multiple servers at a time. In Central Management server, register the available servers. Then executing the query against the group will execute in all the servers registered against the gr...

"datagrid" tag creates a table that is built from a database or other dynamic source. Now this tag has been removed from HTML 5 specifications....

Explore the new features and enhancements added to SQL Server 2008...

Visual Studio now came up with faster intellisense support. It is now 2-5 times faster than the earlier versions. It also has few functional enhancements. 1. In Visual Studio 2008, if we type the word, "test", intellisense will show only the members...

VS2010 came up with the excellent feature of generating codes for you. Suppose, if you write a method, which does not exists, You can simply put cursor on method name, press "Ctrl+.", which automatically generates the method signature. ![alt text][...