In this article, explaining best MVC ASP.Net Interview Questions and Answers as following:
Q.What is ActionResult() ?
Ans: It is an abstract Class Continue reading “QA-MVC ASP.Net”
Let’s create a SampleDB database fist with SQL Management Studio. Now create a table in SampleDB.
CREATE TABLE [dbo].[tblEmployee](
[Emp_ID] [int] NOT NULL,
[Emp_Name] [varchar](max) NOT NULL,
[Emp_Age] [int] NOT NULL,
[Emp_Salary] [int] NOT NULL,
[Emp_City] [varchar](max) NOT NULL,
[Emp_Gender] [char](1) NOT NULL,
CONSTRAINT [PK_tblEmployee] PRIMARY KEY CLUSTERED
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
Insert Sample Data:
INSERT INTO [dbo].[tblEmployee]
SELECT 1,'Shashangka',20,35000,'Dhaka',1 UNION ALL
SELECT 2,'Shekhar', 19, 40000, 'Bagerhat', 1 UNION ALL
SELECT 3,'Shamim', 21, 35000, 'Dhaka', 0 UNION ALL
SELECT 4,'Shariar', 20, 40000, 'Rajshahi', 1 UNION ALL
SELECT 5,'Rajib', 22, 35000, 'Rajshahi', 0 UNION ALL
SELECT 6,'Avishek', 21, 35000, 'Barishal', 1 UNION ALL
SELECT 7,'Asif', 23, 40000, 'Dhaka', 0
Returns the number of items in a group. COUNT always returns an int data type value. Continue reading “Aggregate Functions in SQL Server”
Differences between them based on their properties :
Inserted and Deleted.
A cross join that does not have a WHERE clause produces the Cartesian product of the tables involved in the join. The size of a Cartesian product result set is the number of rows in the first table multiplied by the number of rows in the second table.
The common example is when company wants to combine each product with a pricing table to analyze each product at each price.
This is a particular case when one table joins to itself, with one or two aliases to avoid confusion. A self join can be of any type, as long as the joined tables are the same.
A self join is rather unique in that it involves a relationship with only one table. The common example is when company have a hierarchal reporting structure whereby one member of staff reports to another.
Microsoft SQL Server Data Transformation Services (DTS) is a set of graphical tools and programmable objects that lets user extract, transform, and consolidate data from disparate sources into single or multiple destinations.
SELECT table_name,index_name FROM user_constraints
Subqueries can often be re-written to use a standard outer join, resulting in faster performance. As we may know, an outer join uses the plus sign (+) operator to tell the database to return all non-matching rows with NULL values.
Hence we combine the outer join with a NULL test in the WHERE clause to reproduce the result set without using a sub-query.
BulkCopy is a tool used to copy huge amount of data from tables. BULK INSERT command helps to Imports a data file into a database table or view in a user-specified format.