Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
A stored procedure must contains at least two parts:
(1) stored procedure name
(2) its body
on 1/4/2012 | Category:
Sql Server Interview questions
| Views: 4176 |
Select from following answers:
True, here's an example to depict the fact:-
Create Procedure usp_delete_customer
delete from tbl_customer
where cust_id = @cust_id
(1) usp_delete_customer is the name of the stored procedure.
(2) @cust_id int is the parameter which is optional
(3) Inside the BEGIN and END tag is the body of the procedure
Show Correct Answer
Many Interviews |
< Previous :
Is it good to load jquery from CDN(Content deliver ...
Next > :
A stored procedure can be called from a trigger, a ...
Comments or Responses
on: 1/5/2012 |
To create Stored Procedure Parameter List is not mandatory its an optional
on: 1/6/2012 |
yes, parameter list is optinal to SP
on: 1/6/2012 |
Thank you @Mkiran and @Mvbedarkar for giving me suggestions. I will revise my statement asap.
on: 1/10/2012 |
ya its true
Login to post response
More Interview Questions by Akiii
A stored procedure can be called from a trigger, another stored proced ...
Is it good to store connection strings in a separate text file for you ...
What is "Automatic activation" in WCF ?
What is the difference between the below two statements:- (1) var myn ...
Overloading is Static Polymorphism and Overriding is Dynamic Polymorph ...
What is the former name of Windows Communication Foundation (or WCF) ?
Are all the below border styles valid :- border-style: inset; bord ...
Latest Interview Questions
Which of the following are known to be the attributes of an Object ?
Generally Reference types are inherited from which class?
What is UDDI ?
Different between Response.TransmitFile and Response.WriteFile ?
What is the difference between Pre-Render and Render events in ASP pag ...
What is Application State?
What is Cross-Page Posting?
What is the difference between Two Tier & Three tier Architecture ...