Answer / Phool Kunwar

System scalar functions are built-in functions in SQL Server that can be used directly within a SELECT statement. They do not operate on tables, but instead perform calculations or return system values such as current date and time, random number generation, string manipulation, etc.nnExamples include @@IDENTITY, LEN, SUBSTRING, GETDATE, etc.

How can your resolve deadlocks?

4 Answers   IBM, IMS, Iron Mountain, NuWare,

---

Explain partitioned view?

1 Answers  

---

what does the automatic recovery do? : Sql server administration

1 Answers  

---

How many ways to create table-valued functions?

1 Answers  

---

What does the on update no action do?

1 Answers  

---

Does a specific recovery model need to be used for a replicated database? : sql server replication

1 Answers  

---

What is the main difference between ‘between’ and ‘in’ condition operators?

1 Answers  

---

What is NOT NULL Constraint in sql server 2012?

1 Answers   CDC,

---

Explain the stored procedure?

1 Answers  

---

plss anybody specify tha constrian management system in dbms

1 Answers   Police Constable,

---

Define a cross join?

1 Answers  

---

Are resultset updatable?

1 Answers  

---