Network DBMS (NDBMS)

Network DBMS A DBMS is said to be Network DBMS, when it organizes the data in a network structure. As you all are aware that, a network may have as many connections as it can. In our DBMS language, we can say

Read More

Hierarchical DBMS (HDBMS)

Hierarchical DBMS A DBMS is said to be hierarchical, when the data is organized like a tree structure. That means, it simply represents the data using parent – child relationship. It is the oldest style of organizing/storing data and still some organizations

Read More

What is a Database?

Database A Database is a collection of data well organized in such a way that it can be accessed easily and efficiently. It seems very easy to define. But this is the one which rules the entire world in any field. Our

Read More

What are the Report items available in SSRS 2012?

Report Items Report items are the controls available in SSRS tool box which we can drag and drop to designer area. Below are the list of Report items available in SSRS 2012. Text Box Line Table Matrix Rectangle List Image Sub Report

Read More

What are the main SSRS components ?

SSRS Components The main SSRS components are, Report Server — It is the heart of SSRS which interacts with other components and plays key role in processing of data, deploying etc… Report Server database — Two databases called reportserver and reportservertempdb which stores the reports definition data.

Read More

What is Row constructor /Table valued constructor in SQL Server?

Row Constructor Row constructors is the new feature introduced in SQL Server 2008 to insert multiple rows by writing a single INSERT statement. It saves lot of time when we are inserting many records into a table. Ex: ———————————————————————————————————————– — Before SQL

Read More

How to DELETE duplicate records from a table?

Delete Duplicate records It is possible with CTE(Common Table Expresssion). Let us say, duplicated records are there in a table with the same values for all the columns. Now we have to delete 2 duplicated rows from the below record set. Since all

Read More

What is the difference and similarities between local and global temporary tables?

Local Temporary tables Visible only to the current session. Multiple users can’t use the same table. To create these, table name should be prefixed with ‘#’                 Ex: CREATE TABLE dbo.#LocalTemp….. Dropped automatically when the current session is closed  Global Temporary tables Visible

Read More

How to transfer the whole data from one table to another table which does not exists in database?

SELECT INTO We can do it using SELECT INTO clause. Syntax: SELECT <Columns List> INTO <New Table Name> FROM <Existing Table Name> Ex: SELECT * INTO dbo.EmployeeBKP FROM dbo.Employee When you execute the above query, dbo.EmployeeBKP table will be created automatically with the

Read More

What is Bulk Copy Program (BCP)?

BCP BCP stands for Bulk Copy Program. It is used to Import/Export the data between Data files and SQL Server. BCP Commands are case sensitive. Syntax: bcp <Table/View/Query> <in/out/queryout/format> <File Name> <options> Ex 1: bcp SQLVersityDB.dbo.BCPDemo in “C:\BCPDemoBCP.txt” -c -T It imports all

Read More