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
- 10475 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 factors you will consider calculating the storage requirement for that view?
Explain contrast amongst grouped and non-bunched records?
Tell me what is the significance of null value and why should we avoid permitting null values?
Explain four layers of abstraction microsoft architectured?
What are data driven subscriptions?
What is BCP? When does it used in sql server 2012?
What are the options which must be set to allow the usage of optimistic models?
List the different types of joins?
How to delete duplicate rows from table except one?
What is bit data type? What's the information that can be stored inside a bit column?
What is rolap and its advantage? : sql server analysis services, ssas
How ssrs maintain security?
What are the different types of replication are there in sql server 2000?
What is a select query statement in ms sql server?
How does Report Builder support Analysis Services cubes?
