DIFFERENCE BETWEEN A STORED PROCEDURE AND A TRIGGER
STORED PROCEDURE TRIGGER A Stored procedure can be defined as a user defined code written in PL/SQL, which may or may not return a value when invoked by calling it…
Run a large SQL script in MS-SQL server | Solution: Insufficient memory to continue the execution of the program
Today one of my team mates came to me with a script file of 157 mb. He said he wanted to execute it so that the DB can be filled…