What are Instead of Triggers

Instead of triggers are used to reverse the default action of the query same as the word ‘insted of’ denotes. For example if we are going to execute query to delete record in Empoyee table and we want to first check whether id of employee passed Exist in database or not then we can place a “Insted of Trigger” in database on Delete Operation for that particular table and we will...

Difference Between Stored Procedure and Functions Sql

Stored Procedure and Functions   1. Function Must Return Value    For Stored Procedure it's Not Must to return value it's optional  2. Stored Procedures are pre-compile objects which are compiled for  first time and its compiled format is saved which executes (compiled code) whenever it is called  But Function is compiled and executed...

Import dbf database in sqlserver

Steps For Importing Dbf database into Sql Server There is no appropriate way or direct way to do that but nothing is impossible so there is workaround that can be done to perform this task . Here is the steps :- First we have to convert the .dbf format data into .csv format...