Ds萝卜的博客

创建表 不存在则创建 IF OBJECT_ID('dbzDBInfo','u') IS NULL CREATE TABLE dbzDBInfo (pcName varchar(50), xjfCardID varchar(50), xjfSwapID varchar(50)) 多表查询 SELECT sCom, sCardID, xjfCardID, xjfSwapID FROM tStat wx, dbzDBInfo dbz WHERE wx.sCom = dbz.pcName ORDER BY sCo