How to create sql script manually to insert data ?

K Pathak

7y872SQL

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?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vivek Kumar7y ago
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/
0
Gajendra Jangid7y ago
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;
0