Articles of level

In this article we will show you the steps to  reset identity column in MS SQL Server database.
There are many types of join in sql server-

Stored procedure can reduced network traffic and latency, boosting application performance.Stored procedure execution plans can be reused, staying cached in SQL Server memory, reducing server overhead.Stored procedures help promote code reuse.Stored procedures can encapsulate logic. You can change stored procedure code without affecting clients.Stored procedures provide better security to your data.

Before you create a stored procedure you need to create a table-

Let take for example we have two tables manager and customer.  Both of these tables have somewhat the same structure such as the following columns:

  1. FirstName
  2. LastName
  3. AddressLine1
  4. City
  5. StateProvinceCode
  6. PostalCode

Temporary tables are temporary storage structures. You may use temporary tables as buckets to store data that you will manipulate before arriving at a final format. The hash (#) character is used to declare a temporary table as it is prepended to the table name. A single hash (#) specifies a local temporary table.

Dynamic management views (DMVs) and functions return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance; that is, they let you see what is going on inside SQL Server. They were introduced in SQL Server 2005 as an alternative to system tables. One example is viewing operating system wait statistics via this query:

There are two main keywords used for deleting data from a table: TRUNCATE and DELETE. Although each achieves the same result, the methods employed for each vastly differ. There are advantages, limitations, and consequences of each that you should consider when deciding which method to use.

A connection string provides the information that a provider needs to communicate with a particular database. The Connection String includes parameters such as the name of the driver, Server name and Database name , as well as security information such as user name and password.
An ADO.NET Data Provider is a class that can communicate with a specific type of database or data store. Usually Data Providers use a connection string containing a collection of parameters to establish the connection with the database through applications. The .NET Framework provides mainly three data providers, they are-

  • ODBC

From the following section you can find different types of providers and its connection strings in detail.

Setup SQL Server Alerts to notify SQL Server Agent Operators on a failure condition.
Include RAISERROR or TRY/CATCH logic in your backup or restore code to send an email on a failure condition.

Displaying 1 of 2Next
1 2
Need Help? Contact Us.

Log in


Forgot password?


New User