Write the SQL query to drop, truncate and delete table.
No Answer is Posted For this Question
Be the First to Post Answer
Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
How to provide Security for package?
What is the library index called?
what stored procedure can you use to display the current processes? : Sql server administration
Which index created when Create Index on table(col), Why
What is the query and subquery?
What is primary key index?
How to list all user defined functions in the current database?
What is order of B+tree?
How send email from database?.
3 Answers CarrizalSoft Technologies, Merrill Lynch,
How many types of keys are there?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)