Write an SQL query if u want to select the data from one block which intern ref

Write an SQL query if u want to select the data from one
block which intern reflects in another block ?

thanx,do reply

Question Posted / anithababu1

Write an SQL query if u want to select the data from one block which intern reflects in another blo..

Answer / jerald

select * into table1 from table

Is This Answer Correct ?

3 Yes

5 No

More SQL Server Interview Questions

What is full form of XP ?

What information is maintained within the msdb database?

How to get the query of a table in sql server?

How to move database physical files in ms sql server?

What is a View ? Can we insert, Update and delete a view?

How to perfor If the table running time is taking 2hours and table is having 10 rows in it?

Using the customer, and order table in northwind database, please write a query to produce xml?

how to copy only distinct data into another table which is not already exist in database?

What is the difference between varchar and nvarchar types?

How to get a list of columns in a view using the "sp_columns" stored procedure?

What do you understand by the data quality services in sql server?

What is a partitioned view?

For more SQL Server Interview Questions Click Here