Why we need a group by clause?4 6621
What is the difference between referencing and joining?1 2264
What is ACID Property of Transaction?10 29848
What is a cursor in SQL Server 2000 and their types?8 13663
How do we get month name in SQL Server 2000, Oracle, MS Access?11 45611
How do we return a record set from a Stored Procedure in SQl server 2000?3 3653
How do we get current date in SQL Server 2000, Oracle, MS Access?13 43065
What are the differences between stored procedure and functions in SQL Server 2000?25 96348
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 3727
Which is best Subquery (or) joins in sql server? explain why2 8960
last function used in MS Access to convert sql what function will use in sql
role of sql sever 2005 in database rather than any other database
Why do you want to join software field as you have done your BE in Electronics?
how many no of arguments can be passed in procedures and functions
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
what are the Prerequisites for Replication?
which backup strategy you are following at ur company
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
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
application server is slow what may be the problem
How do use Having,Group by,Group function in SQL?
what is package and it uses and how can u call a package
How much memory that we are using in Logshipping Concept?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram