Skip to main content

Posts

Showing posts with the label SQL

How to write Stored Procedure to get employee details of one department or all department

Imagine there is a table called Employee. And you have interface like below then you must write query for both single department and all department option,   Then you can write stored procedure without using if conditions  as follows .