Interested to Buy Any Domain ? << Click Here >> for more details...
1.what is stored procedure?Its significance with example?
2.Explain about index with syntax and example?
plz do reply.........
- 2 Answers
- 10613 Views
- I also Faced
- E-Mail Answers
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.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is ssrs?
How can change procedure in sql server?
Can one drop a column from a table?
How many columns can we include on clustered index ?
How do I start and stop sql server?
Write the syntax for stuff function in an sql server?
What stored by the master? : sql server database administration
What is table join?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
What is the index requirement in SQL Azure?
What do you mean by stored techniques? How would we use it?
Can we hide the definition of a stored procedure from a use?
What the different components in replication and what is their use?
What is indexing and its types?
what is the primary use of the model database? : Sql server administration
