Back to Browse

Insert multi line Text/ String into SQL Table

2.3K views
Sep 26, 2021
12:59

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