What Is Store Procedure

Stored Procedure in SQL Server can be defined as the set of logically group of SQL statement which are grouped to perform a specific task. We Use stored procedure is that it increases the performance of the database. stored procedures is that you can centralize data access logic into a single place that is then easy for DBA's to optimize. Stored...

Read More

Create First Application in MVC

We want to create Firstly application in MVC first of how we create first application Show Steps  as below-   STEP 1. Start Computer and Install Visual Studio (Mention installation step in previous tab how...

Read More

How To Install Visual Stdio Step by Step Process

How to install visual studio 2015 Step by Step Process like => Step (1) : Once downloading is complete, run the installer. The following dialog will be displayed. Step (2): Click the ‘Install’ button and it will start...

Read More

Overview of CSS

What is CSS? CSS stands for Cascading Style Sheets CSS is used to describe the look and formatting of a document written in markup language. It provides an additional feature to HTML. It is generally used with HTML to change the style of web pages and user interfaces. It can also be used with any kind of XML documents including plain XML, SVG...

Read More

Overview of HTML

What is HTML? First developed by Tim Berners-Lee in 1990. HTML is used to create electronic documents (called pages) that are displayed on the World Wide Web. Each page contains a series of connections to other pages called hyperlinks. Every web page you see on the Internet is written using one version of HTML code or another. HTML code ensures...

Read More

What is LINQ

LINQ (Language Integrated Query) is a Microsoft programming model and methodology that essentially adds formal query capabilities into Microsoft .NET-based programming languages. LINQ offers a compact, expressive, and intelligible...

Read More

Overview

 SQL(Structured Query Language)  SQL is a language that interacts with the database on the server-side. This dynamite duo has changed the structure of the internet forever. Sure, programming languages like PHP, ASP, and ColdFusion made the internet dynamic, but the efficiency of SQL has revolutionized how user's interact with websites. What...

Read More

Difference Between function v/s store procedure

Definition of Store Procedure In a database management system (DBMS), a stored procedure is a set of Structured Query Language (SQL) statements with an assigned name that's stored in the database in compiled form...

Read More

What is Function in Sql Server

A function is a block of code that has a name and it has a property that it is reusable. We use function in store Procedure and queries in sql server. We can define function like-  User Define function - It is created by user and use...

Read More

How To Create DataBase & Table in SQL Server

We Create Database in SQL Server Step 1.  Firstly open Computer and Click on SQL Server then Create DataBase. Step 1.  Write Query of creation of Database in Sql Server like this- Syntex CREATE DATABASE DATABASE_NAME Note- Here DATABASE_NAME is Created Database Name. Whatever u want to giveProper name of Database Ex. CREATE DATABASE...

Read More

SQL Select

The SQL SELECT Statement The SELECT statement is used to select data from a database. SQL SELECT Syntax SELECT column_name,column_name FROM table_name; Ex. SELECT * FROM TABLE_NAME Note - This Query select All data in table from database. SQL SELECT DISTINCT The SELECT DISTINCT statement is used to return only distinct (different) values. In...

Read More