Answer Posted / trived.r

store proceder is T-SQL commend , in store proceders
baunch of commends and bunch of statement excuted at a time
know as store proceder.
ex :
select (avg)sal,ename from emp

we dont write evry time this commend

simply write of this commend insted of

write this commend (STORE PROCEDER)

CREATE PROC USD_AVGSAL FROM EMP
U EXECUTE N NUMER OF TIMES WITH THIS AND
EXEC USD_AVGSAL...........
Index is read from spcific recored or data know as index.
and index use of retrive data fast.faster excution.
syntax:
create non clusterd index cid_eid_emp

on emp(eid)
on primary.

What are trace files?

697

---

What is the maximum size of a row in sql server?

708

---

What is sql or structured query language?

860

---

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2377

---

How can sql injection be stopped? : sql server security

706

---

---

Is mysql better than sql server?

726

---

Is sql server difficult to learn?

683

---

how you can move data or databases between servers and databases in sql server? : Sql server administration

682

---

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

173

---

How do I change my passwords (database, LDAP, and so on) without causing an outage?

775

---

What is extent? Types of extents?

782

---

Which trace flags are enabled in sql server?

661

---

what type of index will get created after executing the above statement? : Sql server database administration

722

---

What number sorts of privileges are accessible in sql?

735

---

What is primary key index?

702

---