Answer Posted / subhash

In order to create database test cases you can have two
different aproaches performing both of them is advisable if
time permits.1) Testing each and every Trigger Cursor SP
used in the application.2) Testing the application w.r.t
functionality of the application like for example:Let's say
there are two web sites type 'ABC' records should be
displayed only in ABC websiteand type 'XYZ' records should
be displayed only in XYZ website. You can insert a new type
'ABC' record and see if it is displayed only on ABC website
and not on XYZ website.Both the websites are controlled by
the same company it just wants type I customers to have
acces to type I website and Type II customers have access to
type II website. This is a completely imaginary example
there can be any type of application or service
functionality which can be broken down in totest cases in
turn.Hope this from now on for anyone will be of good help.

What are the differences between stored procedure and view in sql server?

1319

---

What are the different editions available in sql server 2000?

1116

---

What is in place upgrade in sql server?

1095

---

What are different replication agents and what's their purpose? : sql server replication

1054

---

How to use column default values in insert statements in ms sql server?

1104

---

How do I create a stored procedure in dbml?

1084

---

How do I view a stored procedure in sql server query?

983

---

What is the meaning of resultset type_scroll_insensitive?

994

---

What is database white box testing?

1178

---

Do you know spatial data types - geometry and geography in sql server 2008?

1092

---

What is sql injection and why is it a problem? : sql server security

1188

---

What is a sql join?

1082

---

In case you have filters in your report, when filters will be applied in cached report instance?

119

---

What is the query and subquery?

1122

---

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

1000

---