创建 链接数据库

 

sp_addlinkedserver @server='CARDSRV',@srvproduct='',@catalog='ywsjk',@provider='SQLOLEDB',
@provstr='DRIVER={SQL Server};Initial Catalog=iHRP;SERVER=192.168.2.1;UID=sa;PWD=;'

EXEC sp_addlinkedsrvlogin 'CARDSRV','false' 

 

 

 

查找指定字符串 select charindex(')','111(111)')

取得子串 select substring('111(111)',5,8-5)

 

填充字符串 REPLICATE