CodeSnip: How to Create a Complete Dynamic SQL Statement Using SQL Server: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
CodeSnip: How to Create a Complete Dynamic SQL Statement Using SQL Server

page 1 of 5

Published: 09 Aug 2006

Unedited - Community Contributed

Abstract
In this article Nidal demonstrates how to create a complete dynamic SQL Statement using SQL Server 2000 with the help of code samples.

by Nidal Arabi
Feedback

Average Rating:

Views (Total / Last 10 Days): 33776/ 95

Article Contents:

Introduction

Microsoft SQL Server 2000 does not allow the use of variables in some parts of your SQL Statement. Two examples of this non use are selecting a variable top number of rows and defining a variable where clause. However, there are several ways to overcome these obstacles. In this article I will define an SQL stored procedure called DynamicSQL. This procedure allows the caller to provide multiple parameters.

View Entire Article

(Page 2) »

Article Feedback

Comment:
Title:
Name:
Url:	( Optional )

Please add 8 and 7 and type the answer here:

User Comments

Title: Dynamic sql
Name: mala
Date: 10/23/2009 8:23:59 AM
Comment:
very very nice article.....

this article help to me....thanks a lot!..