Explain the usage of floor function in sql server.

0 Answers  

---

How retrieve field names from the table in SQL through JAVA code?

0 Answers  

---

What is the order in which the SQL query is executed? list them in order.

5 Answers   CarrizalSoft Technologies, CTS, Oracle,

---

How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.

2 Answers   247Customer,

---

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 enter unicode character string literals in ms sql server?

0 Answers  

---

How to implement service broker?

0 Answers  

---

Explain the categories of stored procedure?

0 Answers  

---

What is the significance of master, tempdb and model databases?

0 Answers  

---

What are the two authentication modes in sql server?

0 Answers  

---

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

0 Answers  

---

How many databases Microsoft SQL server provides?

0 Answers   Abacus,

---