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
- 10718 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
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
What are exact numeric data types in ms sql server?
What do you mean by a Composite primary key?
Write a SQL queries on Self Join and Inner Join.
How can you find out which stored procedures are recompiling?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What is the use of for clause?
What is nonclustered index on computed columns?
What is query parameter in ssrs?
How to use “drop” keyword in sql server and give an example?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What is RAID? What are the different types of RAID configurations?
What is the primary use of the model database?
Explain microsoft sql server functions?
Why truncate is ddl command?
