=> What is normalization ?
Defination : Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in more than one table) and ensuring data dependencies make sense (only storing related data… Read more
Sometimes we need to generate the INSERT script in sql server. When, we need to insert bulk of data from one table to another table we can easily achieve it by USING SELECT * INTO TABLE NAME. But sometimes we have scenarios like for some Master tables, we want to… Read more
1. SQL Objects
a. Stored Procedures : a bunch of SQL statement which can be stored under one name.
- can be used for modularized programing
- Can be used for security purpose
- Can be in a compiled state so execution will be faster
- Reduces network traffic
Types of Stored… Read more