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): 23529/ 27

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

User Comments

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

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






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


©Copyright 1998-2024 ASPAlliance.com  |  Page Processed at 2024-03-28 6:55:29 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search