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
- 8111 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
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Differentiate between syntax and runtime errors.
What is the difference between numeric and autonumber?
what is schema? : Sql dba
Mention what is the use of function "module procedure" in pl/sql?
What is a field in a database?
What are different types of statements supported by sql?
what is the use of double ampersand (&&) in sql queries?
explain the delete statements in sql
What does a pl/sql package consist of?
What does pl sql developer do?
Explain isolation levels. : Transact sql
What is sharding in sql?
What is on delete restrict?
What is rtm stands for?
