WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?

8 Answers  

---

What are the properties of the transaction?

0 Answers  

---

How to write a script for upate the data in prod , i have 50000 row are there

2 Answers   TCS,

---

Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)

1 Answers  

---

Give an example of SQL injection attack ?

0 Answers   HAL,

---

What is cte (common table expression)?

0 Answers  

---

What command do we use to rename a db?

5 Answers   IBM,

---

Explain what is cte (common table expression)?

0 Answers  

---

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers   HCL, Wipro,

---

How you trouble shoot when any job fails

0 Answers  

---

How to get the count of distinct records. Please give me the query?

8 Answers   Value Labs,

---

sql database suspect We have a sql database that is showing as suspect. How can we recover?

0 Answers  

---