Click here to Skip to main content
14,974,631 members
Home / Discussions / Database
   

Database

 
GeneralRe: MS SQL Database Bridge Pin
Richard Deeming14-Aug-20 5:38
mveRichard Deeming14-Aug-20 5:38 
GeneralRe: MS SQL Database Bridge Pin
Otekpo Emmanuel14-Aug-20 5:56
MemberOtekpo Emmanuel14-Aug-20 5:56 
QuestionAws lamda Pin
Member 1490095628-Jul-20 2:16
MemberMember 1490095628-Jul-20 2:16 
AnswerRe: Aws lamda Pin
CHill604-Aug-20 3:02
mveCHill604-Aug-20 3:02 
AnswerRe: Aws lamda Pin
MichaelFern15-Sep-20 2:19
MemberMichaelFern15-Sep-20 2:19 
QuestionNeed a script, SDF or UDF for checking the following conditions and make IF Else in a stored procedure SQL Server Pin
simpledeveloper21-Jul-20 9:45
Membersimpledeveloper21-Jul-20 9:45 
AnswerRe: Need a script, SDF or UDF for checking the following conditions and make IF Else in a stored procedure SQL Server Pin
Richard MacCutchan21-Jul-20 10:28
mveRichard MacCutchan21-Jul-20 10:28 
GeneralRe: Need a script, SDF or UDF for checking the following conditions and make IF Else in a stored procedure SQL Server Pin
simpledeveloper21-Jul-20 11:57
Membersimpledeveloper21-Jul-20 11:57 
GeneralRe: Need a script, SDF or UDF for checking the following conditions and make IF Else in a stored procedure SQL Server Pin
Richard MacCutchan21-Jul-20 21:30
mveRichard MacCutchan21-Jul-20 21:30 
AnswerRe: Need a script, SDF or UDF for checking the following conditions and make IF Else in a stored procedure SQL Server Pin
Eddy Vluggen21-Jul-20 10:35
professionalEddy Vluggen21-Jul-20 10:35 
AnswerRe: Need a script, SDF or UDF for checking the following conditions and make IF Else in a stored procedure SQL Server Pin
W Balboos, GHB21-Jul-20 11:01
mveW Balboos, GHB21-Jul-20 11:01 
AnswerRe: Need a script, SDF or UDF for checking the following conditions and make IF Else in a stored procedure SQL Server Pin
Richard Deeming21-Jul-20 23:25
mveRichard Deeming21-Jul-20 23:25 
QuestionHow to optimize Hash Match aggregation in SQL Server execution plan Pin
kali siddhu17-Jul-20 0:38
Memberkali siddhu17-Jul-20 0:38 
AnswerRe: How to optimize Hash Match aggregation in SQL Server execution plan Pin
Eddy Vluggen21-Jul-20 10:44
professionalEddy Vluggen21-Jul-20 10:44 
QuestionDead lock issue with Update and delete statement on the same table Pin
kali siddhu14-Jul-20 23:37
Memberkali siddhu14-Jul-20 23:37 
AnswerRe: Dead lock issue with Update and delete statement on the same table Pin
David Mujica15-Jul-20 10:57
MemberDavid Mujica15-Jul-20 10:57 
GeneralRe: Dead lock issue with Update and delete statement on the same table Pin
kali siddhu15-Jul-20 23:33
Memberkali siddhu15-Jul-20 23:33 
QuestionIs there any alternative for Trigger After Insert Pin
simpledeveloper13-Jul-20 17:56
Membersimpledeveloper13-Jul-20 17:56 
AnswerRe: Is there any alternative for Trigger After Insert Pin
Richard Deeming13-Jul-20 22:35
mveRichard Deeming13-Jul-20 22: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:
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 10:41
Membersimpledeveloper14-Jul-20 10:41 
QuestionConnection Resources Pin
Richard Andrew x6411-Jul-20 13:50
professionalRichard Andrew x6411-Jul-20 13:50 
AnswerRe: Connection Resources Pin
Richard Deeming13-Jul-20 0:04
mveRichard Deeming13-Jul-20 0:04 
QuestionSql server deadlock issue with table bulk insert and update on same table Pin
kali siddhu29-Jun-20 21:18
Memberkali siddhu29-Jun-20 21:18 
AnswerRe: Sql server deadlock issue with table bulk insert and update on same table Pin
Richard MacCutchan29-Jun-20 21:54
mveRichard MacCutchan29-Jun-20 21:54 
GeneralRe: Sql server deadlock issue with table bulk insert and update on same table Pin
kali siddhu30-Jun-20 23:29
Memberkali siddhu30-Jun-20 23:29 

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.