What is trigger and stored procedure in sql?
No Answer is Posted For this Question
Be the First to Post Answer
How many tables can a sql database have?
Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.
If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?
Why do we use sql constraints?
Is nosql faster than sql?
What is trigger in sql? Explain
display your age in months?
how to get second highest salary in SQL(as/4000
What is the different between Stored Procedure and Procedure?
When are we going to use truncate and delete?
What does (*) mean in sql?
What is the difference between mdf and ndf files?
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)