Answer / Dhermendra Kumar

The PARTITION BY clause in SQL Server allows data to be divided into smaller, more manageable sets or partitions based on a specified column. This can improve query performance for large tables, especially when performing aggregate functions such as SUM, AVG, MIN, and MAX.

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

1 Answers  

---

Can you index views?

0 Answers  

---

how many no of arguments can be passed in procedures and functions

2 Answers   ABC,

---

What is the use of keyword with encryption. Create a store procedure with encryption?

1 Answers  

---

What does it mean to normalize data?

1 Answers  

---

Please differentiate between a local and a global temporary table?

1 Answers  

---

What types of integrity are enforced by a foreign-key constraint

1 Answers  

---

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,

---

select empid empname from employee What is the result for the about query?

4 Answers  

---

How to check if a table is being used in sql server?

1 Answers  

---

Wht is the difference between stored procedure and trigger

6 Answers   HCL, TCS,

---

Explain error and transaction handling in sql server?

1 Answers  

---