Answer / swapna

Non-clustered index. Important thing to note: By default a
clustered index gets created on the primary key, unless
specified otherwise.

Answer / mobin sathupally

If we simple say CREATE INDEX then non clustered index will
be created.At the same time if we say CREATE NON CLUSTERED
INDEX then also non clustered index will be created.

Eg.
CREATE TABLE Emp(
eid INT
,ename VARCHAR(20))

CREATE INDEX in_emp_eid
ON Emp(eid)
By executing above code we create non clustered index.

Eg.
CREATE TABLE Emp(
eid INT
,ename VARCHAR(20))

CREATE NONCLUSTERED INDEX in_emp_eid
ON Emp(eid)

By using this code also we create non clustered index only.

Answer / rams

Non-clustered index. Important thing to note: By default a
clustered index gets created on the primary key, unless
specified otherwise.

can any one say how to update the following senario I have a table <srabank> in which the table structure is as follows ANAME ACCNO LOCATION ACCTYPE BAL SBanuPrakash 31518746291 Punganur deposit 4000 Sreenivas 31518746292 mahoobnagar current 14000 Ranjith 31518746293 Karimnagar Savings 2000 Giresh 31518746294 Chennai deposit 40000 Boo 31518746295 Chennai Savings 20000 Jay 31518746296 Valachari Savings 1000 tirumalraj 31518746297 Vellore Savings 8000 The senario is We need to select one account number and check the balance after checking the balance if the balance exist we need to transfer to another account . in the from account the amount need to be reduced and in the to account the amount needed to be added. for example for the <accountno> <31518746291> the balance is <4000> for the <accno> <31518746292> the balance is <14000> after transferring the balance the details will look as follows <accno><31518746291> <bal> <2000> <accno><31518746292> <bal> <16000> the above mentioned two statment will come under the final result.

3 Answers  

---

What is hot add cpu in sql server 2008?

0 Answers  

---

How sql server enhances scalability of the database system?

0 Answers  

---

What is a partition function in sql server?

0 Answers  

---

Do you know the capabilities of cursors?

0 Answers  

---

Can we use having clause without group by?

0 Answers  

---

How many types of keys are there?

0 Answers  

---

Normalization and denormalization

3 Answers   Wipro,

---

Tell me what is normalization? Explain different forms of normalization?

0 Answers  

---

How do you measure the performance of a stored procedure?

3 Answers   Infosys,

---

Can a synonym name of a table be used instead of a table name in a select statement?

0 Answers  

---

What is partition, how will you implement it? : sql server analysis services, ssas

0 Answers  

---