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
What are the basic techniques of indexing?
What are local and global Indexes and where they are useful.
what is the difference between a having clause and a where clause? : Sql dba
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
What is the size of partition table?
how to check server status with 'mysqladmin'? : Sql dba
What is acid property in a database?
What is auto increment feature in sql?
What is dcl in sql?
What is cursor explain with example?
What is an example of translating a date into julian format?
How many clustered indexes can be created on a table?
Which certification is best for sql?
What is a clob in sql?
how many ways we can we find the current date using mysql? : Sql dba