Answer / akash

it will return the integer value of a variable

for example

intval(42); // 42
intval(4.2); // 4
intval('42'); // 42
intval('+42'); // 42

What are the transaction properties?

0 Answers  

---

wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform

1 Answers   Idea,

---

Explain syntax for viewing, dropping and disabling triggers?

0 Answers  

---

What are triggers in ms sql server?

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 you can move data or databases between servers and databases in sql server?

0 Answers  

---

What is normalization? Explain its different types?

0 Answers   GE, Maveric,

---

Can two different columns be merged into single column? Show practically?

0 Answers   QuestPond,

---

What are different types of join?

0 Answers  

---

What is Trace flag?

1 Answers   Wipro,

---

What are the different ways of moving data/databases between servers and databases in SQL Server?

1 Answers  

---

What is the difference between set and select?

0 Answers  

---