how to write test cases for testing databases,especially
for testing and writing test cases for stored
procedures.any real time database testers.please answer me.
No Answer is Posted For this Question
Be the First to Post Answer
What is difference between views and tables?
What is cursors?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
Explain the first normal form(1nf)?
Do you know concepts and capabilities of sql server?
Explain what are sparse columns?
create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year
What is SQL Profiler what is the use of it?
2 Answers 247Customer, Steria,
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
What are the OS services that the SQL Server installation adds?
Do you know what is xpath?
What is transaction server consistency?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)