I have a table with 100 records. Now I want to generate INSERT statements with the same data. How will you generate?
Posted in SQL Interview Questions by Chandrasekhar Raparthi On April 23, 2014
Open SSMS — Right click on Database — Tasks — Generate scripts — Next — Select specific database objects — select your table — Next — Select the output type — Advanced — Select data only from Types of data to script
How to add 5 business days to all values of a date column?
Posted in SQL Interview Questions by Chandrasekhar Raparthi On April 19, 2014
First of all do not get confused between 5 days and 5 business days. There is a big difference between these two. 5 Business days means 5 working days(Not holidays). 5 days can be any day. It can be working day or
What are the different ways of transferring data from one database to another database?
Posted in SQL Interview Questions by Chandrasekhar Raparthi On April 16, 2014
There are several ways available to transfer the data from one database to another database. Few of them are listed below. SSIS BCP Import/Export Wizard INSERT…SELECT… SELECT…INTO… DTS 2000
How to display only Even numbered rows from a table?
Posted in SQL Interview Questions by Chandrasekhar Raparthi On April 15, 2014
————————————————————————– USE [ADVENTUREWORKS2012] GO ————————————————————————– — Fetching only Even numbered rows. ————————————————————————–
How to Swap Two column values of a table whose data types are same?
Posted in SQL Interview Questions by Chandrasekhar Raparthi On April 10, 2014
It is possible by writing a simple UPDATE statement ——————————————————————- USE [ADVENTUREWORKS2012] GO ——————————————————————- — Before Swapping ——————————————————————- SELECT TOP 5 [VacationHours], [SickLeaveHours] FROM [HumanResources].[Employee] ——————————————————————-
What are the basic steps involved in creating a Cube?
Posted in SSAS Interview Questions by Chandrasekhar Raparthi On April 9, 2014
Steps to be followed: Create a data source Create a data source view with the required tables Create Dimensions Create a cube Deploy and Process the cube
Explain any 3 of CODD’s Rules
Posted in SQL Interview Questions by Chandrasekhar Raparthi On April 9, 2014
Edgar F. Codd, proposed thirteen rules (0 to 12) to define what is require d from a DBMS in order for it to be considered relational. Currently there is no commercial database management system which fully satisfies all the CODD’s rules. Rule No.