View Single Post
  #2 (permalink)  
Old December 21st, 2006, 02:26 AM
maulik77 maulik77 is offline
Registered User
 
Join Date: Nov 2004
Location: Ahmedabad, Gujrat, India.
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to maulik77 Send a message via Yahoo to maulik77
Default

Use following statement if desire only structure

SELECT * INTO #temp from tbl_BannerManager where 1<>1

and following for coplete structure with al the data

SELECT * INTO #temp from tbl_BannerManager

Maulik Pandya