Forum Replies Created

Viewing 15 posts - 1 through 15 (of 66 total)

  • RE: SQL Server 2000

    Tsinelas (10/21/2013)

    Hi SQL Masters,

    Greetings!

    Do you have any idea where to pull these fields from sql server 2000?

    Server Name DB Name File Type file_size MB File Name Disk Drive Drive Free Space (MB) SQLVersion

    Thank you and Regards,

    Tsinelas

    Hi Slippers,

    Can...

    October 21, 2013 at 3:17 am

    #1660059

  • RE: Site for good SQL learnings

    dwain.c (10/8/2013)

    The best learning is by doing, and I agree that this site is extraordinary for this.

    Pick a problem that someone has posted and try to solve it yourself. ...

    October 9, 2013 at 6:47 pm

    #1657353

  • RE: Site for good SQL learnings

    Thanks to all:-)

    October 8, 2013 at 7:51 pm

    #1656975

  • RE: Site for good SQL learnings

    Mr. Kapsicum (10/7/2013)

    well, u r on a great site already.......!!! 🙂

    Oh Really??....Thank you:-)

    October 7, 2013 at 2:49 am

    #1656260

  • RE: single quotes

    Jeff Moden (10/6/2013)

    Just a reminder to remember not to use anything from the parameters in direct concatenation in the dynamic SQL. Poorly formed dynamic SQL is still the leading...

    October 6, 2013 at 6:48 pm

    #1656207

  • RE: How to make the checkbox stays checked when double click

    Sean Lange (10/4/2013)

    I will go one step further and think outside the checkbox. 😉

    You seem to have 3 checkboxes that you want to allow only one of them to...

    October 4, 2013 at 6:26 pm

    #1656074

  • RE: How to make the checkbox stays checked when double click

    OCTom (10/4/2013)

    One does not double-click a check box. A single-click does the trick. Double-clicking a check box checks it then unchecks it right away.

    Hi

    It seems you did not...

    October 4, 2013 at 6:22 pm

    #1656073

  • RE: Is this right if i will do my project this way?..

    Brandie Tarvin (10/3/2013)

    enriquezreyjoseph (10/2/2013)

    my classes contains a connectionString to a different server, because every server contains a different databases, so meaning in every classes i have different connectionString that will...

    October 3, 2013 at 6:35 pm

    #1655722

  • RE: Is this right if i will do my project this way?..

    Koen Verbeeck (10/3/2013)

    Brandie Tarvin (10/3/2013)

    Jeff Moden (10/3/2013)

    Lynn Pettis (10/3/2013)

    enriquezreyjoseph (10/2/2013)

    Jeff Moden (10/2/2013)

    enriquezreyjoseph (10/1/2013)

    Hi Everyone..I hope everyone is having a nice day:-)

    Is this right if i will do my project this...

    October 3, 2013 at 6:32 pm

    #1655721

  • RE: Is this right if i will do my project this way?..

    Jeff Moden (10/2/2013)

    enriquezreyjoseph (10/1/2013)

    Hi Everyone..I hope everyone is having a nice day:-)

    Is this right if i will do my project this way?

    Please see my attachment

    If it's strictly an ETL project,...

    October 2, 2013 at 6:44 pm

    #1655362

  • RE: Is this right if i will do my project this way?..

    my classes contains a connectionString to a different server, because every server contains a different databases, so meaning in every classes i have different connectionString that will open the connection...

    October 2, 2013 at 6:41 pm

    #1655361

  • RE: Is this right if i will do my project this way?..

    SQLRNNR (10/2/2013)

    To me it looks like all of the arrows are going in the wrong direction.

    You have a class that populates a dataset and that class also gets shipped off...

    October 2, 2013 at 6:34 pm

    #1655359

  • RE: Can You make this code Shorter??..

    Cadavre (9/28/2013)

    enriquezreyjoseph (9/27/2013)

    Can I used this instead of sp_executesql i will use EXEC only??...cadavare

    I'm not sure how many times I have to say "SQL Injection" to you. . . yes...

    October 1, 2013 at 9:54 pm

    #1655109

  • RE: Is this Correct Use of Dynamic SQL???

    set ANSI_NULLS ON

    set QUOTED_IDENTIFIER ON

    go

    -- =============================================

    -- Author: <Author,,Name>

    -- Create date: <Create Date,,>

    -- Description: <Description,,>

    -- =============================================

    ALTER PROCEDURE [dbo].[SearchBiography]

    @firstname nvarchar(50),

    @middlename nvarchar(50),

    @lastname nvarchar(50),

    @sexID...

    September 29, 2013 at 7:08 pm

    #1654392

  • RE: Is this Correct Use of Dynamic SQL???

    Cadavre (9/28/2013)

    When you post in multiple threads like this, you fragment answers and make people have to start from the beginning again with helping you. If you have further questions,...

    September 29, 2013 at 5:47 pm

    #1654380

Viewing 15 posts - 1 through 15 (of 66 total)