问题描述
我想深入了解规范化,我已经用谷歌搜索了它,但我在一个非常基础的层面上了解它。我想使用存储过程(UPSERT / MERGE)在表中插入/更新/删除数据,而不是直接将数据插入表中的语法。
我尝试了什么:
我尝试使用这些参数创建表格(EmpID,EmpName,Gender,Salary,AnnualSalary,DepatName,DeptHead, DeptLocation)并进一步分为emp表和dept表,并尝试创建Upsert Store过程,我是创建UPSERT Store过程的结构。
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.
这篇关于如何应用1NF,2NF,3NF的相同示例,如何理解SQL中的规范化?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!