07/02/2008
Basit bir trigger kodu
CREATE TRIGGER [dbo].[Trg_TriggerName]
ON [dbo].[TableName] FOR UPDATE AS
BEGIN
SET NOCOUNT ON;
DECLARE @TableId INT
SELECT @TableId = (SELECT TableId FROM Inserted)
END
14:48 Posted in Sql | Permalink | Comments (0) | Email this | Tags: sql trigger
Basit bir Cursor kodu
DECLARE @TableId INT
DECLARE CursorName CURSOR FOR
SELECT TableId FROM Table --WHERE TableId = @TableId
OPEN CursorName
FETCH NEXT FROM CursorName INTO @TableId
WHILE @@FETCH_STATUS =0
BEGIN
FETCH NEXT FROM CursorName INTO @TableId
END
CLOSE CursorName
DEALLOCATE CursorName
14:45 Posted in Sql | Permalink | Comments (0) | Email this | Tags: sql cursor