SQL Server

²éѯ card µÄ¼Ç¼ΪÁ½´ÎÒÔÉ쵀 card£¬¼Ç¼Êý:
select count(card), card from TableName group by card having count(card) > 1
¼¶Áª¸üУ¬¼¶ÁªÉ¾³ý:
ColumnName type not null constraint FK_Name foreign key(ColumnName) references PrimaryTable(ColumnName) on update/delete cascade
×Ô¶¯¼ÆËãÁÐ:
create table TableName
(
 ID int,
 Price decimal(10,2) not null,
 Number int not null,
 Total as Price * number  -- Total ²»´æ´¢Öµ¡£
)
insert into TableName values(1, 100, 123)
insert into TableName values(1, 100, 123)
insert into TableName values(2, 200, 456)
insert into TableName values(2, 200, 456)
select ID, Total=SUM(Total) from TableName where ID = 1 group by ID
ÐÞ¸ÄÏÖÓÐÉÌÆ·ÊýÁ¿:
begin
begin tran
declare @ForeignError int, @PrimaryError int
insert into ForeignTable values(@ID, @Number)
select @ForeignError=@@Error              -- @@Error: ·µ»ØÖ´ÐеÄÉÏÒ»¸ö Transact-SQL Óï¾äµÄ´íÎóºÅ¡£
update PrimaryTable set Number=Number ± @Number where ID=@ID --½ø»õʱÓüӺš£
select @PrimaryError=@@Error
if (@ForeignError = 0 and @PrimaryError = 0)
 commit tran
else
 rollback tran
end
begin
begin tran
declare @ForeignError int, @PrimaryError int, @NewNumber int
update ForeignTable set Number=@Number, @NewNumber=@Number - Number where ID=@ID
select @ForeignError=@@Error
update PrimaryTable set Number=Number ± @NewNumber where ID=@ID --½ø»õʱÓüӺš£
select @PrimaryError=@@Error
if (@ForeignError = 0 and @PrimaryError = 0)
 commit tran
else
 rollback tran
end