--First step is create Table empmaster with column empid,eno,ename etc create table empmaster ( empid int primary key identity, eno int, ename varchar ) -- Now create Table empdetails with column empid,sal,dept, hiredate etc create table empdetails ( empid int , sal money, dept varchar, hiredate datetime ) -- Now create Stored Procedure empvalues to insert records in tables create proc empvalues @eno int, @ename varchar(20), @sal money, @dept varchar(20), @hiredate datetime as begin insert into empmaster . INSERT INTO empdetails. end
ERP Project Management,Asp.net,PL SQL Tips for error resolution,Research,Software Errors and solution,SQL 2014,2012,2008,Procedural language,SP,Power BI,excel macro ,Musical notations,Business software,Degree, diploma related informations.