Hi,
Temporary stored procedures on Microsoft SQL Server are prefixed with a pound sign #. One pound sign means that its temporary within the session, two pound signs ## means its a global temporary procedure, which can be called by any connection to the SQL server during its lifetime.
SET NOCOUNT ON
GO
CREATE PROC #tempProc
@id integer
@name varchar(100)
AS
INSERT INTO table1(empid,empname) VALUES (@id,@name)
GO
EXEC #tempProc1 10,Mohan
GO
SET NOCOUNT OFF
GO
Regards,
Kalandiyur Subramanian Mohan
www.mohanks.com