Forum Replies Created

Viewing 15 posts - 211 through 225 (of 789 total)

  • RE: how to calculate the avgerage of the value based on time interval

    More explanation in second column what data type it is, or can you post the structure of you table with these two columns ...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 5, 2009 at 12:53 am

    #1088126

  • RE: how to convert datetime excel sheet to sqlserver datetime

    When you import data from Excel using wizard, the column with Date will appear in this format

    yyyy-mm-dd hh:nn:ss.mss

    so you can now select the imported table with formatting date...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 5, 2009 at 12:39 am

    #1088125

  • RE: The Sixty-Second Guide to becoming a SQL Server DBA

    Haa interesting route to DBA...anyway not bad recommendation! Hope to someone becoming DBA with your guide!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 4, 2009 at 5:15 am

    #1087589

  • RE: SUM(Case) issue

    I agree with Lynn! Check my signature and why not to post the problem in the correct way and find the solution as better as we can!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 2, 2009 at 7:49 am

    #1086497

  • RE: Installation of Sql Server 2005 in Windows Vista

    I suggest you to upgrade in Windows 7, if you want to be comfortable with you SQL Server installation!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 2, 2009 at 6:25 am

    #1086433

  • RE: How to compare two tables from two servers.

    It will take long time if your table has lot of columns and many data types, here I'm talking for the structure of the table and all other objects related...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 2, 2009 at 6:19 am

    #1086426

  • RE: Can you Alias a database name?

    Ok, seems that you are in domain environment from your scenario, so you can do the database aliases in you DNS Server where you put the name for the SQL...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 2, 2009 at 6:03 am

    #1086408

  • RE: Triggers

    ekknaveen (12/1/2009)

    I had two triggers update and delete on xyz table. I created another trigger for insert on the same (xyz) table. But this is executing after 5 minutes of...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 2, 2009 at 5:50 am

    #1086395

  • RE: Migrate from sql server 2005 to 20008

    First of All ...BACKUP everything that you have in SQL Server Express 2005.

    After that, you can leave installed the SQL Server Express, and starting installation then migration to SQL...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 2, 2009 at 5:42 am

    #1086388

  • RE: restrict the delete recorde in database or datatable by using trigger

    dastagirid (11/19/2009)

    Thanks alot...................

    Exactly This is for I asked.

    You are welcome!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    November 20, 2009 at 10:37 am

    #1082367

  • RE: Symantec Backup Exec agent

    Steve Jones - Editor (11/19/2009)

    I'll second Andrew's experiences. It's been a few years (6-7), but I worked in one place that had it and ran into it twice while consulting....

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    November 20, 2009 at 1:20 am

    #1082009

  • RE: restrict the delete recorde in database or datatable by using trigger

    Sorry this is for you problem:

    CREATE TRIGGER CANNOT_DELETE

    ON YOURTABLE

    FOR DELETE

    AS

    BEGIN

    RAISERROR ('DELETIONS ARE NOT ALLOWED!!!',16,1)

    ROLLBACK TRANSACTION;

    END

    The code above is for the auditing the deletions!

    Anyway you have 2 alternatives to...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    November 19, 2009 at 7:30 am

    #1081554

  • RE: restrict the delete recorde in database or datatable by using trigger

    dastagirid (11/19/2009)

    Sorry for this..

    I have 10 records in a table.

    Now i am going to delete one record in a table.

    When i have to use trigger to restrict the delete...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    November 19, 2009 at 7:22 am

    #1081543

  • RE: restrict the delete recorde in database or datatable by using trigger

    can you post more info about your problem ...!? Better to answer with more information if we have..anyway check BOL!

    http://msdn.microsoft.com/en-us/library/aa258254%28SQL.80%29.aspx

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    November 19, 2009 at 5:59 am

    #1081488

  • RE: Backup not working ...Error 3241

    Ok just for info about this problem that I done everything with export and inserting data to the existing table but first deleting the old data then reseeding values and...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    October 23, 2009 at 2:36 am

    #1069849

Viewing 15 posts - 211 through 225 (of 789 total)