| CARVIEW |
Select Language
HTTP/2 200
date: Wed, 23 Jul 2025 13:26:46 GMT
content-type: text/html; charset=utf-8
cf-ray: 963b82e6dd42f424-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=5a53c901-ed5d-4687-a387-7c8a73cf1e1d; expires=Thu, 23 Jul 2026 13:26:45 GMT; domain=.stackexchange.com; path=/; secure; httponly
strict-transport-security: max-age=31536000; includeSubDomains
vary: Accept-Encoding
content-security-policy: upgrade-insecure-requests; frame-ancestors 'self' https://stackexchange.com
x-frame-options: SAMEORIGIN
x-request-guid: 79d5ae53-e23c-4fef-9865-b517d2a3bcf3
x-worker-origin-response-time: 554000000
x-dns-prefetch-control: off
set-cookie: prov=5a53c901-ed5d-4687-a387-7c8a73cf1e1d; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=vMwY.Ias4FO6NZj.Z8vPsh8zRAtwro00dxieS7hdZJ0-1753277206-1.0.1.1-EknJBFKY3N.xKQ53awocoq5tlunBibVTI20u9wuBzj8j.pO7sf.30nM1U5OsIE.E3nIBLh4J0RG6sqDwuaUT7YoxJdkKpvjkGbFnzOJ.y7E; path=/; expires=Wed, 23-Jul-25 13:56:46 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=dT4jiWFBc2X00N1bDlNEkCD7qFIa7QhtcQnAJmW7muI-1753277206140-0.0.1.1-604800000; path=/; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'stored-procedures' Questions - Database Administrators Stack Exchange
Skip to main content
Stack Exchange Network
Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about TeamsQuestions tagged [stored-procedures]
Callable code installed on a database manager, exposing an API through which it can be invoked. Normally written in the native query language, some DBMS platforms support other languages as well.
1,691 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
1
answer
52
views
Could not find stored procedure 'sp_BlitzLock' [closed]
I'm running into an issue while trying to execute the stored procedure sp_BlitzLock in SQL Server 2022 Developer Edition. Here's the exact error message I'm getting:
Msg 2812, Level 16, State 62, Line ...
2
votes
2
answers
103
views
sp_describe_first_result_set with json columns
I'm working on an analyzer that accepts a SQL Server query and returns information about all columns in the first result set - until for clause is used, this is pretty straightforward with ...
2
votes
1
answer
110
views
On a linked server I can execute a stored procedure A but Can Not execute stored procedure B
On a linked server I can execute a stored procedure A but Can Not execute stored procedure B
I have a db server DBServer and a linked server LinkedServer. From the DBServer I can execute successfully ...
5
votes
1
answer
221
views
OUTPUT as default parameter value for stored procedure?
I've encountered peculiar behaviour by SQL Server, and I wonder why does it behave like this.
Consider following CREATE PROCEDURE script:
CREATE PROCEDURE dbo.myProc
@parameter INT = OUTPUT
AS
...
3
votes
1
answer
65
views
MYSQL and random performance of store procedure
I run this SP at night, when there’s almost no activity. The SP performs an accumulative calculation of machine usage from a laundromat—an artisanal BI query. It writes the result to a table.
On most ...
3
votes
2
answers
515
views
Deploy encrypted stored procedures that cannot be decrypted
There are many ways you can see an encrypted procedure.
Example of an encrypted procedure in SSMS:
There is this very good question: How to view an encrypted view or stored procedure where you can ...
0
votes
0
answers
35
views
SQL Server Agent job to verify logshipping on multiple databases
I'm trying to come up with a SQL script that will verify log shipping on about 100 databases in an instance.
I need to be alerted if log shipping is failing, but I do not want 100 plus emails coming ...
3
votes
3
answers
228
views
Stored procedure to get max startDate with optional AgentId
I have this stored procedure that I want the max startDate base on AgentId or without the AgentId. The way I am doing this is using a if else and wanted to see if there was a better way to do this?
...
6
votes
1
answer
790
views
When creating stored procedure, are the comments before the definition always preserved?
When I wrote some comments before the CREATE PROCEDURE command, those comments seem to be preserved as part of procedure definition.
For example, when I create procedure like this
/*Comment header*/
...
- sql-server
- stored-procedures
- comments
- 1,851
0
votes
1
answer
82
views
Why can't I create a new stored procedure?
I need to copy existing stored procedures from one SQL-Server database to another one.
In the first SQL-Server database (the source), when clicking on "Stored Procedures", this is what I see:...
0
votes
1
answer
69
views
How to tune the complex Oracle stored procedure?
I have an Oracle stored procedure that takes a bunch of parameters and heavily does the left outer join like this:
create or replace PROCEDURE "SOME_PROCEDURE" (
cRECORDSET OUT ...
-1
votes
1
answer
38
views
Procedure for data import from file_name parameter
I want to automate table creation and import for a large number of csv files into my database. I simply want to use a text parameter to build the file path inside the procedure.
The copy statement ...
0
votes
2
answers
76
views
Sleeping for a random amount of time in a stored procedure
A vendor application we're using utilizes multiple processes (not threads) spread across multiple computers, one for each processing core available. When asked for a batch of calculations, the ...
3
votes
1
answer
96
views
How does name resolution work with temporary stored procedures?
Say I have the following two databases
USE [master]
CREATE DATABASE Jack
GO
CREATE DATABASE Jill
GO
USE Jack
GO
CREATE TABLE JacksTable
(
Id INT
)
INSERT INTO JacksTable VALUES (1)
If I create ...
1
vote
1
answer
94
views
MySQL: using NAME_CONST internally
I'm using MySQL 8.0.32
I have some questions about an internal conversion, that I don't understand. In addition to this, sometimes this conversion is shown in SHOW FULL PROCESSLIST, as its execution ...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
sql-server × 767
mysql × 377
t-sql × 156
oracle × 115
postgresql × 115
sql-server-2008 × 96
performance × 88
sql-server-2012 × 83
trigger × 77
functions × 66
permissions × 65
sql-server-2008-r2 × 64
sql-server-2016 × 58
sql-server-2014 × 57
plsql × 56
query-performance × 51
dynamic-sql × 49
transaction × 43
sql-server-2005 × 35
parameter × 33
database-design × 32
optimization × 32
temporary-tables × 30
cursors × 29
execution-plan × 29
more related tags
Hot Network Questions
- Error when sending an email with attached PDF using Google Script
- Manga/manhwa where protagonist is the only one summoned to a different other world
- Did Webster's Dictionary define Fascism by its relationship to corporations until 1987?
- Why is this endgame winning for Black?
- What was the source of the image of pelican in Catholic churches?
- What was the Russia-Germany 1996 "Defence pact" that Russia recently announced has been terminated?
- Not sure which test statistic to look at with regression with interaction term
- How should a typical reward curve look like while training a RL model
- Define command valid only for a specific environment in expl3
- Is a Rakshasa Immune to True Strike?
- When is XLOOKUP() faster than VLOOKUP()?
- Repository with SQLite in Python
- Why is `&self` allowed in the parameters of `&mut self` methods, but not `&mut self`?
- Axioms of quantum mechanics - intuitive explanation
- Why were two 2x6 boards installed on top of a window rough sill?
- What are these pastries pictured in the "Austria" article in the World Book Encyclopedia?
- Will I lose my seat reservation on Deutsche Bahn EC if I skip the first leg?
- Is there a way to move the cursor specifically to the beginning of the visually selected region (not just toggle like `o`)?
- How to make peaks with thick lines pointy?
- Why is the number of Marie Curie postdoctoral fellowships in mathematics significantly lower than in other subjects?
- When you view a historical event with an incorrect modern lens
- Can I mount my PC with a desktop mount underneath a particle board Ikea Karlby Walnut top?
- Is there a way to retrieve my inventory from the void in Minecraft Java Edition?
- How would a DiVicenzo machine prepare the maximally mixed state with a small number of ancilla qubits?