consolidated script generator for multiple stored procedures
Consolidated script generator for multiple stored procedures (existing and/or newly created) in MS Sql Server 2000/2005/2008 at one go
2011-07-15 (first published: 2011-03-28)
2,057 reads
Stored Procedures
Changing Text in Multiple Stored Procedures From a Stored Procedure
In this article Brian Davey present a solution for changing the text in multiple stored procedures using T-SQL.
2011-03-28
11,287 reads
2011-01-17 (first published: 2011-01-05)
7,138 reads
2010-11-26
3,108 reads
2010-07-15 (first published: 2010-06-16)
1,906 reads
2010-06-09
4,102 reads
Get default values of parameters in stored procedures
Helps to get the default value of parameters from stored procedures and functions.
2010-06-22 (first published: 2010-05-26)
3,345 reads
Slow SP with date parameters solved.
when you use datetime parameters in SPs in the where clause the SP becomes very slow
2010-04-28 (first published: 2010-04-26)
2,865 reads
2010-03-01
4,137 reads
2009-11-16
3,815 reads
Blogs
A New Word: Lookaback
By Steve Jones
lookaback– n. the chock of meeting back up with someone and learning that your...
Azure Vulnerability Assessments
Regarding managing databases in the cloud, security should never be an afterthought. That’s where...
Speaking at the NYC Lunch and Learn–May 23
By Steve Jones
In a couple of weeks, I’ll be in New York City for the Redgate...
Forums
How Do You Know You Are Right?
Comments posted to this topic are about the item How Do You Know You...
continuous membership
Hi, I am trying to find everyone who had membership for a continuous year...
Migrating data from using ManagerId to HierarchyId
I have a table called Person with the following schema: CREATE TABLE [People].[Person]( [Id]...
Question of the Day
Decoding the Collation II
In a collation setting, like Latin1_General_100_CI_AS_KS_WS_SC_UTF8, what does the WS mean?
See possible answers