Insert multi line Text/ String into SQL Table
Many of us have encountered this problem where we are unable to insert a multiple line text or string into our database. In this video Data saber teaches you to overcome this issue.
Steps:
1. Select your database
2. Create table in your database
3. Use select query to make temporary table
4. Insert data into main table
5. Use MS Word to create your multi- line text/string
6. Replace your Text in the SQL query
7. Change #temp table name as we cannot create two table with same name.
8. Insert it into the main table
9. End
And this is how you insert your multi-line text into your database. This is a very helpful technique which can be used in reporting.
Keep loving keep supporting. Thanks
On this page of the site you can watch the video online Insert multi line Text/ String into SQL Table with a duration of hours minute second in good quality, which was uploaded by the user Data Sabre 25 September 2021, share the link with friends and acquaintances, this video has already been watched 2,324 times on youtube and it was liked by 13 viewers. Enjoy your viewing!
