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
Download
0 formats
No download links available.
Insert multi line Text/ String into SQL Table | NatokHD