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

1 Answers
6116 Views
Covansys, I also Faced
E-Mail Answers

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

Post New Answer

More SQL Server Interview Questions

What does the on update no action do?

0 Answers

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

0 Answers

wat is mean by normalization?......programing defination i need...(i know basic defination)

4 Answers Wipro,

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

0 Answers Genpact,

What does the automatic recovery do?

1 Answers

What is Extended user-defined?

0 Answers

What is replication with database mirroring? : sql server database administration

0 Answers

Can you explain full-text query in sql server?

0 Answers

What is the default fill factor value?

0 Answers

CREATE TABLE [dbo].[HPMS_CompetencyTypes](CompetencyType varchar(50) ) go create trigger hpms_create_Insert on HPMS_CompetencyTypes for insert as if Exists ( select * from [HPMS_CompetencyTypes] where CompetencyType=(select * from [HPMS_CompetencyTypes])) begin Rollback tran Raiserror ('duplicate value',12,6) go insert HPMS_CompetencyTypes (CompetencyType) values ('new') I'm new to trigger can any one tell me where is the issue. Please.

2 Answers

What is the difference between a function and a trigger?

0 Answers

Explain the stored procedure?

0 Answers

For more SQL Server Interview Questions Click Here