importing data into sql server which contains delimters

B@Th*nG · 3 Aug 2012 at 13:23

Hi guys,

I'm having trouble importing a field into SQL server because some of the data has a leading character of a square bracket "[". Is there anyway i can pull this information through without stripping it of the leading "["?

IE:

insert into table_abc (column_a) select fieldwhichcontainsirritatingcharacter from sourcetable

B@

Pho · 3 Aug 2012 at 19:58

The column name or the data has the bracket? Can you post a sample?

If the data has the bracket it should just work assuming column_a is the right data format.

Nash · 4 Aug 2012 at 16:08

Use a ' before and after the name of it?

B@Th*nG · 4 Aug 2012 at 18:43

the data contains the brackets. IE:

[s1231312
[12312312

B@

Pho · 4 Aug 2012 at 19:39

Are you sure your destination column type isn't wrong?

This works fine in SQL Server:

PHP:

DECLARE @sourcetable TABLE (fieldwhichcontainsirritatingcharacter NVARCHAR(MAX))
INSERT INTO @sourcetable
	SELECT '[s1231312' UNION ALL
	SELECT '[12312312'

DECLARE @test TABLE (column_a NVARCHAR(MAX))
INSERT INTO @test (column_a)
	SELECT fieldwhichcontainsirritatingcharacter FROM @sourcetable

SELECT * FROM @test