Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Inserting a cloum in a stored procedure

Reply
Thread Tools

Inserting a cloum in a stored procedure

 
 
iHavAQuestion
Guest
Posts: n/a
 
      05-13-2008
I have stored procedure
In @var1/Col1 I need to insert, the max(col) from another table in the
same database.


Create Stored Procedure Name
(
@Var1
@Var2
@Var3
)
Inseret into table1
(
Col1
col2
col3
)
Values
(
@Var1
@Var2
@Var3
)

 
Reply With Quote
 
 
 
 
Jeff Dillon
Guest
Posts: n/a
 
      05-13-2008
Select @var1 = max(col) from othertable

"iHavAQuestion" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have stored procedure
> In @var1/Col1 I need to insert, the max(col) from another table in the
> same database.
>
>
> Create Stored Procedure Name
> (
> @Var1
> @Var2
> @Var3
> )
> Inseret into table1
> (
> Col1
> col2
> col3
> )
> Values
> (
> @Var1
> @Var2
> @Var3
> )
>



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
procedure as argument in procedure AlexWare VHDL 2 10-23-2009 09:14 AM
inserting the max colum in the stored proc iHavAQuestion ASP .Net 5 05-13-2008 08:10 PM
call store procedure for inserting data in asp c676228 ASP General 10 10-19-2006 04:21 PM
'Procedure or function <stored procedure name> has too many arguments specified',,,ARGH! Mike P ASP .Net 0 06-19-2006 01:19 PM
ObjectDataSource - problem inserting empty field into stored proce =?Utf-8?B?RGFiYmxlcg==?= ASP .Net 7 04-10-2006 07:00 AM



Advertisments