Viewing 15 posts - 5,221 through 5,235 (of 7,484 total)
Having both clientID and taskID in the hours worked table is fine if the there isn't something that says each task is applicable to only one client. If there...
November 8, 2011 at 10:10 am
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
Viewing 15 posts - 5,221 through 5,235 (of 7,484 total)