A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 140866

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.

5
votes
A non-technical answer: Ask your team. If someone was able to run a stored procedure that wrecked your database, the fault does not rest with the person that ran the sp. If you're the DBA, it's yo …
answered Jun 12 '18 by James
0
votes
I would come at this from the opposite direction. select c.table_name, c.column_name, sp.name from INFORMATION_SCHEMA.columns c inner join sys.procedures sp on object_definition(sp.obje …
answered Oct 11 '19 by James
1
vote
You could handle nulls inside the stored procedure with an isnull() like this: create procedure rpt.FinanceReport @AccountYearParam int as set @AccountYearParam = isnull(@AccountYearParam, 2018 …
answered Dec 20 '17 by James