For those facing the error "[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated in table", the data set has since grown and to fix this just increase Traffic_Report_Id to NVARCHAR(255) Absolutely amazing video, another informative banger from Jie Jenn.
Nice, Worked exactly how I wanted it to work. This video has opened my eyes about dbs, mdls. This is the best tutorial I have ever watch in 2021( in 2 hours it will be 2022)
Hey JJ, thank you for your tutorial. I learned a lot from you. I am now trying to do some web scraping and insert the results into Microsoft SQL. Yet, I failed and I have no ideas how should I correct the codes. Can you give a helping hand ?
if I have a dataframe, do you think I need to convert it to a list of list in order to use your method? records object is a list that have lists as elements.
Hi thanks for your simple and awesome explanation. I have an issue with output from Sql Server using python, the output prints with paranthesis, quotes and coma as shown below: (11, 'Habeeb', 'ali', 'dfkjds', 'ldjflj', 'Your First Pet Name', 'raju', '1234') can we change the output to this: 11 Habeeb ali dfkjds ldjflj Your First Pet Name raju 1234
For those facing the error "[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated in table", the data set has since grown and to fix this just increase Traffic_Report_Id to NVARCHAR(255)
Absolutely amazing video, another informative banger from Jie Jenn.
Thank you so much for the video! Was struggling to get it to work, and this worked great!
Nice, Worked exactly how I wanted it to work. This video has opened my eyes about dbs, mdls. This is the best tutorial I have ever watch in 2021( in 2 hours it will be 2022)
Glad the video helped.
Another home run. Thanks Jie!!!!
Glad my video helped.
Very nice presentation style. Easy to follow and understand. Keep up the good work!
Glad my video helped. And thanks for the coffee!
👍Thank you for your tutorial. I have learned a lot from this video.
But I have a question. How can I use SQL raw query to execute.
Excellent video!!
Thanks!
This is amazing ! Thank you!
hey you are amazing , if i have data in excel file can i do the same?
Hey JJ, thank you for your tutorial. I learned a lot from you. I am now trying to do some web scraping and insert the results into Microsoft SQL. Yet, I failed and I have no ideas how should I correct the codes. Can you give a helping hand ?
Probably not at the moment. Too many things to catch up.
if I have a dataframe, do you think I need to convert it to a list of list in order to use your method? records object is a list that have lists as elements.
pndas already has a built-in method to convert a dataframe to a nested list. For example, df.values.tolist()
the best ever omg
can we store the insert statements in a .sql file and call them using pyodbc ?
You can open the sql file and read the sql statement first, then pass the system to pypyodoc.
Hi thanks for your simple and awesome explanation.
I have an issue with output from Sql Server using python, the output prints with paranthesis, quotes and coma as shown below:
(11, 'Habeeb', 'ali', 'dfkjds', 'ldjflj', 'Your First Pet Name', 'raju', '1234')
can we change the output to this:
11 Habeeb ali dfkjds ldjflj Your First Pet Name raju 1234
Yes, just convert it to a list, and then join it with a space in-between
how to create a table from python ?
I don't make bulk insert SQL Server with Python. How can I do it?
Use SQL?
Make a video on Pymssql
I will look into it.
How to update sql db from python
UPDATE [tbl] SET column = [value]
how to check if that data is already present
I would export the records to a temp table first in SQL Server, then write a SQL query to compare the records to insert the ones do not exist.
@@jiejenn Thank you !!