Bulk Insert/Update in MS SQL

by Farooq Kaiser 6. June 2012 06:02

This article explains how to insert/update bulk data in .net application. This way your application will improve performance. For example, inserting few hundred records together into same table, we normally do something like: For i As Integer = 0 To 200 'SQL... [More]

Currently rated 5.0 by 1 people

Currently 5/5 Stars.
1
2
3
4
5

Tags:

.NET | SQL

Building a T-SQL Loop

by Farooq Kaiser 12. June 2009 14:04

This topic shows how to write Nested loop with table variable instead of cursors. This tutorial will use AdventureWorks database. DECLARE @COUNTER AS INT DECLARE @TOTALREC AS INT DECLARE @RESULT_TABLE TABLE ( RES_ID INT, R... [More]

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: sql, t-sql

SQL

ADO.NET Entity Framework

by Farooq Kaiser 6. June 2009 15:44

In this tutorial I will show you how you can create data access classes using the Microsoft Entity Framework when building an ASP.NET application. This tutorial will use AdventureWorks database. Follow the these steps. Add a new item to the project by right-clicking on Windows... [More]

Currently rated 1.0 by 1 people

Currently 1/5 Stars.
1
2
3
4
5

Tags: ado.net entity framework, ado.net

.NET | C# | SQL

Import Excel File to sql server database using SSIS package

by Farooq Kaiser 6. June 2009 04:46

Currently, I am working on a project that requires data tranfer from excel files to sql server database. In this article, i will show you how to transfer data from one source to another. Follow the these steps. Launch Business Intelligence Development Studio by selecting All Programs ... [More]

Currently rated 4.0 by 1 people

Currently 4/5 Stars.
1
2
3
4
5

Tags: ssis, sql, sql server integration services

SQL | SQL SERVER INTEGRATION SERVICES

Ranked Results with MS SQL

by Farooq Kaiser 3. June 2009 14:56

Recently, I created a report using SSRS and i found ROW_NUMBER() can be very useful in rank-related tasks.Here is a sample query using AdventureWorks database. Select ProductID, ReorderPoint , SafetyStockLevel,ROW_NUMBER() OVER (order by ProductID) as RowFROM Production.Product&n... [More]

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: sql, t-sql

SQL

Using PIVOT and UNPIVOT with SQL 2005/2008

by Farooq Kaiser 31. May 2009 11:54

The PIVOT operator can be used to transform a set of rows into columns while the UNPIVOT operator complements the PIVOT operator by allowing you to turn columns into rows. The following sample will use AdventureWorks database.Sample CodeUSE AdventureWorks GOSELECT DaysToManufacture, sum(StandardCost... [More]

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: sql, t-sql

SQL

SQL Reporting Services Video

by Farooq Kaiser 13. January 2009 06:52

I found few sql Reporting services videos and wanted to share. Please feel free to leave any comments or questions. http://www.learnreportingservices.com/FreeVideos/default.aspx http://www.youtube.com/watch?v=vB9iDurRtRM http://aspalliance.com/972_Video_SQL_Server_Reporting... [More]

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: sql reporting services, ssrs, video

SQL | SQL Reporting Services