摘要:
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[fn_GetPinyin]') AND xtype in (N'FN', N'IF', N'TF')) BEGIN execute dbo.sp_executesql @statement = N'create function [dbo].[fn_GetPinyin](@word 阅读全文
摘要:
select a.StaffCode,a.HospitalCode from MDS_DoctorRequest a,MDS_UserHospitalProduct bwhere a.StaffCode=b.StaffCode and a.HospitalCode=b.HospitalCode 阅读全文
摘要:
UPDATE a SET NameSpell =b.NameSpell FROM dbo.MDS_Doctor a,(SELECT DoctorName, dbo.fn_GetPinyin(DoctorName) AS NameSpell FROM dbo.MDS_Doctor) WHERE a.DoctorName = b.DoctorName 阅读全文