11 lines
704 B
SQL
11 lines
704 B
SQL
begin tran
|
|
insert into Cards(name, faction, description, action, image, cost, type, power, color, cardset) values ('CardTest2',2,'Test card 2','Test action 2','Test image 2',2,'special',2,'gold',2);
|
|
waitfor delay '00:00:05'
|
|
commit tran
|
|
|
|
insert into Cards(name, faction, description, action, image, cost, type, power, color, cardset) values ('CardTest1',1,'Test card 1','Test action 1','Test image 1',1,'Unit',1,'Bronze',1);
|
|
insert into Cards(name, faction, description, action, image, cost, type, power, color, cardset) values ('CardTest2',2,'Test card 2','Test action 2','Test image 2',2,'special',2,'gold',2);
|
|
|
|
delete from Cards where name = 'CardTest2';
|
|
|
|
delete from Cards where name like 'CardTest%'; |