Difference between temp Table(#Table) and Table variable(@Table) in sql server

Json String in Sql Server

In this post i will show how to display/Convert Table Rows to JSON String.

Continuing the previous Post Create Temp Table in Sql Server

OutPut:

{

                "Data": [{

                                "id": 1,

                                "name": "Kiran",

                                "active": 1

                }, {

                                "id": 2,

                                "name": "Ravi",

                                "active": 1

                }]

}

Create Temp Table in Sql Server or Create Temp Table Variable in Sql Server

In this post I will show how to create Temp Table(variable) using @ symbol.

Previously I had shown

• How to Create Temporary Table in SQL Server using # .
• Function that Splits string in SQL Server / Table Valued Function
• Create Relationships Between Tables OR Create Foreign Key Relationships
• Concatenate many rows into a single text string using SQL Server 2008

OutPut:

ID	Name	IsActive
1	Kiran	1
2	Ravi	1
3	Vara	1
4	Dinesh	1
5	Deleep	0
6	Phani	1
7	Shiva	1
8	shyam	0

WHAT IS ASP.NET MVC...! ITS WORK FLOW,GOALS AND ADVANTAGES

Introduction:  In this article i am going to explain the following:

• What is Asp.Net MVC? (MODEL VIEW CONTROLLER)
• Asp.Net MVC pattern. 
• How MVC works i.e. MVC flow.
• Goals and Advantages of MVC.

Jquery DataTable in Asp.Net with server side Paging and Filtering (fast)

This is fast when compared to the previous post from here.

Jquery DataTable in Asp.Net with server side Paging and Filtering

Here i am going to explain the details ....

CRUD Operations in ASP.Net MVC 5 without writing single line of Code

Here in this post i will show How to do CRUD operations in Asp.Net MVC with out writing single line of code.

• Check This Post how to create Tables.
• Cascading DropDownList in Asp.Net MVC

Out Put :