A subroutine available to applications accessing a relational database system.
I need to convert int datafield to nvarchar with leading zeros example: 1 convert to '001' 867 convert to '000867', …
sql-server stored-proceduresHow can one call a stored procedure for each row in a table, where the columns of a row are …
sql sql-server stored-procedures cursorI'm looking for a good explanation on how to test an Oracle stored procedure in SQL Developer or Embarcardero Rapid …
oracle stored-procedures plsqldeveloper ref-cursor rapidsqlI have a dynamic SQL statement I've created in a stored procedure. I need to iterate over the results using …
tsql stored-procedures dynamic-sql database-cursorI'm trying to pass an array of (varchar) data into an Oracle procedure. The Oracle procedure would be either called …
oracle stored-procedures plsqlA query runs fast: DECLARE @SessionGUID uniqueidentifier SET @SessionGUID = 'BCBA333C-B6A1-4155-9833-C495F22EA908' SELECT * FROM …
sql-server performance stored-proceduresI have to write a deployment script which will work if a stored procedure exists or does not exist. i.…
sql sql-server-2005 stored-proceduresI am trying to get 25 random samples of 15,000 IDs from a table. Instead of manually pressing run every time, I'm …
postgresql stored-procedures for-loop random plpgsqlI keep getting a max recursion error with this query. At first I thought it was because a null was …
sql stored-procedures common-table-expressionI am confused about a few points: What is the difference between a stored procedure and a view? When should …
sql sql-server-2005 stored-procedures views