ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
How to Debug a Stored Procedure?
 Question Submitted By :: Durga Prasad
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to Debug a Stored Procedure?
Answer
# 1		 
By Command 
Execute Procedurename parameter1 ,parameter2,......
u can use 
exec Procedurename parameter1 ,parameter2,......
 
Is This Answer Correct ?    0 Yes 7 No
Bhagyashri Jain
 
  Re: How to Debug a Stored Procedure?
Answer
# 2		 
Using PRINT command in stored procedure.
use print to check if the parameter values are fine.
When the stored procedure is executed then print will show 
the output of those parameters/variables.
 
Is This Answer Correct ?    10 Yes 2 No
Swetha
 
 
 
  Re: How to Debug a Stored Procedure?
Answer
# 3		 
Steps for debugging stored procedure is given below
1.Open the object browser 
2.right click the procedure that u want to debug
3.from the popup menu select debug option
4.from the displayed window ,give the values for input 
parameters 
5.click the button debug
 
Is This Answer Correct ?    9 Yes 3 No
Ris
 
  Re: How to Debug a Stored Procedure?
Answer
# 4		 
Steps for debugging stored procedure is given below
1.Open the Microsoft visual Studio
2.Select Server Explorer
3.Add Server 
4.Select Database Where Procedure is located
5.Select Procedure for debug
6.Right click and select Step into stored procedure
7.Pass  Parameter to that procedure
8.Then Do debug.
 
Is This Answer Correct ?    3 Yes 1 No
Sivakumar
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
Wht is Stuff in sql ser  1
What are the new features in SQL Server 2005? Emphasis2
How to write query to Delete the records in child table and corresponding records in parent table Semantic-Space8
How do SQL server 2000 and XML linked?  2
How to find the date and time of last updated table?  2
wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform Idea1
Is trigger fired implicitely?  2
What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename> 247Customer2
What is indexed views? plz explain with example?  1
What do u mean by orphan users, how will u list them in the DB IBM2
1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks  3
What is a job?  3
How can you get @@error and @@rowcount at the same time?  5
What is database normalization? Digicel5
How do we get current date in SQL Server 2000, Oracle, MS Access?  11
How to find the date and time of last updated table?  3
What are Sql Reporting Services and analysis services? Can u Explain  1
What is the difference between constraints and triggers? Wipro6
from the table display the 2nd highest salary? and also the least 2nd salay?  6
Which system tables contain information on privileges granted and privileges obtained  1
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com