How to create stored procedures with parameters in ms sql server?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

where the connection string store in the database

0 Answers   HCL, Wipro,


Can a table have 2 primary keys?

0 Answers  


What methods do you follow to protect from sql injection attack?

0 Answers  


How to find out name of all employees who has salary less than 200 Rs.?

8 Answers  


What is difference between view and materialized view?

0 Answers  






Tell me when is the update_statistics command used?

0 Answers  


mention different types of relationships in the dbms?

0 Answers  


What are the steps you will take to improve performance of a poor performing query?

1 Answers  


What authentication modes does sql server support?

0 Answers  


How to get a list all databases on the sql server?

0 Answers  


What objects does the fn_my_permissions function reports on? : sql server security

0 Answers  


2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,


Categories