No it will not be affected..

ok, you can use DelimitedSplit8K function to split the string by Jeff Modem

you can follow this link

http://www.sqlservercentral.com/articles/Tally+Table/72993/

declare @varchar table

( Name varchar(100)

)

INSERT INTO @varchar values ( '1,100,12345|2,345,433|3,23423,123|4,33,55')

SELECT ITEM

FROM @varchar

CROSS APPLY...

With the help of SSIS you can achieve this easily

Check this link about Deferred name resolution you will find the answer:

http://technet.microsoft.com/en-us/library/ms190686(v=sql.105).aspx

Duplicate post:pinch:

what error you are getting?

Please post the code that you are...

Can you please post your code that you have written?

Did you...

GilaMonster (9/16/2013)

---

If you were getting an error saying that nulls are not allowed, then there were nulls in the select for that column.

Post the exact code, we can't tell what's...

Bhuvnesh (9/16/2013)

---

kapil_kk (9/16/2013)

---

This time I used new column also in the SELECT statement but it gives an error that NULL values not allowed in that column instead I was not...

Without seeing the actual code (or a working example of it) I'm assuming that your SELECT statement was being used to load data into every column EXCEPT the new column...

your requirement is not clear to us..can you please provide some more detail information what you exactly want?

Kurt W. Zimmerman (9/13/2013)

---

When ever I have to rely on dynamic SQL I print it out before I execute it. This way I can see if there are any...

Are the numbers and special characters present at the last of the string only?

+1