SQL SERVER

1. Which TCP/IP port does SQL Server run on? How can it be changed?

SQL Server runs on port 1433. It can be changed from the Network Utility TCP/IP properties.

ASP.NET

1. What is ASP?

Active Server Pages (ASP), also known as Classic ASP, is a Microsoft's server-side technology, which helps in creating dynamic and user-friendly Web pages. It uses different scripting languages to create dynamic Web pages, which can be run on any type of browser. The Web pages are built by using either VBScript or JavaScript and these Web pages have access to the same services as Windows application, including ADO (ActiveX Data Objects) for database access, SMTP (Simple Mail Transfer Protocol) for e-mail, and the entire COM (Component Object Model) structure used in the Windows environment. ASP is implemented through a dynamic-link library (asp.dll) that is called by the IIS server when a Web page is requested from the server.

Dynamic Programming

1. What is Dynamic Language Runtime (DLR)?

DLR is a runtime environment that allows you to integrate dynamic languages with the Common Language Runtime (CLR) by adding a set of services, such as expression trees, call site caching, and dynamic object interoperability to the CLR.

Object-Oriented Programming

1. What is object-oriented programming (OOP)?

OOP is a technique to develop logical modules, such as classes that contain properties, methods, fields, and events. An object is created in the program to represent a class. Therefore, an object encapsulates all the features, such as data and behavior that are associated to a class. OOP allows developers to develop modular programs and assemble them as software. Objects are used to access data and behaviors of different software modules, such as classes, namespaces, and sharable assemblies. .NET Framework supports only OOP languages, such as Visual Basic .NET, Visual C#, and Visual C++.

ADO.NET

1. What is the full form of ADO?

The full form of ADO is ActiveX Data Object.

.NET Framework

1. What is .NET Framework?

.NET Framework is a complete environment that allows developers to develop, run, and deploy the following applications:

What is the difference between VB.NET and C# ?

Introduction

This Arttical i will explain What is garbage collection?

What are Value types and Reference types ?

Introduction

This Arttical i will explain What are Value types and Reference types ?

What is garbage collection?

Introduction
 
This Arttical i will explain What is garbage collection?

SQL Server- Difference Between Left Outer Join and Right Outer Join

Introduction:

Here I will explain differences between left outer join and right outer join in SQL Server.

Description:

In previous posts I explained  many articles relating to SQL Server. Now I will explain the difference between left outer join and right outer join in SQL Server.

SQL Server- Difference Between Left Join and Left Outer Join

Introduction:

Here I will explain the difference between LEFT JOIN and LEFT OUTER JOIN in SQL Server.

Description:

In previous posts I explained many articles relating to SQL Server. Now I will explain the difference between left join and left outer join in SQL Server.