Stored Procedures||Write Stored Procedure for insertions in multiple tables

preview_player
Показать описание
Creating Stored Procedure for the insertion of data in multiple tables in SQL
Employee:
Emp_ID - PK
Name - Input
Department - Input

Address:
Address_ID - PK
Address_Loc - Input
Emp_ID - FK

[EmpContact]:
EmpContact_ID - PK
Email - Input
Address_ID - FK
Рекомендации по теме
Комментарии
Автор

I am trying to insert values in my tables and its giving me this error message:
ERROR: null value in column "i" violates not-null constraint DETAIL: Failing row contains (null, bar).

sandyiwadeakhia
Автор

sir insert button duba lo us se theek ho ga cursor apka

Abhinav-nmir