What do you used to write in the Stored procedure header ?

Stored procedure header plays a crucial role in providing the information to the developer to understand the description and history of it. I usually write: Stored procedure name Stored procedure description Created/modified date time Databases used Tables used Change request ID Change description

Read More

How many Instead Of Triggers we can create on a table?

Only one Instead of Trigger per operation(Delete/Insert/Update) is possible to create on a table. Happy Reading   

Read More

Which is Faster between UNION and UNION ALL? Why?

UNION ALL is always FASTER…!!! As we all know that, UNION and UNION ALL are the SET operators which combines/merges the multiple data sets data into a single data set. UNION eliminates the duplicates after combining the records. But UNION ALL ignores

Read More