Viewing 15 posts - 1 through 15 (of 34 total)
Thanks John, I didn't know of SELECT INTO and misread it as INSERT INTO.
Doing as you suggested has shown me that in this instance '1' got evaluated as an INT.
February 21, 2020 at 3:29 pm
I don't understand what you mean because if I SELECT INTO an existing table, doesn't that mean the table I am selecting into already has its datatypes defined? So if...
February 21, 2020 at 3:16 pm
Mr Brian Gale - you asked if this was a cross-database query, and that's exactly what it turned out to be, thank you. I needed to grant datareader permissions in...
February 18, 2020 at 4:07 pm
Hi Sue, I have tried the script you linked to, thanks. However it does not return anything that was created for our database, instead it returns items that appear to...
February 17, 2020 at 10:19 am
Since checking the AG was set against the datasource and dataset correctly, my Administrator has been able to enable remote errors for me this morning and I now have...
February 14, 2020 at 11:45 am
Thanks Sue, I read the post. The stuff about XML was a bit over my head, however there was a nifty answer in the comments that resolved this for me,...
September 11, 2019 at 4:00 pm
I tried putting the results in to a variable and selecting the datalenght() of that, I can see that the lenght is longer so I assume it does contain all...
September 11, 2019 at 10:11 am
Thanks, I tried, however outputting to file also seems to have the truncating problem
September 11, 2019 at 10:10 am
February 14, 2019 at 7:55 am
February 12, 2019 at 2:05 am
February 11, 2019 at 8:15 am
February 11, 2019 at 6:23 am
February 11, 2019 at 4:53 am
It sounds like you might need to use the FOR XML clause. Would something like this help you? You can copy and paste the entire code in to a new...
February 11, 2019 at 4:03 am
SELECT @ResultVar=CAST(N'' AS XML).value('xs:base64Binary(xs:hexBinary(sql:column("P1")))', 'VARCHAR(MAX)') ...
November 13, 2018 at 3:03 am