Tag Info

New answers tagged


Lets say that the media tables has 1K rows and the emails one has 100K rows. Then this will insert into the emails_media_xref all possible combinations, 1K x 100K = 100M, that is a hundred million rows. Warning, this may take some time: INSERT INTO emails_media_xref (emails_id, media_id) SELECT emails.id, media.id FROM emails CROSS JOIN ...


I have create following Procedure which goes thru all SP and Views in particular DB (can be extend to Functions, ...) and store each code script one by one into TXT files. Tested ON MS SQL 2008 R2 and 2014 First part Inserting all scripts of SP and Views into Temp table. Then later using BCP utility. If you wish you can can use for export SSIS package and ...

Top 50 recent answers are included