What is INTVAL( )and where we use Plz any body help me1 4537
What is the difference between a stored procedure and a user defined function in sql server?2 5804
could u plz explain about joins and views?2 3039
plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver20053 3343
can anyone explain me the concept of Serialization in Detail and Clear? plz its urgent i have interview on friday (15th feb)1 4990
Anyone please explain me the concept of Serialization?3 3218
can any one please send sql quries most used in applications.2 2613
what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;13 13686
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
How dts is used to extract, transform and consolidate data?
What is a filestream?
Explain the different types of joins?
Why SQL Agent is used?
Why do we need normalization?
How to choose all records from the table?
What is the difference between stored procedure and functions?
How to maintain a fill factor in existing indexes?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
What is the difference between ddl and dml?
What is bulkcopy in sql?
How many types of stored procedures are there in sql server?