SQL Server
Select * into TargettableName from sourceTableName
Oracle
Create table targetTableName as Select *From sourceTableName
Wednesday, September 2, 2009
Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
I am an Ex-Sailor from Indian Navy who possesses rich experience in Microsoft SQL Server. I would take this opportunity to pay tribute to all those who serve their country with pride, always keeping “Service before Self”.
About Me
- Madhu K Nair
- I belong to a small village called Cherumundasseri in Pallakkad District of Kerala,India the “Gods Own Country”. I am proud for being an Ex-Sailor from prestigious service of Indian Navy. I owe to Navy for giving me a world class training and a platform to apply my knowledge.
Blog Archive
-
▼
2009
(35)
-
▼
September
(7)
- FAQ: What is optimizer in SQL Server?
- FAQ : What is Optimizing SQL statement .
- FAQ : What is the equivalent of SELECT * INTO of ...
- FAQ : What is Packages in Oracle and its equivalen...
- FAQ : How to declare a variable in SQL Server (T-...
- FAQ : How to declare a variable in SQL Server (T-S...
- FAQ : How to find Product version in SQL Server a...
-
▼
September
(7)
Labels
- Advantage of Disadvantage of Table Partitioning (1)
- ALTER Database (1)
- Data import (1)
- Excel 2007 (1)
- FAQ (37)
- Guidelines for table partitioning (2)
- Horizontal Partition (1)
- How to create files from images stored in database (1)
- openrowset (1)
- Table Partition (6)
- Vertical Partition (1)
- WITH NOWAIT (1)
- WITH ROLLBACK IMMEDIATE (1)
Posts
No comments:
Post a Comment