CREATE PROCEDURE dbo.StoredProcedure1
(
@int
)
AS
set @date=getdate()
select * from table where tblint=isnull(@int,tbint)
RETURN
(
@int
)
AS
set @date=getdate()
select * from table where tblint=isnull(@int,tbint)
RETURN
(
@int int
)
ASselect * from [table] where tblint=isnull(@int,tbint)
RETURN