dominos coupon code

shopclues coupon code today

amazon coupon codes india

cleartrip coupons for domestic flights

Promo code offers

SQL

How to install SQL Server 2014 ?

sql-logo-no-version

Step by Step to install Sql Server 2014: Install .NET 3.5 Framework Install SQL Server Double Click Installation file Step 1:       Step 2: Step 3: Step 4: Step 5: Step 6: Step 7: Step 8: Step 9: Step 10:

Read More »

How to use PIVOT Query in SQL Server ?

TABLE [dbo].[Salary]( [SalaryId] [int] IDENTITY(1,1) NOT NULL, [EmpId] [varchar](50) NULL, [SalaryMonth] [date] NULL, [SalaryAmt] [decimal](18, 0) NULL, //=====================================PIVOT Query============================================= Select pv.* From ( Select * From ( Select EmpId,Month(SalaryMonth)Months,SalaryAmt From Salary ) sal PIVOT (SUM(SalaryAmt)for Months in([1],[2],[3]) )As p )pv

Read More »

How to insert NULL data in SQL Server Using C# ?

Some time we need to insert null value in Database. We can pass DBNull value in sql parameter to save in to database using store procedure. in c#———————— if (txtDOB.ToString(“yy/mm/dd”) == “01/00/01”) { cmd.Parameters.Add(new SqlParameter(“@p_DOB”, DBNull.Value)); } else { cmd.Parameters.Add(new SqlParameter(“@p_DOB”, txtDOB.ToString())); }

Read More »

How to use a Pivot query in SQL Server ?

TABLE [dbo].[Salary]( [SalaryId] [int] IDENTITY(1,1) NOT NULL, [EmpId] [varchar](50) NULL, [SalaryMonth] [date] NULL, [SalaryAmt] [decimal](18, 0) NULL, //=====================PIVOT Query============================ Select pv.* From ( Select * From ( Select EmpId,Month(SalaryMonth)Months,SalaryAmt From Salary ) sal PIVOT (SUM(SalaryAmt)for Months in([1],[2],[3]) )As p )pv

Read More »

Learn SQL Server

sql-logo-no-version

>>Learn Installation Process SQL Server 2014

Read More »