Keep it Simple and Smart
There are two new Logical functions are introduced in Denali. Let‘s have a look IFF CHOOSE IFF It Returns one of two values, depending on whether the Boolean expression evaluates to true or false. IIF is a shorthand way for writing a CASE statement. It evaluates the Boolean expression passed
» Read moreRanking functions return a ranking value for each row in a partition. Depending on the function that is used, some rows might receive the same value as other rows. Ranking functions are nondeterministic. There are four functions RANK DENSE_RANK ROW_NUMBER NTILE RANK Â Returns the rank of each row within
» Read moreThe LINQ language extensions allow you to query data in a consistent manner. However, LINQ also includes additions to the .NET Framework itself for working with specific types of data such as relational databases, XML, and objects.These additions allow you to connect to this data, query against it, and insert, update,
» Read moreLINQ stands on Language Integrated Query. LINQ changes the way you access and query data. Before LINQ was created, most queries were expressed as text that was executed against a database. This SQL text was often specific to the underlying technology of the database being queried. LINQ elevates the process
» Read moreOne of most useful feature of Facebook that allow you to download your complete profiles as a backup. This Backup includes all your messages, Wall Posts, photos, status updates and profile information. All you need to do is follow the guide below to get your complete Facebook profile backup (
» Read moreThis book has been authored by Rick A. Morelan. If you are a SQL Developer, you must read the series of this book. Highlights of the Book The Contents of the 2th Volume of the SQL Queries Joes 2 Pros Data information and Tables Query Options Null, Expressions, and Identity
» Read moreMy one friend calls me and asks where I find the Object detail in SQL Server 2008. This is very simple but may be some people are in the same situation and finding the Object Explorer Details in SQL Server 2008. That‘s why here sharing Object Explorer Details and SQL
» Read morePARSE() and TRY_PARSE() are new conversion function introduced in SQL Server Denali. TRY_PARSE() tries to translate the result of an expression to specified data type if the translation is possible, otherwise, it returns NULL. PARSE() tries to translate the result of an expression to specified data type if the translation
» Read moreMicrosoft SQL Server code name ‘Denali’ enables a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization as well as quickly build solutions and extend data across on-premises and public cloud backed by capabilities for mission critical confidence. SQL Server code name ‘Denali’ enables a cloud-ready
» Read moreHow to reset auto number (IDENTITY) column in SQL Server? Sometimes we need to reset the auto number – identity column in a table. Using the DELETE statement is not enough. The statement only deletes the data but not reset the identity column. We can reset the auto number (IDENTITY)
» Read moreVarinder Sandhu is using WP-Gravatar