Viewing 15 posts - 5,221 through 5,235 (of 7,483 total)
SQL Kiwi (11/7/2011)
Jeff Moden (11/7/2011)
I agree with TOM. I recommend you continue to use DATALENGTH for the very reason he stated.
Trouble is, that implementation now only works with Unicode...
November 8, 2011 at 10:00 am
bopeavy (11/8/2011)
SQL Kiwi (11/8/2011)
vk-kirov (11/7/2011)
--------------------------------------------------------------------------------
Very interesting question, but 1) version-specific; 2) with wrong explanation.
Exactly. I was at a loss which answer to choose because they all seemed...
November 8, 2011 at 8:55 am
Steve Kinnaman (11/7/2011)
Yes That work great. A friend suggested to replace DATALENGTH with LEN, and that worked as well.
Using LEN instead of DATALENGTH will break if ever a filename has...
November 7, 2011 at 10:58 am
Gianluca Sartori (11/7/2011)
I think this is a very bad habit to kick and I put together an...
November 7, 2011 at 10:41 am
Here's the version that works for nvarchar.
use tempdb
IF OBJECT_ID('tempdb..[Dokument$]','U')IS NOT NULL DROP TABLE [Dokument$]
CREATE TABLE [dbo].[Dokument$](
[IDKEY] [nvarchar](255) NULL,[OFFERT] [nvarchar](255) NULL,)
INSERT INTO [dbo].[Dokument$] ([IDKEY],[OFFERT])
...
November 7, 2011 at 9:27 am
rfr.ferrari (11/7/2011)
Koen Verbeeck (11/6/2011)
TCP/IP needs a network adaptor. Isn't that hardware as well? 😛in QotD, "specific hardware" isn't any network card hardware!!!
In what respect are you claiming that this...
November 7, 2011 at 8:44 am
Koen Verbeeck (11/6/2011)
TCP/IP needs a network adaptor. Isn't that hardware as well? 😛
It was last time I looked.
But how about local loopback connections (TCIP to 127.0.0.1:1443)? They used to...
November 7, 2011 at 8:11 am
I've got a boring short list of activities from before I got caught up in doing things to databases, nothing like the broad spectrum displayed by Craig.
When I was young...
November 6, 2011 at 6:49 pm
Sean Lange (11/4/2011)
You bored Tom? You keep answering and commenting on qotd from 4 years ago. 😛
Every now and again I spend some time going through old QoTD. Mostly...
November 5, 2011 at 7:03 am
Jeff Moden (11/4/2011)
L' Eomot Inversé (11/3/2011)
There's nothing in recursion that prevents set-based description.
If you take a look at the "Reads" chart in the article I provided a link for in...
November 5, 2011 at 6:46 am
Joshua M Perry (12/27/2006)
<SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">By default you are correct:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN><P style="MARGIN: 0in 0in 0pt"><SPAN style="FONT-SIZE: 9pt; COLOR: blue; FONT-FAMILY: Verdana">SELECT</SPAN><SPAN style="FONT-SIZE:...
November 4, 2011 at 1:18 pm
Good question. But 2 points? It's not worth more than 1.
November 4, 2011 at 12:46 pm
Steve Jones - SSC Editor (1/16/2007)
Must have been one of those early morning or...
November 4, 2011 at 12:37 pm
Actually all the suggested answers are wrong. PAD_INDEX doesn't determine if space is left in pages and intermediate levels (the supposedly "correct" answer), indeed it doesn't even determine how...
November 4, 2011 at 11:38 am
Viewing 15 posts - 5,221 through 5,235 (of 7,483 total)