Blogs about: Stored Procedures
Featured Blog
Why I chose O/R Mapping (JPA) over Stored Procedures for CRUD
I don’t choose easily when a large project is on the line. It took me months to choose JSF over Swing. And most recently, I’ve chosen JPA over Stored Procedures. I know it may be frustr… more »
Regular, Average Java Programmer (RAJP)
Partial sprocs?
Ryan Hauert wrote 2 weeks ago: Dave and I have written a T4 template to generate Entity Framework-friendly INSERT, UPDATE, and DEL … more »
CASE Statement in SQL Query
— 1 comment
bwebster wrote 3 weeks ago: I’ve used SQL to varying degrees for a number of years. However, one of the features I’v … more »
C# and VB.NET Stored Procedures Suck
alexanderthegreatest wrote 1 month ago: Somebody found the blog you’re reading by searching Google for evidence that “c# stored … more »
SQL Danger
— 1 comment
alexanderthegreatest wrote 2 months ago: SQL Server supports a cooperative, non-preemptive threading model in which the threads voluntarily … more »
Why I chose O/R Mapping (JPA) over Stored Procedures for CRUD
— 6 comments
davidwburns wrote 2 months ago: I don’t choose easily when a large project is on the line. It took me months to choose JSF ov … more »
Can the Picky Diner learn to get along with the Happy Chef?
davidwburns wrote 2 months ago: In my previous post The Tale of the Happy Chef and the Picky Diner: Some thoughts on Stored Procedur … more »
The Tale of the Happy Chef and the Picky Diner: Some thoughts on Stored Procedures and JPA
— 1 comment
davidwburns wrote 2 months ago: Once upon a time, there was a Happy Chef. He was happy because every day he got to do what he loved … more »
Modifying Database Table Rows with the Java Persistence API
davidwburns wrote 2 months ago: Last Friday I worked through Modifying Database Table Rows with the Java Persistence API. It’ … more »
Tune stored procedures with exception handling in SQL Server 2005
philipal wrote 3 months ago: Exception handling was widely thought to be one of the weakest aspects of T-SQL script writing. Fort … more »
SQL Stored Procedures
venkat wrote 5 months ago: Global Variables: @@Error @@RowCount @@transaction @@identity If there is a bug in Insert, Update, d … more »
Stored Procedures and Rails - Part 2
— 1 comment
nasir wrote 5 months ago: Continued from Stored Procedures and Rails - Part 1 Now we know how to call our good and reliable s … more »
Stored Procedures and Rails - Part 1
— 1 comment
nasir wrote 5 months ago: There is no documentation in Rails about how to use stored procedures or atleast it is difficult to … more »
High Availability Architectures (3/4) - Performances
— 5 comments
ceciiil wrote 6 months ago: In the previous posts of this serie we’ve addressed the availability and scalability aspects o … more »
Stored Procedure returning different results based on how I compile it
Anthony Stevens wrote 6 months ago: This is driving me crazy. I have a stored procedure script that I can compile either from within SQ … more »
Tracking Database Record Changes at the Field Level
— 1 comment
Jim wrote 8 months ago: One of the projects that I’m currently working on is to track change requests including enhanc … more »
The nitty gritty...
— 1 comment
etweb wrote 8 months ago: Behind every good man is a good woman… I know that certainly is true with me (right honey). Be … more »
Parameters in Stored Procedures
bwebster wrote 9 months ago: This tips comes from Doug Nelson, in his blog entry “Optional Parameters in Stored Procedures … more »
Stored Procedures in SQL
bwebster wrote 9 months ago: Most of the projects I work on use MS SQL server as a data store. When setting up a database, I usu … more »
Difference between Temp tables and Table variables
girishsprabhu wrote 9 months ago: There are three major theoretical differences between temporary tables: create table #T (…) And ta … more »
Have your say. Start a blog.
See our free features »
Copyright 2008 Automattic, Inc.
An 
Invention
