摘要: 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 子午 阅读(546) 评论(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 子午 阅读(2599) 评论(0) 推荐(2)
摘要: 搜索下也找不到答案... 阅读全文
posted @ 2007-08-23 22:06 子午 阅读(499) 评论(1) 推荐(0)
摘要: /> ' Width="157px"> public string GetReportsToName(object reportsToId) { foreach (DataRowView row in R... 阅读全文
posted @ 2007-08-23 16:17 子午 阅读(563) 评论(0) 推荐(0)
摘要: wiyue.com cloudily.com moonset.cn elapsed.com.cn 阅读全文
posted @ 2007-08-23 08:26 子午 阅读(128) 评论(0) 推荐(0)