Forum Replies Created

Viewing 15 posts - 2,656 through 2,670 (of 2,757 total)

  • RE: VB.Net Question - NextRecordset missing ???

    mick burden (1/11/2010)

    Hi everyone, I normally use VB6 as my programming language to read and write to a SQL server (2000), I've recently gone over to VB.Net (2008), my problem...

    January 11, 2010 at 7:11 am

    #1101760

  • RE: Insert character question

    John Rowan (1/8/2010)

    Here it is using STUFF.

    DECLARE @Var varchar(10)

    SET @Var = 'XXXXXXXX'

    SELECT STUFF(@Var, LEN(@Var) - 2, 0, '.')

    Ah, yes. I defer to those who have more SQL experience than...

    January 8, 2010 at 3:54 pm

    #1101244

  • RE: Insert character question

    hansontd (1/8/2010)

    I need to insert a period in a varchar column always 3 "places" over from the right side of the value for example XXXX.XX

    I suspect there might be a...

    January 8, 2010 at 3:39 pm

    #1101238

  • RE: Jr sql dba phone interview questions

    Jeff Moden (1/8/2010)

    It's almost impossible for you to "prepare" for questions that people will ask you on an interview. Just be yourself and be 100% honest. "Absolute Honesty"...

    January 8, 2010 at 3:28 pm

    #1101233

  • RE: Jr sql dba phone interview questions

    ddlawal (1/8/2010)

    I need a mentor too.......any takers?

    Just keep posting to these forums. You'll find plenty of 'em! 🙂

    January 8, 2010 at 7:42 am

    #1100885

  • RE: Talking baseball

    Just to get this discussion started . . .

    Ray K (1/7/2010)

  • What players, active or retired, who are NOT yet eligible for the Hall deserve enshrinement?

    • Off the top of my head:...

    January 7, 2010 at 2:07 pm

    #1100505

  • RE: Talking baseball

    I just came across this article which seems to fall in line with this thread.

    January 7, 2010 at 1:57 pm

    #1100493

  • RE: mod 10 weights 1, 2

    I don't think you're going to find too many people here who are going to be able to (or even want) to go through your VB code.

    Better: can you give...

    January 7, 2010 at 1:24 pm

    #1100473

  • RE: Talking baseball

    CirquedeSQLeil (1/7/2010)

    Alomar - spitting is keeping him out

    Actually, I understand that Alomar has since apologized, and the umpire who was the intended target has not only forgiven him, he has...

    January 7, 2010 at 12:05 pm

    #1100427

  • RE: Linked Server Security

    The security issue is a good question. I wouldn't mind learning more about this myself.

    As for how to link servers, I've had good luck with the sp_addlinkedserver SP. ...

    January 7, 2010 at 11:57 am

    #1100419

  • RE: Talking baseball

    Actually, here's some fodder for discussion . . .

    • What players, active or retired, who are NOT yet eligible for the Hall deserve enshrinement?

    • What active players who've been active for less...

    January 7, 2010 at 11:50 am

    #1100414

  • RE: Upgrade Clustered SQL Server 2005 Enterpise edtion 64 bit to SQL Server 2008 Enterprise Edition

    No problem. Apologies if I sound like I'm being hard on you. 🙂

    January 7, 2010 at 11:34 am

    #1100401

  • RE: Talking baseball

    Markus (1/7/2010)

    I agree. The numbers don't change from year one to year two. I fail to see the logic on how someone gets in in year two, three, five...

    January 7, 2010 at 11:33 am

    #1100400

  • RE: Convert DateTime to MMDDYY

    pgatte (1/7/2010)

    I am new to SQL.

    Can you tell me how I would convert a DateTime field to MMDDYY without any / or .

    Example I would need the field...

    January 7, 2010 at 11:24 am

    #1100393

  • RE: Upgrade Clustered SQL Server 2005 Enterpise edtion 64 bit to SQL Server 2008 Enterprise Edition

    gmamata7 (1/7/2010)

    could you please advice me..

    thanks

    Suggestion: please state your problem clearly and succinctly. We can't do that with what you wrote. Reading is work. We don't want...

    January 7, 2010 at 11:16 am

    #1100388

    • Viewing 15 posts - 2,656 through 2,670 (of 2,757 total)