Trigger INSERT & DELETE From 2 Different Database Server

TRIGGER INSERT :
create trigger [dbo].[trigger name] on [dbo].[table name 1st]
after INSERT
as
begin
insert into [IP Address destination server].[2nd database name].[dbo].[table name 2nd]
select [Material]
,[MaterialDescr]
,[MatlGroup]
,[Createdby] from inserted
end

TRIGGER DELETE :
create trigger [dbo].[trigger name] on [dbo].[table name 1st]
for DELETE
as
declare @ID varchar(15)
SET @ID = (select [Material] from deleted)
begin
delete from [IP Address destination server].[2nd database name].[dbo].[table name 2nd]
where MATERIAL = @ID

end

Comments

VS2015 using Bootstrap

this is how you gonna do that.. yes it is sometimes learning using tutorial book makes us boring.. so this tutorial is how to make it simple but very useful in understanding Tutorial To Download

CheckBox dalam DataGridView VB.Net

Pada saat membuat aplikasi (VB.Net) untuk materi skripsi, terbesit bagaimana cara baru untuk memberikan hak akses user secara dinamis pada sistem. setelah dicoba dengan tanya-tanya. akhirnya bisa mendapatkan cara itu... wah sesuatu banget dah.... inti dari posting ini hanya pada barisan kode berikut : Private Sub BtnSIMPAN_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnSIMPAN.Click Dim Y As String = Mid(CmbUSER.Text, 1, 7) Dim iROW As Integer Dim AKSES As String For iROW = 0 To DGVSample.Rows.Count - 1 'AksesBox = Nama CheckBox yang ada di DatagridView If DGVSample.Rows(iROW).Cells("AksesBox").Value Then ...

Catch Digit Before Specific Symbol (Desc "-") Using VB.Net 2010

This is the way how to catch digit before a specific symbol, for this case the symbol means (desc "-"). situation would be as follows : "XXXXX-NAME" we would need to catch all "X" before desc "-", so value would be "XXXXX". even "X" is only 4 digits or more less we will get that all digit. VB Script would be as below to support our case : Click below picture for more clear preference

OPRAG-OPREG

Search This Blog