var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: convert trigger to sp
can uexplain how come it is possible to convert trigger to stored procdure
.pls explain with an example
Here's an example of a simple INSERT proc.
CREATE PROC dbo.prc_tblInsert
(@x INT, @y INT, @z INT)
SET NOCOUNT ON;
INSERT INTO dbo.tbl (x, y, z)
VALUES (@x, @y, @z);
thanks for ur reply.
i need an example for comparsion between triggers and stored procedure.Not for sp alone.
A trigger IS a stored procedure, ie. a "triggered" stored procedure. If you explain what you want the procedure to do then someone may be able to help you write it.