Viewing 15 posts - 181 through 195 (of 203 total)
Aaron N. Cutshall (8/10/2009)
August 10, 2009 at 9:19 am
sathesg (8/4/2009)
The script is very good, but how to convert the data again to english ?
You don't have to. It is already stored in correct format. Selecting inserted records from...
August 4, 2009 at 9:53 am
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,...
July 23, 2009 at 11:04 am
Lynn Pettis (7/23/2009)
There really should have been a third choice: It Depends. It really does, what data type is being converted to what data type?
Exactly. It also depends on...
July 23, 2009 at 11:00 am
a_k93 (7/3/2009)
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...
July 3, 2009 at 10:18 am
noelpv (7/2/2009)
Or you can set column width:Tools \ Options \ Query results \ SQL Server \ Results to Text \ Maximumnumber of characters displayed in each column
Yes, this is exactly...
July 2, 2009 at 11:42 am
a_k93 (7/2/2009)
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...
July 2, 2009 at 10:24 am
imran.raza (7/2/2009)
set quoted_identifier off
declare @sql1 nvarchar(1000)
set @sql1="select 'insert county (county_fips, state_fips) values(''' + county_fips + ''',''' + state_fips...
July 2, 2009 at 9:30 am
wilkimatt (7/2/2009)
.....................
The result is this:
insert into dbo.ecspuraccount ([id], [reference], [name], [address_1], [address_2],...
July 2, 2009 at 9:02 am
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...
July 1, 2009 at 8:01 pm
TSycamore (7/1/2009)
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,...
July 1, 2009 at 3:06 pm
TSycamore (7/1/2009)
I tried it on a relatively small, simple table and it worked fine. However, on a larger...
July 1, 2009 at 12:52 pm
Chris Howarth (7/1/2009)
e.g.
SELECT CONVERT(VARCHAR(MAX), 0x484920544845524521,...
July 1, 2009 at 10:02 am
Viewing 15 posts - 181 through 195 (of 203 total)