Easily delete database objects
The stored procedure sp_DropDatabaseObject is designed to easily drop a variety of database objects with extensive feedback to the user
2010-05-26 (first published: 2009-04-21)
1,453 reads
DROP PROCEDURE
DROP all stored procedures
This code will drop all stored procedures made with splog. With minor modification it will also drop all functions and sp not made with splog.
2009-03-13 (first published: 2009-02-12)
1,007 reads
RE: Creating a Glossary
I've never done it before but the first idea that comes to mind is as follows: create table tHyperlinkedTerms (hyperLinkedTermsId int IDENTITY, keyword varchar(100), description varchar(4000)) create table tGlossary (glossaryId int IDENTITY, keyword varchar(100), description varchar(4000)) -- a n to m match on this table where n<=m or m<=n -- with foreign keys pointing back […]
2003-06-16
RE: Documentation of Extended Stored Procedures
1) You won't. Microsoft has chosen not to document all of the extended stored procedures in the environment. Researchers like Alex Chigrik have written some articles covering undocumented extended stored procedures, but I don't believe any article covers 100% of the extended stored procedures. 2) Not without some tricks, no. People have done this using […]
2003-06-16
RE: What makes a good developer?
Hello Tomi, quote: Do you actually say "häh" in Germany? That's cool, we have exactly the same word here in Finland. yes we do, although it is considered rather slang. Cheers, Frank
2003-06-11
RE: Using variables within IN
Hello demos, quote: SELECT * FROM TableA WHERE ColumnB IN (@SomeVariable) and the variable can be = 1 or = 1,2,3 etc SELECT * FROM tablea WHERE ColumnB BETWEEN lower_bound and upper_bound Cheers, Frank
2003-06-11
1 reads
Blogs
Parsing EXE Output in PowerShell
By Steve Jones
I saw a post internally that asked this question: Anyone have a handy powershell...
Open Enrollment at WordPress.com: Free Websites for Students
By Rob Sewell
A website can change the world. If you're a student, we'd like to help...
Connect With More Clients: Our Partner Directory Has Arrived
By Rob Sewell
The partner directory connects your agency with new customers.
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers