Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Which index created when Create Index on table(col), Why

Question Posted / guest

Answers were Sorted based on User's Feedback



Which index created when Create Index on table(col), Why..

Answer / indexes

Non Clustered Index by Default.

Is This Answer Correct ?    15 Yes 0 No

Which index created when Create Index on table(col), Why..

Answer / sanjay

whenever you create index without specifying the type, its
non-clustered.

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What happens if we shrink log file in sql server?

0 Answers  

How to delete the duplicate rows from a table in SQL Server ??

3 Answers  

How to execute a sql statement using odbc_exec()?

0 Answers  

What is data mart? : sql server analysis services, ssas

0 Answers  

how do we insert 100 records at a time in a table without using for loop in database

1 Answers  

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 Answers  

What stored procedure can you use to display the current processes?

0 Answers  

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

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 tune a stored procedure?

6 Answers  

How do use Having,Group by,Group function in SQL?

0 Answers  

How to replace null values in expressions using isnull()?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories