这个T-SQL语句有什么错误?insertintouser(UID,Uname,Upwd,Uemail,Ugrade)values(2,'senlinyang11','6333486','[e-mail]',1)

Question

这个T-SQL语句有什么错误?
insert into user(UID,Uname,Upwd,Uemail,Ugrade)
values(2,'senlinyang11','6333486','[e-mail]',1)

Answer 1

你用的什么数据库?如果是servlet 就是
insert into user(Uname,Upwd,Uemail,Ugrade)
values('senlinyang11','6333486','[e-mail]',1)
如果是oracle
insert into user(UID,Uname,Upwd,Uemail,Ugrade)
values(2,'senlinyang11','6333486','[e-mail]',1);把2换成序列就OK了.