How To Create A Trigger In MSSql Server
Today, I want to talk about triggers in MsSqlServer. Triggers are type of stored procedure that can make INSERT, UPDATE or DELETE operations on a table. The triggers differ from the stored procedures in...
Category: Ms Sql Server
How To Add A Job In MSSql Server
Today, I want to talk about adding jobs to your MsSql Database. It is very easy if you do it with Sql Server Management Studio. Let me explain it step by step. First, login...
Using Stored Procedures In MSSQL
Today, I want to talk about using stored procedures in MsSql. First let me explain why we need Stored procedures. Stored procedure means, SQL statements that are kept in the database and compiled in the...
How To Import Excel Data In MsSql
Today, I want to talk about importing data from an excel file to MsSqlServer. Right click database, choose task and import data option. Browse the excel file and select the version of your excel...
How To Export Data In MsSql
Today, I want to talk obout exporting data from MsSqlServer . You can do it in several ways. I will explain the methods I use exporting the data. First way is by excel file....
Recent Comments