Question : Currently I have a procedure that performs 4 operations in the Transaction: Update record in table A Update […]
Tag: stored-procedures
SQL Server Replication – Can destination db have stored procedures that source db lacks?
Question : I’m a developer with a very basic question, but I can’t see anything conclusive on MSDN. I’m developing […]
How do I identify the program that called a stored procedure?
Question : As part of an application database design spec, we’ve been asked to block execution of a set of […]
Create stored procedure with dynamic number of columns + column names
Question : I am relatively new to postgresql (I have version 12), and am having some trouble creating my first […]
PostgreSQL: Is it possible to get a different function result type (i.e. TABLE) in stored function based on input?
Question : The question is as follow, I wanted to get some flexibility in my example function, so based on […]
Procedure to read from crontab like table and populate another one periodically
Question : Postgres 9.3 Debian 7 I’m working on a mobile game project (poker like) where an admin user can […]
Help to decrese query time in huge table of 100M+ rows on Ms-SQL Server
Question : I am trying to get data using offset limit concept as follows: CREATE PROCEDURE BaseUserIndex @Offset int, @Limit […]
Group stored procedures in oracle [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
calling scalar function to assign value to local variable
Question : In a SQL Server stored procedure, if we declare a local variable and assign the value by calling […]
With the advent of integrated source control, do stored procedure changes still need comments?
Question : Back in the old days, my team had a policy that any stored procedure modification required comments in […]