archives

SQL Server

This category contains 10 posts

How to improve the performance of store procedure?

This Article give you some tips to increase store procedure performance. improve performance of store procedure

Rate this:

Storeprocedure Vs Functions

Many time interviewer ask you what is the different between storeprocedure and Functions here is the answer for this. you can see this article on c-sharpcorner also. Download this Article from bellow link StroreProcedure Vs Function

Rate this:

Find 2nd Highest salary from Employee Table.

Many time in interview ,interviewer ask you how to find 2nd or 3rd highest salary here is a answer for this query. Find nth highest salary

Rate this:

SQL SERVER – ACID (Atomicity, Consistency, Isolation, Durability)

This Article give you general information about ACID. SQL SERVER ACID Properties

Rate this:

SQL SERVER – Insert Multiple Records Using One Insert Statement

This Article give you information about how to insert multiple record using one insert statement with the use of UNION ALL. SQL SERVER inser multiple record

Rate this:

Create Dabase and Tables in SQL Server

This article will give you the basic information how to create database and table in SQL Server. Creating New Databse and Data Storage

Rate this:

OrderBy and GroupBy Clause

OrderBy Groupby Clause

Rate this:

Database Table Relations

Database Table Relations

Rate this:

Clustered and Non-Clustered Index in SQL 2005

Clustered and Non

Rate this:

SQL 2005 Data Types

This Article will give you basic information about Data Types used in sql. SQL 2005 Data Types

Rate this:

Categories

Blog Stats

  • 3,414 Visited

Archives