摘要：
DECLARE @NUM INT;SELECT @NUM=ID FROM ACCOUNT;INSERT INTO USER VALUES('YH','MA',@NUM); 阅读全文
posted @ 2014-02-24 10:07
西卡
阅读(181)
评论(0)
推荐(0)
摘要：
SELECT DISTINCT Company FROM Orders SELECT * FROM Persons WHERE City='Beijing'SELECT * FROM Persons WHERE FirstName='Bush'--字符串要加单引号SELECT * FROM Persons WHERE Year>1965--日期不用加单引号SELECT * FROM Persons WHERE FirstName='Thomas' AND LastName='Carter'SELECT * FROM Pers 阅读全文
posted @ 2014-01-17 12:44
西卡
阅读(208)
评论(0)
推荐(0)