复制代码 代码如下:

drop procedure PCreateGuid
@keyname varchar(100),
@guid varchar(100) out
as
[KeyValue] [varchar](100) NOT NULL
if exists (select * from dbo.sysobjects where id = object_id(N'PCreateGuid') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
CREATE PROCEDURE PCreateGuid

declare @guid varchar(100)
CREATE TABLE [dbo].[TbGuidTable](

[KeyName] [varchar](20) NOT NULL,
declare @tableName varchar(50)

select @guid=cast(keyvalue as varchar) from TbGuidTable where tablename=@tableName and keyname=@keyname
declare @keyname varchar(100)
@tableName varchar(50),
------------------------------------
------------------------------------
--用途：增加一条记录 个人信息
insert into TbGuidTable (tablename,keyname,keyvalue) values(@tableName,@keyname,10000)
if not exists(select * from TbGuidTable where tablename=@tableName and keyname=@keyname)
--项目名称：
print @guid
[TableName] [varchar](50) NOT NULL,
GO
---*****---
GO
set @keyname='def'
Go
execute PCreateGuid @tableName,@keyname,@guid out
--时间：2011-7-4 15:34:12,2011-08-15
--说明：
set @tableName='tb1'
update TbGuidTable set keyvalue=keyvalue+1 where tablename=@tableName and keyname=@keyname
) ON [PRIMARY]