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
Dyn365GP24 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Delete an Environment
Dyn365GP23 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Delete a Company
Dyn365GP22 April 2024Upcoming Microsoft Dynamics 365 Business Central Knowledge Hub Webinars (May-Jul 2024) from MADIC dynamics
Dyn365GP22 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Rename an Environment
