[null, null, {"document_url": "http://myspeakonbi.blogspot.com/2011/12/", "unformatted_src": "http://4.bp.blogspot.com/-acgWDam15TU/TuwLVWrkbKI/AAAAAAAABjQ/uRT0ZG91PfA/s400/pic1.png", "src": "http://4.bp.blogspot.com/-acgWDam15TU/TuwLVWrkbKI/AAAAAAAABjQ/uRT0ZG91PfA/s400/pic1.png", "formatted_filename": "pic", "rendered_width": 396, "rendered_height": 400}, null, {"document_url": "http://myspeakonbi.blogspot.com/2011/12/", "unformatted_src": "http://2.bp.blogspot.com/-tz7kIut84s4/TuwLddJqNbI/AAAAAAAABjc/t0d2zEWTlLw/s400/Pic2.png", "src": "http://2.bp.blogspot.com/-tz7kIut84s4/TuwLddJqNbI/AAAAAAAABjc/t0d2zEWTlLw/s400/Pic2.png", "formatted_filename": "Pic", "rendered_width": 400, "rendered_height": 168}, null, {"document_url": "http://myspeakonbi.blogspot.com/2011/12/", "unformatted_src": "http://4.bp.blogspot.com/-uHUupIlOi-M/TuwLk8nur5I/AAAAAAAABjo/5_vOlTCzE7M/s400/pic3.png", "src": "http://4.bp.blogspot.com/-uHUupIlOi-M/TuwLk8nur5I/AAAAAAAABjo/5_vOlTCzE7M/s400/pic3.png", "formatted_filename": "pic", "rendered_width": 400, "rendered_height": 225}, null, null, {"document_url": "http://myspeakonbi.blogspot.com/2011/12/", "unformatted_src": "//1.bp.blogspot.com/-0YJAz4wKpEg/TgL3d9oVn-I/AAAAAAAABC4/uPOKGt9tlxw/s80/DSCN0795.JPG", "src": "http://1.bp.blogspot.com/-0YJAz4wKpEg/TgL3d9oVn-I/AAAAAAAABC4/uPOKGt9tlxw/s80/DSCN0795.JPG", "formatted_filename": "DSCN", "alt_text": "My photo", "rendered_width": 80, "rendered_height": 74}, null, {"document_url": "http://myspeakonbi.blogspot.com/2011/12/", "unformatted_src": "http://1.bp.blogspot.com/-Mmjugu33DoM/TmIbG6ihw2I/AAAAAAAABF8/Kil83fv0f9U/s250/microsoft-community-contributor-award.png", "src": "http://1.bp.blogspot.com/-Mmjugu33DoM/TmIbG6ihw2I/AAAAAAAABF8/Kil83fv0f9U/s250/microsoft-community-contributor-award.png", "formatted_filename": "microsoft community contributor award", "rendered_width": 140, "rendered_height": 136}, {"document_url": "http://myspeakonbi.blogspot.com/2011/12/", "unformatted_src": "http://2.bp.blogspot.com/-NwOuOfWIBf8/TgA2TGDfcjI/AAAAAAAABCA/ceWioYshNJA/s1600/Allinone.png", "src": "http://2.bp.blogspot.com/-NwOuOfWIBf8/TgA2TGDfcjI/AAAAAAAABCA/ceWioYshNJA/s1600/Allinone.png", "formatted_filename": "Allinone", "rendered_width": 185, "rendered_height": 197}, {"document_url": "http://myspeakonbi.blogspot.com/2011/12/", "unformatted_src": "http://1.bp.blogspot.com/-GNzdvoWGvsU/Tds0juW5VMI/AAAAAAAABAk/nRxLOmhj7BA/s150/Sales%252520Specialist.png", "src": "http://1.bp.blogspot.com/-GNzdvoWGvsU/Tds0juW5VMI/AAAAAAAABAk/nRxLOmhj7BA/s150/Sales%252520Specialist.png", "formatted_filename": "Sales Specialist", "rendered_width": 150, "rendered_height": 69}, null, null, null]

How to Script Data from a Table ..?

Most of the time we need to script data of a table which holds configuration Values or Date Dimension Tables for later use....obvious that its a waste of space to take a entire database backup !....SQL Server provides a functionality to export table data (Insert Values script) to a .SQL file...
Here is a Step by Step Guide to do the same..

Step 1 : Go to Tasks -->Generate Scripts Step 2 : Click on Advanced -->Types of Data to Script-->Select Data only Save the file in the required Location and open it in SSMS and you can view the insert scripts !!! Will be back with more posts !! bye bye for now :) ...
Posted by MJ at 7:10 PM 1 comments Bangalore, Karnataka, India
I Work as Technology Consultant and have around 3 Yrs of experience in IT field and Primary work area being Microsoft BI which includes SSIS,SSAS,MDX,SSRS and Sharepoint. Have Worked with Various Clients and have worked in India and Abroad.. I am a Microsoft Certified Technology Specialist,Microsoft Certified IT Professional.
