Forum Replies Created

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

  • RE: Where clause of an "instead of" trigger

    Hi,

    No that is the answer. I just didn't explain in my initial post that the

    the where clause of the delete would only affect one row.

    ALTER TRIGGER...

    April 21, 2011 at 5:20 am

    #1314415

  • RE: Sql server

    If all the values are the same then you could use group by.

    CREATE TABLE #tmp (f1 INT)

    INSERT INTO#tmp VALUES (1)

    INSERT INTO#tmp VALUES (1)

    INSERT INTO#tmp VALUES (1)

    --SELECT * FROM...

    April 21, 2011 at 3:14 am

    #1314379

  • RE: Can't specify a certificate EXPIRY_DATE

    ALZDBA (10/14/2009)

    Apparently there is a little bug in this create statement !!

    It works if you first specify the start date and then the expire date !

    CREATE CERTIFICATE DavesCertificate

    WITH SUBJECT...

    October 14, 2009 at 8:23 am

    #1065714

  • RE: How to create a Temp Table?

    zy-eliz (10/14/2009)

    I would Like to create a temporary table to store data to do some testing. How can I create a temp table? How do I go about doing it?

    Thanks.

    You...

    October 14, 2009 at 7:29 am

    #1065645

  • RE: Selecting from a Linked Server

    There have been no further changes abd it works fine now, can't explain that.

    Cheers

    Dave

    February 25, 2009 at 8:09 am

    #950000

  • RE: Real line numbers

    Madhivanan (2/20/2009)

    Double click the error

    It will move the cursor to the specific line

    Fantastic! That is so useful.

    Regards

    Dave

    February 20, 2009 at 4:41 am

    #947416

  • RE: Database objects & version control- Best practices?

    Jack Corbett (2/17/2009)

    I have not used it it yet, but RedGate offers some of this functionality integrated with SQLCompare using SQLChangeset. This integrates with SourceSafe.

    We currently use a number...

    February 18, 2009 at 2:58 am

    #945751

  • RE: Database objects & version control- Best practices?

    Thanks for that, we seem to have missed the part about scripting each object to a single file.

    February 18, 2009 at 2:52 am

    #945750

  • RE: "Calling" an HTTPS site from T-SQL?

    Luke L (12/18/2008)

    So I guess there are a couple of basic questions here...

    1, is this some sort of API or whatever that you are being forced to interact with and...

    December 18, 2008 at 10:03 am

    #914703

  • RE: "Calling" an HTTPS site from T-SQL?

    david.gray (12/18/2008)

    Hi,

    Is "calling" the right terminology for the action do you think?

    Or is "visit" more acurate... 🙂

    December 18, 2008 at 9:39 am

    #914682

  • RE: "Calling" an HTTPS site from T-SQL?

    Hi,

    Yes I thought C# would be the answer.

    Is "calling" the right terminology for the action do you think?

    Dave

    December 18, 2008 at 9:36 am

    #914680

  • RE: Strange problem.

    Jack Corbett (9/24/2008)

    david.gray (9/24/2008)

    Hi,

    Yes I've tried both 'TEXT' and 'HTML', makes no difference.

    I sent the email to a collegue, they did not get the first error but...

    September 24, 2008 at 10:14 am

    #876506

  • RE: Strange problem.

    Hi,

    Yes I've tried both 'TEXT' and 'HTML', makes no difference.

    I sent the email to a collegue, they did not get the first error but go the second...

    September 24, 2008 at 8:07 am

    #876381

  • RE: Test SQL version in a stored procedure?

    Thanks all who responded, I've got this working now using...

    Select @SqlVersion = LEFT(CAST(SERVERPROPERTY('productversion') AS VARCHAR(10)),1)

    Regards

    Dave

    September 9, 2008 at 5:32 am

    #868954

  • RE: Test SQL version in a stored procedure?

    Hi Chris,

    Thanks for the quick response.

    On SQL 2005 that returns 005 and on SQL2000 it returns 2000.

    That will do the job but is it reliable? ...

    September 8, 2008 at 8:43 am

    #868496

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