What is it unwise to create wide clustered index keys?
How self join is different from outer join?
Explain what is scheduled job and how to create it?
Detail about the hardware which is supported by SQL server?
Explain different isolation levels?
Explain the different types of backups available in sql server? : sql server database administration
What do you understand by recursive stored procedure?
statement (of account) Receive ID_receive Date_receive Amount_receive TO_receive From_receive Description_receive 1 2010/01/01 500 Bank Ahmed Payment from the account 2 2010/02/01 700 Bank Ahmed Payment from the account Payment ID_payment Date_payment Amount_payment From_payment To_payment Description_payment 1 2010/03/01 1000 Ahmed Sales Sale goods 2 2010/04/01 1500 Ahmed Sales Sale goods How can crate Stored Procedures for the statement (of account) from these tables? I want statement (of account) like this: (in sql 2005) ID_ name description debit account credit account balance
what are user defined datatypes? : Sql server database administration
what is advantages in sql 2005 over sql 2000?
what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
What is the use of SCOPE_IDENTITY() function?
What does asynchronous call backs means?