How to create sql script manually to insert data ?

Question

How to create the sql script manually to insert data into database with foriegn keys where the script takes data from excel file and insert them into database at one attempt Can i get any similar example? Where can i get the tutorial to create the sql scripts?

Vivek Kumar · Answer

Hi, Have a look to below links for your reference. https://dba.stackexchange.com/questions/132119/export-import-data-from-excel-into-a-table-with-queries https://docs.microsoft.com/en-us/sql/relational-databases/import-export/import-data-from-excel-to-sql?view=sql-server-2017 https://stackoverflow.com/questions/44106848/how-to-import-xls-file-to-sql-with-a-foreign-key https://www.sqlshack.com/import-data-excel-file-sql-server-database/

Gajendra Jangid · Answer

Hello K.P. using following code CREATE TABLE ItemMaster( [Id] INT NOT NULL PRIMARY KEY IdENTITY, [ Name ] NVARCHAR(200) NOT NULL ); CREATE TABLE SalesOrder( [Id] INT NOT NULL PRIMARY KEY IdENTITY, [ItemId] INT NOT NULL , [OrderDate] DATE NOT NULL , CONSTRAINT [FK_ItemMaster_Orders] FOREIGN KEY ([ItemId]) REFERENCES [ItemMaster]([Id]) ); INSERT ItemMaster( Name ) VALUES ( 'PEN' ),( 'PAPER' ),( 'BOOK' ); INSERT SalesOrder(ItemId, OrderDate) SELECT Id, Id+GETDATE() FROM ItemMaster; SELECT * FROM ItemMaster JOIN SalesOrder ON SalesOrder.ItemId = ItemMaster.Id DROP TABLE SalesOrder; DROP TABLE ItemMaster;