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
splog
AUTOGENERATE Stored procedures example
This is related to my other autogenerate code. this is just an example of how to use it.
2008-11-21
719 reads
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
RE: DELETE DUPLICATE ROWS
Thanks Jay it worked with the double FROM WTRDET statement. Its strange though while i was testing SQL with the same SELECT * query it gave me an error. But worked fine with the DELETE STATEMENT. Thanks once again for your time and help.
2003-06-05
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