This post is part of the series on SQL Snippets.
I occasionally need to make a backup of a SQL table and all rows within; while you can create a table and insert the content, this is the long way of doing. Instead you can use SELECT INTO
to both create a table with the correct columns and also to copy the data.
In the below example I am creating a new table suffixed with the date; the first
Continue Reading azurecurve’s Article on their blog
SQL Snippets: SELECT INTO
This post is part of the series on SQL Snippets. I occasionally need to make a backup of a SQL table and all rows within; while you can create a table and insert the content, this is the long way …
Blog Syndicated with azurecurve’s Permission
More About This Author
Array
- Dyn365GP3 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: See Improved Usability for Warehouse and Inventory
- Dyn365GP3 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Automate the Reminders Process in Collections
- Dyn365GP2 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Allow Lines with Amounts of Zero on Recurring General Journals
- Dyn365GP2 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Specify Dimensions on Posted Entries Applications With Realized Gains or Losses