UC知道sql server 2005 插入问题
来源：百度知道 编辑：UC知道 时间：2024/06/01 06:35:56
INSERT BBSUsers
(UName,UPassword,UEmail,UBirthday,USex,UClass,UStatement,URegData,UState,UPoint)
SELECT'火云邪神','hyxs007','hyxs@hotmail.com','1978-7-9',1,1,'快...','2005-8-9',1,2000 UNION
SELECT'小艾','xiaoai888','xiaoao@hotmail.com','1982-3-1',0,1,'我是小艾','2004-8-1',2,1000 UNION
SELECT'东方不败','fangdong','dfbb@sohu.com','1975-8-21',1,3,'没败过','2005-2-27',4,2239 UNION
SELECT'SupperMaster','mastersper','master@p.com','1981-2-12',1,16,'BBS版主','2003-1-1',1,50000
怎么显示
(UName,UPassword,UEmail,UBirthday,USex,UClass,UStatement,URegData,UState,UPoint)
SELECT'火云邪神','hyxs007','hyxs@hotmail.com','1978-7-9',1,1,'快...','2005-8-9',1,2000 UNION
SELECT'小艾','xiaoai888','xiaoao@hotmail.com','1982-3-1',0,1,'我是小艾','2004-8-1',2,1000 UNION
SELECT'东方不败','fangdong','dfbb@sohu.com','1975-8-21',1,3,'没败过','2005-2-27',4,2239 UNION
SELECT'SupperMaster','mastersper','master@p.com','1981-2-12',1,16,'BBS版主','2003-1-1',1,50000
怎么显示
意思就是在bbsusers这个表里插入以下数据：
'火云邪神','hyxs007','hyxs@hotmail.com','1978-7-9',1,1,'快...','2005-8-9',1,2000
'小艾','xiaoai888','xiaoao@hotmail.com','1982-3-1',0,1,'我是小艾','2004-8-1',2,1000
'东方不败','fangdong','dfbb@sohu.com','1975-8-21',1,3,'没败过','2005-2-27',4,2239
'SupperMaster','mastersper','master@p.com','1981-2-12',1,16,'BBS版主','2003-1-1',1,50000
select * from BBSUsers
不知道你的意识是这样么