Difference between Function and Stored Procedure?
Answer Posted / sumesh.tc
stored procedure is precompiled one but Function not( want
to compile each time)
| Is This Answer Correct ? | 20 Yes | 5 No |
Post New Answer View All Answers
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
Describe in brief system database.
What is 1nf 2nf?
Explain different types of lock modes in sql server 2000?
What do you know about system database? : SQL Server Architecture
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
How you can get the list of largest tables in a database?
What is exporting and importing utility?
What is a transact-sql statement batch in ms sql server?
What is policy based management (pbm)? : sql server database administration
Explain what are magic tables in sql server?
How to create dbo table in sql server?
What is a trace frag? Where do we use it?
What are the different types of Indexes available in SQL Server?