What is the basic difference between a sql and stored
procedure ?

Answer Posted / thanjairajan@gmail.com

SQL is a Language. Stored procedure is transact SQL statement.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the basic techniques of indexing?

577


What are local and global Indexes and where they are useful.

930


what is the difference between a having clause and a where clause? : Sql dba

519


how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

3239


What is the size of partition table?

553






how to check server status with 'mysqladmin'? : Sql dba

569


What is acid property in a database?

586


What is auto increment feature in sql?

621


What is dcl in sql?

528


What is cursor explain with example?

553


What is an example of translating a date into julian format?

580


How many clustered indexes can be created on a table?

591


Which certification is best for sql?

540


What is a clob in sql?

567


how many ways we can we find the current date using mysql? : Sql dba

616