Showing posts with the label triggers
Simple Insert Update and Delete Triggers in SQL Server with example

Simple Insert Update and Delete Triggers in SQL Server with example

By Krunal Shah
In this article I will explain with simple example…
Delete and Drop all the tables, stored procedures, triggers, constriants and all the dependencies in one sql statement.

Delete and Drop all the tables, stored procedures, triggers, constriants and all the dependencies in one sql statement.

By Krunal Shah
/* Drop all non-system stored procs */ DECLARE @ name VARCHAR ( 128 ) DECLARE @ SQL VARCHAR ( 254 ) SELECT @…