how to execute - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

how to execute

Author

Topic

born2acheive
Yak Posting Veteran

65 Posts

Posted - 2006-12-01 : 05:22:45

hi,this is my stored procedure:

CREATE PROCEDURE loop As
declare @fromage bigint

begin

select @fromage=max(age) from emp1
end
begin
insert into loop values(@fromage)
end

how to run thi spc in sqlserver,please tell me

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-12-01 : 05:26:02

[code]EXEC loop[/code]

But, Hey!! wait!

You can't create procedure with the same name as Table name, I think.
Also, it is not advisable.

Harsh Athalye
India.
"Nothing is Impossible"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources