随笔分类 - SQL

建库及建存储过程代码

摘要：use mastercreate database TestDBGoDECLARE @ver intselect @ver=case when ver like '%2000%' then 2000-- insert into testdb(ver) values(2000)when ver like '%2005%' then 2005when ver like '%2008%' then 2008end from (select @@VERSION as ver) as d/*--------------------------------- 阅读全文

posted @ 2012-01-18 17:37 老咸菜阅读(241) 评论(0) 推荐(0)