In SQL Server 2008, you can perform insert, update, or delete operations in a single statement...
Fresh Topics for Beginner
SQL Server
How to create MERGE statement with variable in SQL Server
What is rowversion in SQL Server?
In this post, we want to discuss about efficient technique to learn or use Rowversion in SQL Server...
How to add a Linked Server in SQL Server
In this article, we discuss about How to add Linked Server in SQL Server. There are two ways to add...
Search string value in all columns of a table in SQL Server
In this article, we want to discuss about a nice function to Search String Value in all Columns of...
Table type Parameters in SQL Server
This is a new feature intorduced in Sql Server 2008. Table-Valued Parameters provides option for...
Function to Convert Text String to Title Case – Proper Case
In this post, we want to discuss about a nice function to convert text to title case (Proper Case)...
Microsoft SQL Server All Versions Product Keys Collection
In this post, we want to share product keys of MSSQL (Microsoft SQL Server) all versions. Before we...
SQL: Can you use multiple columns for NOT IN
In this post, we want to discuss about a nice function to use multiple columns for NOT IN in SQL...
What is difference between UNION vs UNION ALL?
This example teaches us core concept that UNION doesn't depend upon column name but the data. You...
Send DataTable as parameter through Stored Procedure in MSSQL
You can add, modify, and delete operations on a set of records in the database using a simple form...
Interview QA
SQL Server Transaction Log Interview Question
In this article, we will discuss some important SQL Server Transaction Log interview question that...
Android Tutorials
Variables and Data Types in Java
In short Variable is name of reserved area allocated in memory. In other words, it is a name of...
