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

How to update existing rows in a table?

What is the recovery model? List the types of recovery model available in sql server?

What are commonly used mssql functions in php?

What is the temp table?

What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same?

How to avoid cursors?

How can we delete a table in sql server?

How do you trace the traffic hitting a sql server?

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

How to copy data from one table to another table?

How to execute stored procedure in select statement sql server?

What are cursors?

For more SQL Server Interview Questions Click Here