Browse by Tags

All Tags » insert (RSS)

SQL Nugget - script content of a table as INSERT statements by MartinIsti

I have wrestled a couple of times what was easy when I used TOAD but became painful with SQL Server. For example you have a control table that is manually edited most of the times in DEV. When you want to move it to TEST you can transfer the whole table...
Filed under: , , ,

INSERT values into IDENTITY columns by MartinIsti

Yesterday I had to recreate a table because it has different a column order in the DEV and in the TEST environment. Since it was too large to drag-and-drop column on the SSMS table design screen I had to use a very simple trick: script the table in SSMS...
Powered by Community Server (Commercial Edition), by Telligent Systems