Answer Posted / sakthi
Inside function we cannot able to insert, udate or delete
any record but in procedure we can use it. inside function
we cannot able to call any other functions or procedure but
inside procedure we can call other procedure and functions.
these are the major differences
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain difference between cross join and full outer join?
What is a non-clustered index?
Explain system functions or built-in functions? What are different types of system functions?
What is an index in a database?
What is the importance of concurrency control?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
Do you know the policy based administration feature of sql server 2008?
What is the difference between ddl and dml?
What is the difference between coalesce() & isnull()?
What is data modification?
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?
what is bit datatype? : Sql server database administration
Create and insert into temp table in sql server?
Explain the difference between primary keys and foreign keys?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration