-
Follow
Following
Already have a WordPress.com account? Log in now.
This Article give you some tips to increase store procedure performance. improve performance of store procedure
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
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
This Article give you general information about ACID. SQL SERVER ACID Properties
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
This article will give you the basic information how to create database and table in SQL Server. Creating New Databse and Data Storage
OrderBy Groupby Clause
Database Table Relations
Clustered and Non
This Article will give you basic information about Data Types used in sql. SQL 2005 Data Types
Ankit Nandekar 