sql server小技巧

 

1. CREATE TRIGGER trig_insert ON dbo.eEmployee
   FOR INSERT
   AS
   update e set e.badge=i.id from eemployee e, inserted i where e.id=i.id
2. 获取系统中对象id的函数object_id('表名')
3. 单元格内输入null 值方法：选中单元格后，按住crtl+0
4. 去空格函数rtrim,ltrim
5. 权限判断函数Permissions([表名[，列名]])
6. insert into table1 (c1,c2,c3) select a1,a2,a3 from table2 where....
7. update table1 set c1=b.c2 from table2,b where ......
8. 时间字段判断 where time=#2006-12-12 00:00:00#
9. db2 sql skills:
   • db2cmd
   • select * from Table1 fetch first 100 rows only
   • connect to dbname user uname using pwd
   • db2set