- 博客(4)
- 资源 (7)
- 收藏
- 关注
原创 CMMI-DEV V1.3 的改进
<br />Some significant improvements you can expect in CMMI-DEV, V1.3 include <br />the following: <br /> High maturity process areas are significantly improved to reflect <br />industry best practices, including a new specific goal and several new <br />s
2011-03-28 09:23:00 487
原创 with as
with a as (select * from test) select * from a; 其实就是把一大堆重复用到的SQL语句放在with as 里面,取一个别名,后面的查询就可以用它
2011-03-28 09:04:00 208
原创 SQL 中with的用法
with a as (select * from test) select * from a; 其实就是把一大堆重复用到的SQL语句放在with as 里面,取一个别名,后面的查询就可以用它
2011-03-22 14:44:00 669
转载 关于MySQL select into 和 SQLServer select into
关于MySQL select into 和 SQLServer select into一.MySQL不支持Select Into语句直接备份表结构和数据,由于工作中的需要在网上找到一种方法可以代替, 也有其它方法可以处理,总结如下:方法1: MYSQL不支持: Select * Into new_table_name from old_table_name; 替代方法: Create table new_table_name (Select * from o
2011-03-22 10:02:00 279
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人