辛淼 Jin

It is from http://www.sqlservercentral.com/blogs/querying-microsoft-sql-server /2013/09/19/how-to-split-a-string-by-delimited-char-in-sql-server/ A Stored Procedures for testing this function. -- ============================================= SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF EXISTS (SELECT * FROM SYS.objects WHERE name = 'testfnSplitString' AND [TYPE] = 'P') DROP PROCEDURE dbo.testfnSplitString  GO CREATE PROCEDURE dbo.testfnSplitString (@IDs NVARCHAR(MAX)) AS SET NoCount ON SET Ansi_Warnings OFF  DECLARE @output TABLE(IDt NVARCHAR(MAX))  DECLARE @start INT, @end INT,@delimiter VARCHAR(2)=',' SELECT @start = 1, @end = CHARINDEX(@delimiter, @IDs) WHILE @start < LEN(@IDs) + 1 BEGIN IF @end = 0 SET @end = LEN(@IDs) + 1 INSERT INTO @output (IDt) VALUES(SUBSTRING(@IDs, @start, @end - @start)) SET @start = @end + 1 SET @end = CHARINDEX(@delimiter, @IDs, @...

1.  jdbc:sqlserver://192.168.10.220\ northstar ;databaseName=Northstar The server\instance name syntax used in the server option is the same for all SQL Server connection strings. northstar is a instance name. each instance match a port of TCP .  2.  jdbc:sqlserver://192.168.10.220： 1433 ;databaseName=Northstar (Provider=SQLOLEDB.1;Password=*;Persist Security Info=True;User ID=sa;Initial Catalog= Northstar ;Data Source=192.168.10.220 ,1433 ) 1433 is the default port for SQL Server, can be dynamically assigned, such as 1863, 1875... netstat -aon | findstr 1433 * A .udl file can be used to set connection string at client side. Creating and Configuring Universal Data Link (.udl) Files * svrnetcn.exe at server side sets port. * netstat command displays protocol statistics and current TCP/IP network connections. (netstat -an) Ref: https://www.connectionstrings.com/sql-server/  http://support2.microsoft.com/?id=832017 This article contains several refe...

1.Check backup file  restore filelistonly from disk=' C:\Microsoft SQL Server\Backup\xxx.bak ' Result: LogicalName            PhysicalName ---------------  ------------------------------------------------------------------ OldDatabase_Data             d:\Program Files\Microsoft SQL Server\MSSQL$SQLA\data\xxx.mdf OldDatabase_log     d:\Program Files\Microsoft SQL Server\MSSQL$SQLA\data\ xxx_log.ldf 2. Restore to new database RESTORE DATABASE xxxNewName   FROM DISK = ' C:\Microsoft SQL Server\Backup\xxx.bak ' WITH MOVE ' OldDatabase_Data '  TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\ xxxNewName .mdf' , MOVE ' OldDatabase_log ' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\ xxxNewName_log .ldf', replace;