Click here to Skip to main content
15,867,330 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I want to understand Normalization in depth , I have googled about it but i got to know about it in a very basic level. I want to insert/update/delete data in a table using a Store Procedure(UPSERT/MERGE) rather than the syntax used to insert data into the Table directly.

What I have tried:

I tried creating Tables with these parameters (EmpID,EmpName,Gender,Salary,AnnualSalary,DepatName,DeptHead,DeptLocation) and further divided into emp table and dept tables and trying to create a Upsert Store procedure and i am struct at creating a UPSERT Store procedure.
Posted
Updated 7-Aug-16 21:42pm
Comments
Beginner Luck 7-Aug-16 22:45pm    
not every time need Normalize to the max. it will slow done query. read when is needed and no needed most important

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900