What will be the maximum number of index per table?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What is 3nf normalization?

0 Answers  


what is differencial backup?how to work?Anybody explai it?

2 Answers   HCL,


How to list all user names in a database?

0 Answers  


you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 Answers  


What is the difference between stored procedure and functions?

0 Answers   MCN Solutions,






create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,


what is macro?

5 Answers   Excel, Global Innovation, Wipro,


What is optimization and its types?

0 Answers  


What is dbcc?

0 Answers  


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

1 Answers  


How to create a login account in ms sql server to access the database engine using "create login" statements?

0 Answers  


What area unit the various kinds of info compression introduced in sql server 2008?

0 Answers  


Categories