存储过程:判断是否存在数据，并插入数据

ALTER PROCEDURE PR_ADDNEW

(

@TabName varchar(50),

@TabOrder int

)

AS

Declare @RecordCount as int

SET @RecordCount = (select count(*) from tabs where TabName = @TabName)

IF @RecordCount < 1

BEGIN

INSERT INTO tabs(TabName,TabOrder) values (@TabName,@TabOrder)

Return @@identity

END