SQL SERVER常用脚本备份

1、数据库字段区分大小写

ALTER TABLE [dbo].[Dim_NetworkBase]
ALTER COLUMN [网点ID] nvarchar(50) COLLATE Chinese_PRC_CS_AS

2、SQLSERVER创建链接服务器

sp_addlinkedserver @server = N'172.74.1.65',
@srvproduct = N' ',
@provider=N'SQLOLEDB', 
@datasrc = N'172.74.1.65';

sp_addlinkedsrvlogin @rmtsrvname = '172.74.1.65'
, @useself = 'false' 
, @locallogin = 'sa' 
, @rmtuser = 'loginuser' 
, @rmtpassword = '123456' ;

3、使用查询语句建表

SELECT *
INTO Sales.CreditCard_Encrypt 
FROM Sales.CreditCard