摘要: 1CREATE TRIGGER customer_state 2ON Customers 22FROM INSERT,UPDATE 4AS 5UPDATE Customers 6SET cust_state=Upper(cust_state) 7WHERE Customers.cust_id=inserted.cust_id; 阅读全文
posted @ 2007-08-23 23:03 子午 阅读(540) 评论(3) 推荐(0) 编辑
摘要: 1BEGIN TRANSACTION 2INSERT INTO Customers(cust_id,cust_name) 3VALUES('100000010','Toys_Emporium'); 4SAVE TRANSACTION StartOrder; 5INSERT INTO Orders(order_num,order_date,cust_id) 6VALUES(20100,... 阅读全文
posted @ 2007-08-23 22:46 子午 阅读(2592) 评论(0) 推荐(2) 编辑
摘要: 搜索下也找不到答案... 阅读全文
posted @ 2007-08-23 22:06 子午 阅读(494) 评论(1) 推荐(0) 编辑
摘要: /> ' Width="157px"> public string GetReportsToName(object reportsToId) { foreach (DataRowView row in R... 阅读全文
posted @ 2007-08-23 16:17 子午 阅读(559) 评论(0) 推荐(0) 编辑
摘要: wiyue.com cloudily.com moonset.cn elapsed.com.cn 阅读全文
posted @ 2007-08-23 08:26 子午 阅读(123) 评论(0) 推荐(0) 编辑