摘要: --方法一select * from sysobjects where xtype = 'tr'--方法二select * from sys.triggers 阅读全文
posted @ 2011-08-15 16:20 从头儿再来 阅读(309) 评论(0) 推荐(0) 编辑
摘要: create trigger triggerBookon Userinfofor Updateasif update(username)beginupdate bookBorrowInfo set username = i.username from bookBorrowInfo b ,Deleted d,Inserted iwhere b.username = d.usernameend--just update 阅读全文
posted @ 2011-08-15 16:01 从头儿再来 阅读(197) 评论(0) 推荐(0) 编辑
摘要: static void Main(string[] args) { int[] array = { 23, 45, 16, 7, 42,100,2 }; int length = array.Length - 1; bool isExchanged = false; for (int i = 0; i < length; i++) { for (int j = length; j > i; j--) { if (array[j]< array[j - 1]) { int temp = array[j]; array[j] = array[j - 1]; array[j - 1 阅读全文
posted @ 2011-08-15 15:30 从头儿再来 阅读(189) 评论(0) 推荐(0) 编辑