摘要:
//SELECT 查询语句SELECT 查询字段 AS 别名字段 FROM 表名 简单查询SELECT * FROM pre_person 限制查询字段SELECT person_id,person_name FROM pre_person 统计总数SELECT COUNT(person_id) A 阅读全文
摘要:
表样: 表样: sqlserver: sqlserver: --方法1 DECLARE @STR VARCHAR(8000) SELECT @STR=ISNULL(@STR+',','')+userID FROM (SELECT DISTINCT userID FROM Users)AS T SEL 阅读全文