1.what is stored procedure?Its significance with example?
2.Explain about index with syntax and example?
plz do reply.........
- 2 Answers
- 9628 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
How to choose all records from the table?
What are the triggers in sql?
What is the template in sql?
Define primary key?
What is the datatype of rowid?
How many full-text indexes can a table have?
Why SQL Agent is used?
Why is the need for data conversion transformations?
How to delete an existing database user?
What is relationship? What number of sorts of relationship are there?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
What are the database objects? : SQL Server Architecture
can a table be moved to different filegroup? : Sql server administration
How to defragment table indexes?
What do you understand by a view? What does the with check option clause for a view do?
