SQL SERVER – Get Current TimeZone Name in SQL Server Use below sql script to get timezone of sql server : DECLARE @TimeZone VARCHAR(50) EXEC […]
Category: SQL Interview Questions
Escape Single Quotes in SQL
Escape Single Quotes in SQL Single Quotes in Select , Insert and Update SQL statement can be escaped by adding another single quote in front. […]
Conditional Split in SSIS
Conditional Split in SSIS This transformation lets you route your data flow to different outputs, based on criteria defined within the transformation’s editor.
What is default value of DelayValidation property in SSIS
The default value of DelayValidation property in SSIS is false
What does DelayValidation property mean in SSIS
DelayValidation Property DelayValidation property indicates whether validation of the task is delayed until run time.
What are different task colour shown when SSIS package exceutes ? What each colour mean ?
Different task colours shown on task during SSIS package execution are : Yellow – means task is executing Green – means task has executed successfully […]
What are various tabs in SSIS Package Design window ?
Various tabs in SSIS Package Design window : Control Flow Data Flow Event Handlers Package Explorer
How XML can be stored in relational database ?
How XML can be stored in relational database ? There are three ways XML can be stored in relational database. 1. XML can stored as […]
SQL Questions : What is normalization ?
What is normalization ? Normalization is a method to seperate data into multiple tables and relate these multiple tables. Some benefits of normalized database : […]
SSIS : What is difference between Control Flow and Data Flow in SSIS ?
Difference between Control Flow and Data Flow in SSIS are as follows : The smallest unit in Control Flow is task whereas smallest unit in […]