Answer / Varun Kumar Vivek

Functions in SQL Server are predefined procedures that perform a specific action, returning a single value. They can be used to manipulate and transform data within a database. Examples include built-in functions like COUNT(), SUM(), AVG() etc., or user-defined functions (UDFs) created by the developer.

What is buffer cash and log cache in sql server?

1 Answers  

---

How to retrieve error messages using odbc_errormsg()?

1 Answers  

---

What is the recursive stored procedure in sql server?

1 Answers  

---

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

1 Answers  

---

What is forward - only cursors / read only cursor?

1 Answers  

---

what is spatial nonclustered index

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  

---

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

1 Answers  

---

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

1 Answers   Amazon,

---

What is the difference between deallocate cursor and close cursor?

1 Answers  

---

what is diffence between replicaion and logshipping?

1 Answers  

---

Explain about system database?

1 Answers  

---