Articles of level

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

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.

Master Database
Purpose - Core system database to manage the SQL Server instance.  In SQL Server 2005, the Master database is the logical repository for the system objects residing in the sys schema.  In SQL Server 2000 and previous editions of SQL Server, the Master database physically stored all of the system objects.

  • Prominent Functionality
  • Per instance configurations
  • Databases residing on the instance
  • Files for each database
  • Logins
  • Linked\Remote servers
  • Endpoints
  • The first database in the SQL Server startup process
The Master database holds information for all the databases located on the SQL Server instance, and it is the glue that holds the engine together. Because SQL Server cannot start without a functioning master database, you must administer this database with care.Master database is system database. It contains information about servers configuration. It is a very important database and important to backup Master database. Without Master database, server can not be started.Master database is used to store information of all the databases on the SQL server. The server cannot start if the database is not configured properly.

The SQL Server (Transact-SQL) SUBSTRING functions allows you to extract a substring from a string.

SUBSTRING( string, start_position, length )
Parameters or Arguments:
string: The source string to extract from.
start_position: The position to start extraction from. The first position in the string is always 1.
length: The number of characters to extract.

Need Help? Contact Us.

Log in


Forgot password?


New User