Why we need a group by clause?4 6681
What is the difference between referencing and joining?1 2317
What is ACID Property of Transaction?10 30051
What is a cursor in SQL Server 2000 and their types?8 13750
How do we get month name in SQL Server 2000, Oracle, MS Access?11 45754
How do we return a record set from a Stored Procedure in SQl server 2000?3 3732
How do we get current date in SQL Server 2000, Oracle, MS Access?13 43289
What are the differences between stored procedure and functions in SQL Server 2000?25 96654
Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???3 3807
Which is best Subquery (or) joins in sql server? explain why2 9020
what are the Prerequisites for Replication?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
How to convert a table data in XML format in sql server?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
How to restore performance issues and how to check?
New concepts of sql server 2005 use in your project.
what exactly sql injuction.how to overcome.....
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
how can you attach more than 20 ldf files in sql server
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
Delete duplicate rows without using rowid.
ow to bring suspect mode datbase online from scratch
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
last function used in MS Access to convert sql what function will use in sql
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