Tags » Comma

Spliting and Inserting Comma Delimited String Values in Separate Table

Following script splits the comma delimited string and insert resultant values in a separate table.



DECLARE @DS nvarchar(max) = '3,4,5,6,7,8,9';
DECLARE @Pos int;-- =0;
select @Pos = CHARINDEX (',',@DS);
WHILE (1=1)
BEGIN

print 'position=' +cast ( @pos as varchar);

insert into TestDB.dbo.TestTable(ID)
select left(@DS,1)
set @DS= RIGHT(@DS, LEN(@DS)-@Pos);

IF NOT (@Pos=2) BREAK;
select @Pos = CHARINDEX (',',@DS);

END
T-SQL

Dry Transfer Lettering Brackets, Period, Comma, 12,16,18pt, 10/PK

Reviews Dry Transfer Lettering Brackets, Period, Comma, 12,16,18pt, 10/PK for sale

Please take a few moments to view the Dry Transfer Lettering Brackets, Period, Comma, 12,16,18pt, 10/PK… 74 more words

Interlude – Garden Entomology

Remember the potter’s wheel? I do which is a bit odd, since when I looked it up, I found that it was shown on the BBC in the 1950s and I’m not old enough to remember that far back. 685 more words

Butterflies

Editorial style meets … verb + verb

When is a comma truly unnecessary? And when should an editor leave an unnecessary comma alone? These are questions I ask myself often, especially when I see a comma between compound verbs. 1,244 more words

Editing

punctuation, part i

Recently, I reviewed the delightful Punctuation..? by User design. Since school is back in session, I thought a review of punctuation marks–that is, the origins of their curious names–may prove timely and instructive. 814 more words

Macro Photography : Comma by UlrikeSchaefer

Possibly my last butterfly photo of this season: a C-album, also known as Comma butterfly. The rugged shape of its wings is quite different from that of other butterflies, don’t you think? 6 more words