CodeSnip: How to Create a Complete Dynamic SQL Statement Using SQL Server
page 1 of 5
Published: 09 Aug 2006
Unedited - Community Contributed
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
Average Rating: 
Views (Total / Last 10 Days): 23306/ 37


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

User Comments

Title: hello   
Name: asa
Date: 2012-11-17 7:52:29 AM
Title: q   
Name: q
Date: 2012-09-11 9:54:43 AM
Title: Dynamic sql   
Name: mala
Date: 2009-10-23 8:23:59 AM
very very nice article.....

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

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2024  |  Page Processed at 2024-07-13 12:21:01 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search