Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76835 Views
- Cognizant, Infosys, TCS, Veritas, I also Faced
- E-Mail Answers
Answer Posted / ashwini
SQL query will be compiled everytime it is executed.
Stored procedures are compiled only once when they are
executed for the first time.
| Is This Answer Correct ? | 209 Yes | 18 No |
Post New Answer View All Answers
Do you know what is openxml in sql server?
Why use “pivot” in sql server?
How do you improve the performance of a SQL Azure Database?
Sql server reporting services vs. Crystal reports.
what are database files and filegroups? : Sql server database administration
What is the purpose of update statistics and scope_identity() function?
What languages bi uses to achieve the goal?
What are the basic functions for master, msdb, model, tempdb databases?
What is the library index called?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
What do you understand by physical_only option in dbcc checkdb?
How to list all tables in the database using odbc_tables()?
How to loop through result set objects using mssql_fetch_array()?
How to concatenate two character strings together?
Which command is used for user defined error messages?
