摘要:
--方法一select * from sysobjects where xtype = 'tr'--方法二select * from sys.triggers 阅读全文
摘要:
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 阅读全文
摘要:
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 阅读全文