stored-procedures

How do you create SQL Server 2005 stored procedure templates in SQL Server 2005 Management Studio?

How do you create SQL Server 2005 stored procedure templates in SQL Server 2005 Management Studio? ...

Output parameters not readable when used with a DataReader

When using a DataReader object to access data from a database (such as SQL Server) through stored procedures, any output parameter added to the Command object before executing are not being filled after reading. I can read row data just fine, as well as all input parameters, but not output ones. [This question is actually just for anyo...

How do I run Oracle plsql procedure from Lisp?

How do I get started? ...

How do I determine using TSQL what roles are granted execute permissions on a specific stored procedure?

Is there a system stored procedure or a system view I can use? ...

What do you use to write and edit stored procedures in Oracle?

There are many options for editing and writing Stored Procedures in Oracle; what is the best tool for you and why? (one tool per answer.) ...

Stored procedures reverse engineering

We're having problem with a huge number of legacy stored procedures at work. Do you guys recommend any tool the can help better understand those procedures? Some kind of reverse engineering that indentifies inter-procedure dependencies and/or procedure vs. tables dependencies. Can be a free or commercial tool. Thanks! ...

When should you use java stored procedures with an Oracle database ... what are the drawbacks?

PL/SQL is not my native tongue. Oracle supports writing stored procedures in Java. What are the advantages of doing this over writing the stored procedures in PL/SQL ...

Stored Procedures in MS-SQL Server 2005 and Oracle

How to translate MS-SQL Server 2005 stored procedures into Oracle stored procedures? A chart contrasting corresponding features from each environment with each other - would be helpful. ...

Code generators vs. ORMs vs. Stored Procedures

In what domains do each of these software architectures shine or fail? Which key requirements would prompt you to choose one over the other? Please assume that you have developers available who can do good object oriented code as well as good database development. Also, please avoid holy wars :) all three technologies have pros and co...

how can you parse an excel (.xls) file stored in a varbinary in MS SQL 2005?

problem how to best parse/access/extract "excel file" data stored as binary data in an SQL 2005 field? (so all the data can ultimately be stored in other fields of other tables.) background basically, our customer is requiring a large volume of verbose data from their users. unfortunately, our customer cannot require any kind of db e...

Granting access to hundreds of SPs??

In Sql Server 2000/2005, I have a few NT user groups that need to be granted access to hundreds of stored procedures. Is there a nice easy way to do that? ...

Stored procedures or OR mappers?

Which is better? Or use and OR mapper with SP's? If you have a system with SP's already, is an OR mapper worth it? ...

PHP/mySQL - regular recalcuation of benchmark values as new users submit their data

I am confronted with a new kind of problem which I haven't encountered yet in my very young programming "career" and would like to know your opinion about how to tackle it best. The situation A research application (php/mysql) gathers stress related health data from users. User gets a an analyses after filling in the questionnaire. Valu...

Stored procedures a no-go in the php/mysql world?

I'm quoting part of an answer which I received for another question of mine: In the PHP/MySQL world I would say stored procedures are no-go I would like to know: Is that so? Why? Why not? [edit]I mean this as a general question without a specific need in mind[/edit] ...

Reuse of SQL stored procedures across applications

I'm curious about people's approaches to using stored procedures in a database that is accessed by many applications. Specifically, do you tend to keep different sets of stored procedures for each application, do you try to use a shared set, or do you do a mix? On the one hand, reuse of SPs allows for fewer changes when there is a model...

How can I quickly identify most recently modified stored procedures in SQL Server

I Need to manually migrate modified stored procedures from a DEV SQL Server 2005 database instance to a TEST instance. Except for the changes I'm migrating, the databases have the same schemas. How can I quickly identify which stored procedures have been modified in the DEV database for migration to the TEST instance? I assume I can w...

I traced a Stored Procedure as shown in the SQL Server 2005 Profiler. It's not found but works. Why?

This is pretty weird. I have my Profiler open and it obviously shows that a stored procedure is called. I open the database and the SP list, but the SP doesn't exist. However, there's another SP whose name is the same except it has a prefix 'x' Is SQL Server 2005 mapping the SP name to a different one for security purposes? EDIT: I fo...

Inserting a string of form "GUID1, GUID2, GUID3 ..." into an IN statement in TSQL

Hi, I've got a stored procedure in my database, that looks like this ALTER PROCEDURE [dbo].[GetCountingAnalysisResults] @RespondentFilters varchar AS BEGIN @RespondentFilters = '''8ec94bed-fed6-4627-8d45-21619331d82a, 114c61f2-8935-4755-b4e9-4a598a51cc7f''' DECLARE @SQL nvarchar(600) SET @SQL = 'SELECT * FROM Answer ...

MySQL Trigger & Stored Procedure Replication

Ok,I'm running a setup with a single master and a number of slaves. All writes go through the master and are replicated down to the slaves which are used strictly for reads. Now I have a stored procedure (not function) which is called by a trigger on an insert. According to the MySQL docs, for replication triggers log the call to the t...

Properly scoped transactions in Stored Procs

Suppose I have a stored procedure that manages its own transaction CREATE PROCEDURE theProc AS BEGIN BEGIN TRANSACTION -- do some stuff IF @ThereIsAProblem ROLLBACK TRANSACTION ELSE COMMIT TRANSACTION END If I call this proc from an existing transaction, the proc can ROLLBACK the external transaction. BEGIN TRANSACTI...