Code Master - A reference guide for programmer's

Programming is fun and interesting. As you all know, sometime we programmers stucks in the middle way of coding without getting a solution. Blogs like this will help us to find a path to solve our problems. The contents of this blog are the solutions that I found by myself and from other sources. Sharing such solutions is also interesting. Thank you!

Showing posts with label stored procedures. Show all posts
Showing posts with label stored procedures. Show all posts
Tuesday, November 4, 2014

Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement

›
/* Drop all non-system stored procs */ DECLARE @name VARCHAR(128) DECLARE @SQL VARCHAR(254) SELECT @name = (SELECT TOP 1 [name]...
›
Home
View web version
Powered by Blogger.