不大明白你的意思,试试看
CREATE PROCEDURE InPut_ID(@CurrID int OUTPUT)
AS
DECLARE @ChuShiID int,
@StepID int
SELECT @ChuShiID = MAX(youridfield)
FROM yourtable
IF @ChuShiID IS NULL
SELECT @ChuShiID = 0 --获得标识种子
SELECT @StepID = yourinc --获得种子增量
SELECT @CurrID = @ChuShiID + @StepID
GO
CREATE PROCEDURE InPut_ID(@CurrID int OUTPUT)
AS
DECLARE @ChuShiID int,
@StepID int
SELECT @ChuShiID = MAX(youridfield)
FROM yourtable
IF @ChuShiID IS NULL
SELECT @ChuShiID = 0 --获得标识种子
SELECT @StepID = yourinc --获得种子增量
SELECT @CurrID = @ChuShiID + @StepID
GO
@id int,
@property varchar(64)
as
set nocount on if (@property is null) or (@property = '')
delete from dbo.dtproperties where objectid=@id
else
delete from dbo.dtproperties
where objectid=@id and property=@property
GO
@lastname varchar(30) = 'D%',
@firstname varchar(18) = '%'
AS
SELECT au_lname, au_fname, title, pub_name
FROM authors a INNER JOIN titleauthor ta
ON a.au_id = ta.au_id INNER JOIN titles t
ON t.title_id = ta.title_id INNER JOIN publishers p
ON t.pub_id = p.pub_id
WHERE au_fname LIKE @firstname
AND au_lname LIKE @lastname
GO