Creating Trigger in SQL Server Table

SQL Trigger
Trigger is a action which will perform when the table gets insert, update or delete. We can choose the options on what the trigger should get invoked and create the syntax as below

CREATE Trigger triggername
ON tblname
FOR INSERT,UPDATE,DELETE -- We can add or remove the criteria here
AS
BEGIN

-- Action steps needs to carried out should be given here.

END

Creating Trigger in SQL Server Table was last modified: November 15th, 2017 by Justin Antony

How to create a simple report ?

simple SSRS report
New -> Project -> Report Server Project -> Right click on Shared DataSet -> Add New Data Source
Right click on Report Folder -> Add New Item
In the Report Data Tool Bar -> Right Click on the Data Sources -> Select the shared Data Source which we created already
Right Click on the Data Set -> Add DataSet -> Define your query here
Drag and Drop a table
Pick the Data fields from dataset and place it on the table.
Align and format the Table Accordingly
Add header to your Report.
Save and Run the Report.

How to create a simple report ? was last modified: October 1st, 2017 by Justin Antony

What is the transaction support feature in SSIS and how to configure it?

transaction support feature SSIS
If a package fails in the middle then SSIS used this functionality to start the execution from the place where it failed. Also the transactions gets roll-backed aswell if needed.
Supported – Parent object has initiated a transaction and child package will participate in it this transaction
Required – This will create and start a new transaction
NotSupported – This will not support the transaction
We need to enable MS DTC (Microsoft Distributed Transaction Coordinator) Windows Service for transaction support

What is the transaction support feature in SSIS and how to configure it? was last modified: October 1st, 2017 by Justin Antony

What is an user defined datatypes(UDD)?

user defined datatypes sql server
User defined datatypes gives a descriptive name and format to the database tables.
example: suppose if a column named Phone with varchar(10) which appears in many tables.
you can create a UDD called Phone_code_Type of varchar(10) and use it across all the tables of the database.

What is an user defined datatypes(UDD)? was last modified: October 1st, 2017 by Justin Antony

Difference between a primary key and a unique key

primary key unique key
A primary key creates a clustered index on the column and unique keys create a nonclustered index. Primary keys do not allow NULL value and unique keys allow one NULL value.
Both primary and unique keys enforce uniqueness of the column on which they are defined. A table can have only one primary key but many unique key

Difference between a primary key and a unique key was last modified: October 1st, 2017 by Justin Antony

Description: Cannot create a task from XML for task “Refresh Microsoft Excel Task”, type “oh22is.SqlServer.PqRefreshTask, oh22is.SqlServer.PQRefersh, Version =1.0.0.0, Culture=neutral, PublicKeyToken=4983f182acb1fc6b” due to error 0x80070 057 “The parameter is incorrect.”

The issue can occur on the following reason.

  1. Any third party SSIS support installation is missing.
  2. SSIS Version compatibility issue.
Description: Cannot create a task from XML for task “Refresh Microsoft Excel Task”, type “oh22is.SqlServer.PqRefreshTask, oh22is.SqlServer.PQRefersh, Version =1.0.0.0, Culture=neutral, PublicKeyToken=4983f182acb1fc6b” due to error 0x80070 057 “The parameter is incorrect.” was last modified: October 1st, 2017 by Justin Antony