|
Perform array-like manipulations using the set-oriented SQL features |
|
| | 
| Submitted on: 7/29/2000 9:48:36 PM
By: Umachandar
Level: Intermediate
User Rating: Unrated
Compatibility:SQL Server 7.0, SQL Server 6.5 and earlier
Users have accessed this code 2892 times.
| |
| | | How to perform array-like manipulations using the set-oriented SQL features
| |
| |
|
code:
Can't Copy and Paste this?
Click here for a copy-and-paste friendly version of this code!
Terms of Agreement:
By using this code, you agree to the following terms...
1) You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for langauges that allow it) freely and with no charge.
2) You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
3) You may link to this code from another website, but ONLY if it is not wrapped in a frame.
4) You will abide by any additional copyright restrictions which the author may have placed in the code or code's description. |
--**************************************
--
-- Name: Perform array-like manipulation
-- s using the set-oriented SQL features
-- Description:How to perform array-like
-- manipulations using the set-oriented SQ
-- L features
-- By: Umachandar
--
--This code is copyrighted and has-- limited warranties.Please see http://
-- www.Planet-Source-Code.com/xq/ASP/txtCod
-- eId.188/lngWId.5/qx/vb/scripts/ShowCode.
-- htm--for details.--**************************************
--
SET quoted_identifier ON
SET nocount ON
go
DECLARE @x smallint
CREATE TABLE #array("index" smallint, value smallint)
SELECT @x = 0
WHILE @x < 8
begin
INSERT #array values(@x, @x)
SELECT @x = @x + 1
end
-- Array[3] is
SELECT value FROM #array WHERE "index" = 3
| |
Other 133 submission(s) by this author
|
|
| |
| Report Bad Submission |
|
| |
| Your Vote! |
|
See Voting Log |
| |
| Other User Comments |
There are no comments on this submission.
|
|
| Add Your Feedback! |
Note:Not only will your feedback be posted, but an email will be sent to the code's author in your name.
NOTICE: The author of this code has been kind enough to share it with you. If you have a criticism, please state it politely or it will be deleted.
For feedback not related to this particular code, please click here.
|
|
