How to transfer an existing table from one schema to another schema in ms sql server?

0 Answers  

---

Explain the types of indexes.

0 Answers   Accenture,

---

Do you know how to send email from database?

0 Answers  

---

What is Pointer ?

3 Answers   Cap Gemini, CarrizalSoft Technologies,

---

what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?

2 Answers  

---

Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 Answers  

---

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

0 Answers  

---

How to create an identity column?

0 Answers  

---

What is the size of transaction log file?

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  

---

How to receive returning result from a query?

0 Answers  

---

What is the use of nvl work?

0 Answers  

---