Answer / Shiv Kumar

Schemabinding a view in SQL Server means that the view's definition depends on the existence and integrity of other database objects. This prevents the view from being modified in ways that would affect its intended result.

What is tablesample?

1 Answers  

---

How and why use sql server?

1 Answers  

---

How sql server enhances scalability of the database system?

1 Answers  

---

If i am handling 150 servers then how to check the active jobs of all the servers?

0 Answers  

---

How to download and install the scaled-down database adventureworkslt?

1 Answers  

---

How to transfer data from a cursor to variables with a "fetch" statement?

1 Answers  

---

Which joins are sql server default?

1 Answers  

---

What is the guest user account in sql server? What login is it mapped to it? : sql server security

1 Answers  

---

What is store procedure? How do they work?

1 Answers  

---

What are the main sources of data?

1 Answers  

---

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers  

---

How to write a query with a right outer join in ms sql server?

1 Answers  

---