Re: Add bulk info
From: Partha Mandayam (mcp111_at_hotmail.com)
Date: 08/25/04
- Next message: Bob A.: "Re: Deleting Rows in a Many-To-Many Relationship"
- Previous message: Rob Abrahams: "Re: Converting autonomous transaction in Oracle to SQLserver"
- In reply to: SusieQ: "Add bulk info"
- Next in thread: SusieQ: "Re: Add bulk info"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 25 Aug 2004 10:52:37 -0700
call this stored procedure from your asp page
create proc fill_numbers
(
@start_num int,
@end_num int
)
as
declare @num int
create table #tbl
( number int, dateentered datetime
)
set @num=@start_num
while @num <= @end_num
begin
insert #tbl select @num, getdate()
set @num=@num+1
end
select * from #tbl
go
Regards
Partha Mandayam
Software Consultant
Home page: http://partha.tripod.com
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
- Next message: Bob A.: "Re: Deleting Rows in a Many-To-Many Relationship"
- Previous message: Rob Abrahams: "Re: Converting autonomous transaction in Oracle to SQLserver"
- In reply to: SusieQ: "Add bulk info"
- Next in thread: SusieQ: "Re: Add bulk info"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
