Copy structure and data of a table in SQL Server 2008

For copying structure and data both from another table in Sql Server 2008, you can execute the following sql query:

select * into newtablename from oldtablename

you don't need to create the new table before you execute the query. It will be created automatically after executing this. Refresh the object explorer and it will come automatically.

Comments

  1. AnonymousNov 18, 2008, 2:56:00 PM

    That was really a helpful one...thanx buddy.

    ReplyDelete
  2. NiqApr 19, 2011, 8:44:00 AM

    Do you know how to do with with constraints?

    ReplyDelete
  3. RandomThoughtsApr 19, 2011, 8:58:00 AM

    Did you try with import and export data tool from SQL Server 2008? You can easily do that with that tool.

    ReplyDelete

Post a Comment

Popular posts from this blog

html to Word Document Converter using Open XML SDK

By using Open XML SDK 2.0 you can generate the word document without using Interop dlls and without the requirement to install Office in your web server. I have done it successfully with the help of my colleagure Yesha Gupta and below is the code to generate the word document from the html code. GenerateWordDocument() public void generateWordDocument() { WindowsIdentity currentUserIdentity = (WindowsIdentity)User.Identity; WindowsImpersonationContext impersonationContext = currentUserIdentity.Impersonate(); try { string fileName = currentUserIdentity.Name.Replace( "\\", " _ ") + " _Report.docx "; string filePath = " ~/assets/Templates/ " + fileName; File.Copy(Server.MapPath(" ~/assets/Templates/WordDocTemplate.docx "), Server.MapPath(filePath)); DataView view = frontMatterSqlDataSource.Select(DataSourceSelectArguments.Empty) as DataView; string pageTitle = " "; using (WordprocessingDocument wordDoc = Wordprocessing
Read more

How to: Get Top n Rows of DataView in C# asp.net

DataView in asp.net doesn't have any method of returning Top n rows or it doesn't accept any row filter string such as, dataview.RowFilter = "top 100". So to server the purpose you can use the method below to get top n rows from DataView. private DataView GetTopDataViewRows(DataView dv, Int32 n) { DataTable dt = dv.Table.Clone(); for (int i = 0; i < n-1; i++) { if (i>= dv.Count) { break; } dt.ImportRow(dv[i].Row); } return new DataView(dt, dv.RowFilter, dv.Sort, dv.RowStateFilter); }
Read more