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 NameDB NameFile Typefile_size MBFile NameDisk DriveDrive Free Space (MB)SQLVersion

    Thank you and Regards,

    Tsinelas

    Hi Slippers,

    Can...

  • 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. ...

  • RE: Site for good SQL learnings

    Thanks to all:-)

  • RE: Site for good SQL learnings

    Mr. Kapsicum (10/7/2013)


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

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

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...

  • 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,...

  • 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...

  • 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...

  • 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...

  • 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...

  • 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,...

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