Click here to Skip to main content
15,112,453 members
Home / Discussions / Database
   

Database

 
AnswerRe: Need a script, SDF or UDF for checking the following conditions and make IF Else in a stored procedure SQL Server Pin
Richard Deeming22-Jul-20 0:25
mveRichard Deeming22-Jul-20 0:25 
QuestionHow to optimize Hash Match aggregation in SQL Server execution plan Pin
kali siddhu17-Jul-20 1:38
Memberkali siddhu17-Jul-20 1:38 
AnswerRe: How to optimize Hash Match aggregation in SQL Server execution plan Pin
Eddy Vluggen21-Jul-20 11:44
professionalEddy Vluggen21-Jul-20 11:44 
QuestionDead lock issue with Update and delete statement on the same table Pin
kali siddhu15-Jul-20 0:37
Memberkali siddhu15-Jul-20 0:37 
AnswerRe: Dead lock issue with Update and delete statement on the same table Pin
David Mujica15-Jul-20 11:57
MemberDavid Mujica15-Jul-20 11:57 
GeneralRe: Dead lock issue with Update and delete statement on the same table Pin
kali siddhu16-Jul-20 0:33
Memberkali siddhu16-Jul-20 0:33 
QuestionIs there any alternative for Trigger After Insert Pin
simpledeveloper13-Jul-20 18:56
Membersimpledeveloper13-Jul-20 18:56 
AnswerRe: Is there any alternative for Trigger After Insert Pin
Richard Deeming13-Jul-20 23:35
mveRichard Deeming13-Jul-20 23:35 
Use a computed column:
Specify Computed Columns in a Table - SQL Server | Microsoft Docs[^]

If you want to continue using a trigger, you'll need to update it to account for the fact that a trigger can be fired for multiple rows at the same time:
SQL
CREATE TRIGGER AfterInsert
   ON InspectionItems
   AFTER INSERT
AS 
BEGIN
    SET NOCOUNT ON;
    
    UPDATE
        T
    SET
        InspectionItemNumber = 'T' + RIGHT('00000' + CAST(InspectionItemId AS VARCHAR(5)), 6)
    FROM
        InspectionItems As T
        INNER JOIN inserted As I
        ON I.InspectionItemId = T.InspectionItemId
    ;
END
GO




"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

GeneralRe: Is there any alternative for Trigger After Insert Pin
simpledeveloper14-Jul-20 11:41
Membersimpledeveloper14-Jul-20 11:41 
QuestionConnection Resources Pin
Richard Andrew x6411-Jul-20 14:50
professionalRichard Andrew x6411-Jul-20 14:50 
AnswerRe: Connection Resources Pin
Richard Deeming13-Jul-20 1:04
mveRichard Deeming13-Jul-20 1:04 
QuestionSql server deadlock issue with table bulk insert and update on same table Pin
kali siddhu29-Jun-20 22:18
Memberkali siddhu29-Jun-20 22:18 
AnswerRe: Sql server deadlock issue with table bulk insert and update on same table Pin
Richard MacCutchan29-Jun-20 22:54
mveRichard MacCutchan29-Jun-20 22:54 
GeneralRe: Sql server deadlock issue with table bulk insert and update on same table Pin
kali siddhu1-Jul-20 0:29
Memberkali siddhu1-Jul-20 0:29 
GeneralRe: Sql server deadlock issue with table bulk insert and update on same table Pin
Richard MacCutchan1-Jul-20 0:31
mveRichard MacCutchan1-Jul-20 0:31 
GeneralRe: Sql server deadlock issue with table bulk insert and update on same table Pin
David Mujica1-Jul-20 6:36
MemberDavid Mujica1-Jul-20 6:36 
GeneralRe: Sql server deadlock issue with table bulk insert and update on same table Pin
kali siddhu16-Jul-20 0:44
Memberkali siddhu16-Jul-20 0:44 
AnswerRe: Sql server deadlock issue with table bulk insert and update on same table Pin
ZurdoDev1-Jul-20 8:03
professionalZurdoDev1-Jul-20 8:03 
QuestionHttp 500 error with register page Pin
and180y29-Jun-20 5:31
Memberand180y29-Jun-20 5:31 
AnswerRe: Http 500 error with register page Pin
ZurdoDev29-Jun-20 5:33
professionalZurdoDev29-Jun-20 5:33 
GeneralRe: Http 500 error with register page Pin
and180y29-Jun-20 5:45
Memberand180y29-Jun-20 5:45 
GeneralRe: Http 500 error with register page Pin
ZurdoDev29-Jun-20 5:49
professionalZurdoDev29-Jun-20 5:49 
AnswerRe: Http 500 error with register page Pin
Richard Deeming29-Jun-20 6:15
mveRichard Deeming29-Jun-20 6:15 
GeneralRe: Http 500 error with register page Pin
and180y29-Jun-20 6:21
Memberand180y29-Jun-20 6:21 
GeneralRe: Http 500 error with register page Pin
and180y29-Jun-20 8:40
Memberand180y29-Jun-20 8:40 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.