- 博客(3)
- 资源 (3)
- 收藏
- 关注
转载 存储过程 几个商品ID
--創建測試環境Create Table TEST(商品ID Int, Name Varchar(100))Insert TEST Select 1, AUnion All Select 2, BUnion All Select 3, CUnion All Select 5, DGO--創建存儲過程Create ProceDure SP_TEST(@ID Varchar(100))
2007-05-25 15:20:00 315
转载 right(code,3)=a.n+1
declare @t table(code varchar(6))insert into @t select A001insert into @t select A001insert into @t select A003insert into @t select B003insert into @t select B002insert into @t select C001
2007-05-24 15:12:00 263
转载 事务隔离级别
前几天同事讲了Transaction isolation level,并且大家一起在SQLServer,Oracle跟MySQL数据库上实验了一下,发觉这些知识还是挺重要的。假如有两个事务并发,顺序如下Transaction A Transaction Bbegin beginquery1 from table A .......
2007-05-24 09:15:00 358
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人