SQL Procedure Interview Questions

Video talks about
SQL Procedure Interview Questions
SQL Interview Questions
SQL Interview Questions and answers
Top SQL Interview Questions
SQL Interview call
SQL FAQ's
sql questions
sql answers,
top sql faq
sql training videos
sql stored procedure
stored procedure in sql server
advantages of using stored procedure
sql procedure questions
differences between Stored Procedure and Functions in SQL
What are stored procedures-Advantages of Stored procedures in sql
sql tutorial
SQL Server Interview Questions and Answers: For All Database Developers and Developers Administrators
sql interview questions for experienced
a. What is stored procedure??
b. Difference between procedure and functions..
c. Can you please write sample procedure with out Parameter..
d. Can I call one procedure in another procedure..
Procedure:
a. Block of statements
b. Select and DML statements.
c. Insert,Update and Delete
d. Can contain input and output parameters
e. Call functions in the procedure
Function:
a. Block of statements
b. Select statements only.
c. Does not support Insert,Update and Delete
d. Should return output
e. Can not call procedures in functions
Stored Procedure:
• Block of statements
• Precompiled code and stored in the data base.
• Increase the readability
• Allows faster execution
• Reduce the network traffic..
• Provides better security..
• Contains input and output parameters..

[@suribhandari1985]

I have read that we can update/Delete base table using In line table valued function... Could please share some examples please

[@pethilrajramachandran8095]

Can you write example for call one procedure to another procedure an d how to update multiple rows and columns in single query?

[@pethilrajramachandran8095]

Write the example using bulk collect and insert update delete statement ? This questions asked to me one of the recruiter

[@sarithadasari4208]

where we call cursors in functions or in procedure?How?

[@AIBot354]

We can perform Dml Operation in function

[@priyankaadhikari4490]

thanks for the video. can you please explain how to call stored procedure inside another stored procedure.

[@Training2SQLMSBI]

Thanks for your feedback.
Pls call using " EXEC ProcedureName"

[@chetanjyotirout3572]

Hello Sir, Can I have some more stored procedure interview questions example?

[@Training2SQLMSBI]

Sure .. will try soon.

[@Naveen_Kumar_Garikipati]

How to change automatically table name in from clause depends on input variable?

[@saurabhSql]

@naveen kumar Garikripati : you can use dynamic query to make From or Where clause dynamic base on input parameter

[@nasrinbanu7113]

Hi please send real time scenario questions in ssis and ssrs

[@Training2SQLMSBI]

Sure .. Will cover in the coming videos..

[@venkatasatishpasumarthi8185]

hello sir we can also perform dml operations in functions using AUTONOMOUS_TRANSACTION Pragma

[@rajisree9802]

hii sir i had a question.... we have 2 tables customer table and phonenumbers table we have to write procedure for the customers who are not having the phone number this is 1st qsn
customers who are not having the phone number this is output
2nd question In the same customer table customers are from 3 Different cities we want output like from Each City 10 customers will come
please answer for this sir

[@AK-rw8zq]

Please check this once if you face any problem let me know..
1. Create proc Deptgrp
As
(
Begin
select column1,column2 from tblCust
lefft join tblPhonenum
On tblcust.ID = tblphonenumid.numId
where DepartmentId is null;
End
)
2. create proc citycount
as
(
begin
SELECT DepartmentId,COUNT(Customers) FROM tblCust
GROUP BY DEPARTMENTID
end
)

[@Kriishna47]

assssssssssssssssssssssss could be pronounced as 'as'

[@srinivasc4157]

How to write stored function in stored procefures

[@Training2SQLMSBI]

Its very easy and straight forward .. will cover soon if required.