有关创建数据库
我用visual studio 在原有的数据库employee上创建新的数据库employeemember，使新的数据库按照salary和birth分成gold，silver和regular。我的代码：DECLARE @time DATETIMESET @time=GETDATE()
DELETE FROM employeemember;
DELETE FROM employees WHERE DATEDIFF(YY,birth_date,@time)>68;
INSERT INTO employeemember(Membershipid, FirstName,LastName,MembershipClass,Date_of_birth，salary) SELECT employee.emp_no,first_name,last_name,'Class',birth_date salary FROM employees，salaries WHERE employees.emp_no=salaries_emp_no;
UPDATE employeemember set MembershipClass ='silver' SELECT top 50 PERCENT salary FROM salaries ORDER BY salary DESC;
INSERT INTO employeemember(Membershipid, FirstName,LastName,MembershipClass,Date_of_birth,salary) SELECT employees.emp_no,first_name,last_name,'Class',birth_date,salary FROM employees,salarues WHERE employees.emp_no=salaries.emp_no;
UPDATE employeemember set MembershipClass ='gold' SELECT top 20 PERCENT salary FROM salaries ORDER BY salary DESC ;
INSERT INTO employeemember(Membershipid, FirstName,LastName,MembershipClass,Date_of_birth,salary) SELECT employees. emp_no,first_name,last_name,'Class',birth_date,salary FROM employees,salaries WHERE DATEDIFF(YY,birth_date,@time)>60 AND employees.emp_no=salaries,emp_no;
UPDATE employeemember set MembershipClass = 'regular' FROM employees ;
输出结果有时只能输出全是gold 或全是silver或全是regular。有时提示错误Violation of PRIMARY KEY constraint 'PK__tmp_ms_x__92A69A5183E4E22F'. Cannot insert duplicate key in object 'dbo.employeemember'. The duplicate key value is (10001).
The statement has been terminated.
求帮忙啊！！！非常感谢！
页:
[1]