日期:2014-05-17 浏览次数:20482 次
ALTER proc [dbo].[Proc_Linkman_Read]
as
SELECT Linkman_Num as '编号',
Linkman_Name as '联系人',
Linkman_CustomerCode as '所属客户',--这个实际存的是客户编号,显示给用户是要根据这个编号读取实际表Customer表中对应这个编号的客户名称Cus_Name
Linkman_Mobile as '移动电话',
Linkman_Phone as '固定电话',
Linkman_Email '电子邮箱',
Linkman_QQNum as 'QQ号码',
Linkman_Sex as '性别',
Linkman_Remark as '说明备注' FROM [PMIS].[dbo].[Linkman]order by Linkman_Num asc
SELECT Linkman_Num as '编号',
Linkman_Name as '联系人',
[PMIS].[dbo].[Customer].CustomerName as '所属客户',
Linkman_Mobile as '移动电话',
Linkman_Phone as '固定电话',
Linkman_Email '电子邮箱',
Linkman_QQNum as 'QQ号码',
Linkman_Sex as '性别',
Linkman_Remark as '说明备注' FROM [PMIS].[dbo].[Linkman],[PMIS].[dbo].[Customer]
where [PMIS].[dbo].[Linkman].Linkman_CustomerCode=[PMIS].[dbo].[Customer].CustomerCode
order by [PMIS].[dbo].[Linkman].Linkman_Num asc