skip to main | skip to sidebar

Sql Queries in Oracle and SQL Server

SQLQueriesCollection is blog for all sql queries in SqlServer at one place.SQL,SQL Query,SQL Queries,SQL Query Code,SQL Query Example,SQL Query Syntax,Basic Sql Queries,Query,SQL Examples,SQL Basic Queries,Structured Query Language,sql oracle queries,oracle sql queries,sql queries in oracle,sql-oracle,oracle sql.oracle basics,sql basics,oracle sql examples,sql orqcle examples

Showing posts with label sql query to copy both structure and data of one table into another table in sqlserver. Show all posts
Showing posts with label sql query to copy both structure and data of one table into another table in sqlserver. Show all posts

SQL Query to Copy Structure and Data of One table To Other in SQLServer

How to copy structure and data of one table into another table?

Syntax: Select * into Newtable from Oldtable

Ex: select * into emp1 from emp

SQL Query to copy only structure of one table to other table in SqlServer
SQL Query to get structure of table in SqlServer

Movie Songs Lyrics
Software Testing-QTP Scripts,Testing Faqs
Posted by sqlqueries 0 comments
Labels: data and structure of one table into another in sqlserver, sql query to copy both structure and data of one table into another table in sqlserver, sqlserver queries examples
Older Posts Home
Subscribe to: Comments (Atom)

Recent Posts

Loading...

  • Movies Songs
  • BeautifulPictures
  • Sql Server Faqs
  • Software Testing
  • CheckVocabulary

Enter your email address:

Delivered by FeedBurner

Blog Archive

  • ▼  2013 (1)
    • ▼  February (1)
      • Sql Queries:How to convert number into words in or...
  • ►  2012 (8)
    • ►  November (8)
  • ►  2009 (10)
    • ►  June (1)
    • ►  May (1)
    • ►  April (4)
    • ►  February (2)
    • ►  January (2)
  • ►  2008 (20)
    • ►  December (4)
    • ►  November (1)
    • ►  April (2)
    • ►  March (8)
    • ►  January (5)