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
- 10570 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 would you choose between a clustered and a non-clustered index?
what is hash nonclustered index
What is sub-query in sql server? Explain its properties.
Explain temporary table vs table variable by using cursor alternative?
What is the parse query button used for?
Explain the concept of view and Types of views in SQL server?
What is the log shipping?
Give me any three differences between Truncate and Delete.
What is store procedure?
Explain about protocol layer present in SQL server?
how you can move data or databases between servers and databases in sql server? : Sql server administration
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
To which devices can a backup be created and where should these devices be located? : sql server management studio
What are the properties of the transaction?
How to convert a numeric expression from one data type to another?
