Programming Tutorials

(追記) (追記ここまで)

Import TEXT to TABLE in MSSQL

By: Fernando in JDBC Tutorials on 2010年04月06日 [フレーム]

Use this code to import value in text into a table in MSSQL

CREATE PROCEDURE dbo.EachLineToTable --'String1,String2,String3,String4,MyNameIs,TestDriveFromBIGString,GOGOGO,Bye'
@Text TEXT
AS
DECLARE @StrLine VARCHAR(8000)
DECLARE @Size BIGINT
DECLARE @Start BIGINT
DECLARE @Separator VARCHAR(1)
DECLARE @TempImport TABLE(Idx BIGINT IDENTITY(1,1), SplitedLine VARCHAR(8000), Size INT)
SET @Size = 1
SET @Start = 1
SET @Separator = ','
WHILE (@Start < DATALENGTH(@Text) + 1) BEGIN SET @Size = CHARINDEX(@Separator, SUBSTRING(@Text, @Start, DATALENGTH(@Text)), 1) IF @Size = 0 SET @Size = DATALENGTH(@Text) - @Start + 1 SET @StrLine = SUBSTRING(SUBSTRING(@Text, @Start, DATALENGTH(@Text)), 1, @Size) SET @StrLine = REPLACE(@StrLine,@Separator,'') INSERT INTO @TempImport(SplitedLine, Size) VALUES(@StrLine, LEN(@StrLine)) SET @Start = @Start + @Size END SELECT * FROM @TempImport



(追記) (追記ここまで)


Add Comment

JavaScript must be enabled for certain features to work
* Required information
1000

Comments

No comments yet. Be the first!

Most Viewed Articles (in JDBC )

Latest Articles (in JDBC)

(追記) (追記ここまで)
(追記) (追記ここまで)

AltStyle によって変換されたページ (->オリジナル) /