Import Superstore Data to SQL Server | How to Import Data from Excel to SQL Server

preview_player
Показать описание
datasets link:
Рекомендации по теме
Комментарии
Автор

After 20+ years of programming experience, I am learning new ways of solving set based problems. Thanks for sharing your knowledge.

Xmukherjee
Автор

Thank you so much Ankit...the dataset you attached that helped me with this as mine was not getting attached..its really good that you are helping people at that level

kumarirashmi
Автор

Doing a great job buddy..Thanks a lot for sharing your knowledge.

devenderbhandari
Автор

Hello Sir,
I used the same process, I was able to Import the xls file, but when I'm using "select order_id from returns", I'm getting Invalid column name 'order_id'. BUT, "select * from returns" giving the columns. I don't know how to perform any tasks with this table, not able to use Joins and anything related to returns table.

_-_Abhinav_-_
Автор

How to import data from main table to backup table. Suppose out of 100 records only 50 records we got on back up table and rest 50 records still in main table. How we will retrive those 50 records and Insert it in back up table?

sangam-m
Автор

Hi Ankit.. Thanks a lot for sharing such wonderful content.. Can you please tell me any of online sql complier for sql server..

mohdtoufique
Автор

in my microsoft sql management studio there is no option of sql server native client 11.0

karnavsood
welcome to shbcf.ru