- Details
- Written by: Stanko Milosev
- Category: MS SQL
- Hits: 2928
create table log (tableName varchar(max), msg varchar(max))Log in trigger:
declare @xml XML set @xml = (select * from deleted for xml auto, elements ) insert into log(tableName, msg) values('deleted', cast(@xml as varchar(max)))
- Details
- Written by: Stanko Milosev
- Category: MS SQL
- Hits: 2047
IF EXISTS (SELECT * FROM sys.objects WHERE [name] = N'myTrigger' AND [type] = 'TR') BEGIN DROP TRIGGER [dbo].[myTrigger]; END; GOStored procedure with OBJECT_ID:
IF OBJECT_ID('dbo.mySP') IS NOT NULL DROP PROCEDURE dbo.mySP GOTemp table:
IF OBJECT_ID('tempdb..#myTempTable') IS NOT NULL DROP TABLE #myTempTable GO
- Details
- Written by: Stanko Milosev
- Category: MS SQL
- Hits: 4908
SQL Server Browser has to be enabled so that other machines can access it.