I have a SQL script that has to update a field in a table but the field name is a row in another table could you please help.

Mostly developers need to transfer data from one table to another. For this purpose we have two scenarios.

Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.

In this blog your will how to save an image in sql Server 2005 with unique key.

In this article your will how to select from stored procedure dynamically.

How to insert values in identity column in SQL Server. Identity columns are used to automatically assign new incremented value to identity column when new record inserted based on previous value in...

This is a function which return number of weekends between two dates using sql datepart function.

How to find second highest salary in SQL Server.

Bulk Insert into table using User-Defined Table Type using store proceduew

Create Temp Table and Insert Data in to Temp Table using Dynamic Query

In this blog you will learn import excel data into SQL temp table.

In this article I will describe Insert Data Into Identity columns of Table in SQL Server.

In this article i will describe how to Break Circular dependence between table in SQL Server.

In this blog I have explained in brief about the Types of Stored Procedure in Sql Server.

Here SQL SERVER Practical Scenario for joins and aggregate functions.

Due to the lack of mechanisms, DBA generally do mistakes to maintain data quality:

In this blog I am going to explain that how can do add, rename and drop a column from a table.

In this blog I am going to explain that how can get Maximum and Minimum integer number using user defined Scalar-valued functions in sql server 2008

In this blog I am going to explain difference between VARCHAR and NVARCHAR.

Sometimes it required to execute the packages from SSMS after deploying it to SSISDB catalog in SQL Server. But what if we want to interrupt the execution in the middle or when package stops the pr...