Forum Replies Created

Viewing 15 posts - 4,201 through 4,215 (of 7,613 total)

  • RE: Need query for After Trigger on update,delete

    Ed Wagner (8/17/2016)

    Jeff Moden (8/17/2016)

    ScottPletcher (8/17/2016)

    Again, auditors would not have access to the original table.

    But they have direct access to the audit table? That doesn't make sense to me...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    August 17, 2016 at 12:37 pm

    #1896009

  • RE: Loop through an integer and test the values and update with a char

    SELECT REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

    CAST(price AS varchar(20)),

    '0', 'A'),

    '1', 'B'),

    '2', 'C'),

    --...

    ...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    August 17, 2016 at 11:05 am

    #1895971

  • RE: how to copy data from primary table and its dependencies from one id to another and then how could I remove primary table with its dependencies

    You could. Or you could change the FK rules to "CASCADE" rather than "NO ACTION" -- at least temporarily -- then just try updating the id from 1 to...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    August 17, 2016 at 10:54 am

    #1895968

  • RE: what are some common naming conventions for sprocs?

    I prefer to name procedures first by topic area as well. I was merely pointing out that it's more common to use verb_object.

    Personally I despise a prefix that represents...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    August 17, 2016 at 9:52 am

    #1895950

  • RE: Need query for After Trigger on update,delete

    Jeff Moden (8/17/2016)

    ScottPletcher (8/17/2016)

    Jeff Moden (8/16/2016)

    ScottPletcher (8/16/2016)

    Jeff Moden (8/16/2016)

    ScottPletcher (8/16/2016)

    Even so, it's likely that for in-house audits, or less formal audits, the current table could be freely accessed, and then...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    August 17, 2016 at 9:37 am

    #1895947

  • RE: what are some common naming conventions for sprocs?

    Probably most common is verb_object, such as Get_UserName, or some such. I've never seen the "main" table name used as part of the proc name, and it seems like...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    August 17, 2016 at 8:53 am

    #1895937

  • RE: Need query for After Trigger on update,delete

    Jeff Moden (8/16/2016)

    ScottPletcher (8/16/2016)

    Jeff Moden (8/16/2016)

    ScottPletcher (8/16/2016)

    Even so, it's likely that for in-house audits, or less formal audits, the current table could be freely accessed, and then INSERTs might not...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    August 17, 2016 at 8:22 am

    #1895929

  • RE: Need query for After Trigger on update,delete

    Jeff Moden (8/16/2016)

    ScottPletcher (8/16/2016)

    Even so, it's likely that for in-house audits, or less formal audits, the current table could be freely accessed, and then INSERTs might not need logged. ...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    August 16, 2016 at 12:27 pm

    #1895743

  • RE: Update statistics after Index Rebuild ?

    Grant Fritchey (8/16/2016)

    MyDoggieJessie (8/16/2016)

    I've always been a little fuzzy on this one - So, is just executing sp_updatestats a safe bet after indexing? Realizing that rebuilildng indexes will only...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    August 16, 2016 at 11:32 am

    #1895727

  • RE: Need query for After Trigger on update,delete

    Even so, it's likely that for in-house audits, or less formal audits, the current table could be freely accessed, and then INSERTs might not need logged. But verify that...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    August 16, 2016 at 10:10 am

    #1895711

  • RE: Need query for After Trigger on update,delete

    Ed Wagner (8/16/2016)

    ScottPletcher (8/16/2016)

    Ed Wagner (8/16/2016)

    ScottPletcher (8/16/2016)

    Jeff Moden (8/15/2016)

    ScottPletcher (8/15/2016)

    Jeff Moden (8/15/2016)

    ScottPletcher (8/15/2016)

    Jeff Moden (8/15/2016)

    Also, you should probably avoid auditing inserts. It's an unnecessary duplication of data because even...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    August 16, 2016 at 10:05 am

    #1895708

  • RE: Need query for After Trigger on update,delete

    Ed Wagner (8/16/2016)

    ScottPletcher (8/16/2016)

    Jeff Moden (8/15/2016)

    ScottPletcher (8/15/2016)

    Jeff Moden (8/15/2016)

    ScottPletcher (8/15/2016)

    Jeff Moden (8/15/2016)

    Also, you should probably avoid auditing inserts. It's an unnecessary duplication of data because even if there's never...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    August 16, 2016 at 9:34 am

    #1895695

  • RE: Need query for After Trigger on update,delete

    Jeff Moden (8/15/2016)

    ScottPletcher (8/15/2016)

    Jeff Moden (8/15/2016)

    ScottPletcher (8/15/2016)

    Jeff Moden (8/15/2016)

    Also, you should probably avoid auditing inserts. It's an unnecessary duplication of data because even if there's never an update, the...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    August 16, 2016 at 8:23 am

    #1895661

  • RE: Need query for After Trigger on update,delete

    Jeff Moden (8/15/2016)

    ScottPletcher (8/15/2016)

    Jeff Moden (8/15/2016)

    Also, you should probably avoid auditing inserts. It's an unnecessary duplication of data because even if there's never an update, the original data lives...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    August 15, 2016 at 3:53 pm

    #1895536

  • RE: Finding data that does not exist in another table

    DECLARE @user-id nchar(10)

    SET @user-id = '001'

    SELECT @user-id AS UserID, p.*, 'Prods This User Hasn''t Purchased' AS Message

    FROM Prod_T p

    LEFT OUTER JOIN User_Prod_T up ON up.UserID = @user-id AND up.ProdID =...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    August 15, 2016 at 1:35 pm

    #1895509

Viewing 15 posts - 4,201 through 4,215 (of 7,613 total)