Interested to Buy Any Domain ? << Click Here >> for more details...
wht is the difference between truncat,drop in sqlserver
wht is the difference between function and stored procedure
- 3 Answers
- 8292 Views
- Apollo, I also Faced
- E-Mail Answers
Answer Posted / chandra shekher
truncate command will remove the table and again recreate
the table.
drop command will remove the table permanently from the
database.
Function must return a value where as stored procedure may
or may not return a value.
Function can return only one value where as stored
procedure can return multiple values.
Function can be used in sql query where as stored procedure
cannot be used in sql query.
Function is used to compute a value where as stored
procedure can be used to perform a task
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
How can you select unique records from a table?
Why is normalization important?
How do you write a subquery?
How to combine two stored procedures in sql?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What are the usages of sql?
What is substitution variable in pl sql?
Can instead of triggers be used to fire once for each statement on a view?
Can we edit a view in sql?
What are stored procedures in mysql?
Why use truncate instead of delete?
How many types of normalization are there?
What is sql procedures and functions?
What is the best partition size for windows 10?
