At first, from Sql Server Management Studio click on Tools > Options

Description

STUFF function deletes a sequence of characters from a source string and then inserts another sequence of characters into the source string, starting at a specified position.

Introduction

In this articales I want to show how to chatting in asp.net using SignalR. I show how to do a public and private chat. The chatting data will store in the database. We see our previous chat by scrolling as like as facebook.

Introduction

In this post I want to show, how to Handel exception by sql server stored procedure.

Introduction

In this post I try to show how to show data in a data table, which data from sql server and using stored procedure. Also the data table have the link (Edit, Delete, Block/Unblock). The data table also

Error Message

An error has occurred while establishing a connection to the server.
(provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 5)

Follow The Below Steps:

1. Connect to SQL Server Instance using SQL Server Management Studio. Then right click on the AdventureWorks database which in this example we want to script out. From the popup menu, select "Tasks" and then "Generate Scripts…" option as shown in the snippet below.

Standard Security

Data Source=myServerAddress; Initial Catalog=myDataBase; User Id=myUsername; Password=myPassword;