Goldie Graber (11/17/2009)

---

Lynn Pettis (11/17/2009)

---

I GOT it!

The query should have been written like this instead of as four separate queries:

SELECT

DATEADD(day, -1, GETDATE()),DATENAME (dw ,DATEADD(day, -1, GETDATE())...

This is true, this question seems to do the trick of becoming a clear leader in this category. In SQL...

Aaron N. Cutshall (8/10/2009)

---

I've been burnt by this "feature" too often to not recognize it! It took me hours to track down an issue cause by a string truncation...

You don't have to. It is already stored in correct format. Selecting inserted records from...

The good news is that though the answer could be it depends, answering the question was not difficult given existing choices. The question asked whether it is possible or not,...

Exactly. It also depends on...

a_k93 (7/3/2009)

---

Hi there,

Thnx for your reply. I tried your work around but it seems to be not working, may be I am making some mistake, but let me tell you...

Yes, this is exactly...

a_k93 (7/2/2009)

---

Hi there,

Nice article, I have one question. When I change your sample code from...

and ran the statement it raised an error

Operand type clash: varbinary is incompatible with...

imran.raza (7/2/2009)

---

I have found more better way to do this as mention below

set quoted_identifier off

declare @sql1 nvarchar(1000)

set @sql1="select 'insert county (county_fips, state_fips) values(''' + county_fips + ''',''' + state_fips...

wilkimatt (7/2/2009)

---

Scripting in binary format is a great idea, however the script is failing for some reason with this table:

.....................

The result is this:

insert into dbo.ecspuraccount ([id], [reference], [name], [address_1], [address_2],...

Tony Webster (7/1/2009)

---

Also, not that it probably matters too much in practice, but that function call has a bit of a performance hit - that's what makes it take about...

TSycamore (7/1/2009)

---

Oleg,

Interesting...

What I am getting when I run your example of handling a text data type is:

insert into dbo.test ([col1], [col2]) values (0x00000001, 0x73616d706c6520312c73616d706c652031);

insert into dbo.test ([col1], [col2]) values (0x00000002,...

TSycamore (7/1/2009)

---

Very good article. This technique could be very useful to me right now.

I tried it on a relatively small, simple table and it worked fine. However, on a larger...

Chris Howarth (7/1/2009)

---

Another new feature of SQL Server 2008 is an extension to the CONVERT function whereby a binary value can be converted to a string representation.

e.g.

SELECT CONVERT(VARCHAR(MAX), 0x484920544845524521,...