During my work I get the chance reviewing lots of T-SQL Procedures and Views and I often see that the SQL joins are mis-used in them. When I enquire the developers regarding this, it’s evident that most of the time it has been the case that they don’t have the proper understanding what each JOIN exa
We will create a Table and Stored Procedure in Sql Server 2008R2 and data will be inserted and retrieved by using Asp.net using C#
An introduction on how to store and retrieve images from SQL Server 2008 by using Stored Procedures and C#.
This article explains creating and using SQL Stored Procedure in SQL Server.
Friends, Today working with SQL Server I was trying to restore a DB from.bak file and got a strange error while restoring using the normal procedure. I was working on SQL Server 2008 R2 and the backup was from an old version making ...