在Sql server中有如下触发CREATE TRIGGER tr_client_insert ON [dbo].[client]
FOR INSERT
AS
IF @@rowcount > 1
RETURN
DECLARE @C varchar(10)
SELECT @c = right(convert(varchar(8),getdate(),112),6)
declare @c1 int
SELECT
@c1 = isnull(cast(max(right(cl_id,4)) as int),0)+1
FROM client
UPDATE client
set cl_id = @c+right('000'+cast(@c1 as varchar(4)),4)
FROM client,INSERTED
WHERE client.cl_id = inserted.cl_id为什么我在Delphi里用
dm.adoqClient.Insert;
不能得到新的id?应该怎样做?
谢谢
FOR INSERT
AS
IF @@rowcount > 1
RETURN
DECLARE @C varchar(10)
SELECT @c = right(convert(varchar(8),getdate(),112),6)
declare @c1 int
SELECT
@c1 = isnull(cast(max(right(cl_id,4)) as int),0)+1
FROM client
UPDATE client
set cl_id = @c+right('000'+cast(@c1 as varchar(4)),4)
FROM client,INSERTED
WHERE client.cl_id = inserted.cl_id为什么我在Delphi里用
dm.adoqClient.Insert;
不能得到新的id?应该怎样做?
谢谢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货