technoblab

Monday, December 14, 2009

Creating a table from your view

     In one of my projects had to create a table and populate it with my view.  You can do this as :

SELECT *
INTO dbo.tbl_tblname
FROM dbo.vw_viewname


Posted by Madhu at 12:30 AM No comments:
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Search This Blog

Popular Posts

  • render rdlc as pdf
  • Customize the reportviewer toolbar
  • Avoid empty reports in a reporting services data driven subscription
  • Adding Images to your report
  • Database fields in Report header / footer

Archive

  • ►  2007 (5)
    • ►  August (1)
    • ►  September (2)
    • ►  October (2)
  • ►  2008 (4)
    • ►  February (1)
    • ►  March (1)
    • ►  September (1)
    • ►  October (1)
  • ▼  2009 (5)
    • ►  April (1)
    • ►  May (1)
    • ►  June (1)
    • ►  October (1)
    • ▼  December (1)
      • Creating a table from your view
  • ►  2012 (3)
    • ►  February (2)
    • ►  March (1)
  • ►  2014 (2)
    • ►  January (1)
    • ►  February (1)

About Me

Madhu
View my complete profile
Simple theme. Powered by Blogger.