ASP Materials
Pages
Labels
Ajax
ASP.NET
Bootstrap
C Sharp
C Tips
GridView
Interview
Javascript
JQuery
Linq
MVC
Sql
WCF
Thursday, 29 September 2016
How to take a backUp of single table in SQL Server 2008R2?
Select
*
into
new_tabel_Name
from
tablename
new_table_Name
:- new table in which you want to store data(No need to create a table. It automatically create when you run the query)
tablename
:- Existing table from which you want to take a back up
No comments:
Post a Comment
Note: only a member of this blog may post a comment.
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Note: only a member of this blog may post a comment.