首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > SQL Server >

小弟我要被急死啦!

2012-01-24 
我要被急死啦!!!!!!!!!!!!use bluehillgocreate view viwwebEmpCommonInfoasselect ?e.EmployeeIDas emplo

我要被急死啦!!!!!!!!!!!!
use bluehill
go
create view viwwebEmpCommonInfo 
as
select ?
e.EmployeeID as employee_id,
?e.[Name] as employee_name,
?e.Email as employee_email,
?e.Telephone as employee_telephone,
?e.LoginName as employee_loginname,
?e.[Password] as employee_password
?e.OnboardDate as employee_onboarddate,
?t.DeptName as employee_deptname,
?t.ManagerID as employee_managerid,
?e.SelfIntro as employee_selfintro,
?e.vacationRemain as employee_vacationremain
from tblemployee as e inner join tbldepartment as t on e.deptid=t.deptid



错误信息:::


服务器: 消息 170,级别 15,状态 1,过程 viwwebEmpCommonInfo,行 3
第 3 行: '?' 附近有语法错误。



杂症啊??????????????????????

[解决办法]
employee_password --少个逗号

热点排行