| CARVIEW |
Select Language
HTTP/2 200
date: Thu, 24 Jul 2025 14:45:01 GMT
content-type: text/html; charset=utf-8
cf-ray: 964432e95840f424-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=fd170dfc-dca9-419b-8243-63e1bf2a203e; expires=Fri, 24 Jul 2026 14:45:01 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-clacks-overhead: GNU Terry Pratchett
x-frame-options: SAMEORIGIN
x-request-guid: d52dea5c-cd5a-4ad8-8aae-3472932fa1c7
x-worker-origin-response-time: 529000000
x-dns-prefetch-control: off
set-cookie: prov=fd170dfc-dca9-419b-8243-63e1bf2a203e; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=mCNSOKepgG.iTiatSFmIMhzRND_JdnAn3BFptCg4DoE-1753368301-1.0.1.1-KcgD2Ljmrazze0Z7gPGD0wfLbp1c5rUDJ9nJYtoRvlDPLbdQzJYrITlmweKljBjHRPczJT3Kd8He7R6fOQ8X61MFO6IVpbHDu5Rv.I6kKg4; path=/; expires=Thu, 24-Jul-25 15:15:01 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=l3gTngENC3R_OuoAA_S0PPG58w3zw6vXI.dX7LPhBnY-1753368301559-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
55
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
223
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
516
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
792
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
83
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
- Business technical issues lead to unsuccessful payment being considered successful. Do I have any duty to notify?
- Why does “brew search” for “peertube” match with “freetube”? How does the search work?
- How do mechanical gyros maintain rotational speed?
- Ubuntu Server installation -- options for boot disks are grayed out
- Is it rude to make someone an academic reference without getting their permission first?
- Where did the name of Windows XP come from? Was it connected to the Cairo project?
- Heavy shelves, but not a center stud
- Mars colony book I read in the 80's. The name?
- Use color in the marginnote
- How much of a really big a ship could a nuke take out?
- How to Select and Isolate Only the Fillet Parts of a Curve in Geometry Nodes?
- Does Philosophy Need Quotes?
- Did Webster's Dictionary define Fascism by its relationship to corporations until 1987?
- Interaction with para hooks and footnotes
- How to expand an algebraic function like √R(x) into a continued fraction in Mathematica?
- Early 70s scifi novel about underground people, caste is determined by the color of your poncho, and everyone eats mouldy grain
- How to 'scale' a square list?
- Are birth control pills classified as a carcinogenic at the same level as asbestos and tobacco?
- Etymology of the word skulduggery?
- Is the surface of Mars or the Moon mostly (or relatively) homogeneous, unlike the Earth?
- counting number of integer solutions
- How do Francophones hear "ChatGPT"?
- Why is this endgame winning for Black?
- How Fill Date Series Without Formatting Using Keyboard Only