Answer / ravikiran

Constraints are the mechanisms used by the sql server to
control unwanted or invalid data flow into a table.

Joins are the queries used to combine the rows from two or
more tables.

Answer / monal

Constraints are restrictions to make sure that data entered
in a table must meet certain crietria. You can put
constraint at either table level or column level. There are
5 types of constraints. Primary Key, Foregin Key, Unique,
Check and NOT NULL.

Joins are used to combine rows from one or more table. One
table using Self Join and More tables using inner join,
outer join, cross join.

Explain various data region available in ssrs with their use?

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 acid mean in sql server?

0 Answers  

---

What are the benefits of filtered indexes?

0 Answers  

---

What is an index?

8 Answers   Yardi Software,

---

How to rebuild the master database?

0 Answers  

---

Does the order of columns in update statements matter?

0 Answers  

---

What is factless fact table? : sql server analysis services, ssas

0 Answers  

---

Can you get second highest salary from the table?

0 Answers   QuestPond,

---

Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement

3 Answers  

---

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

0 Answers  

---

1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder

3 Answers   CarrizalSoft Technologies, IBM,

---