Showing posts with label SQL Server. Show all posts
Showing posts with label SQL Server. Show all posts

Friday, September 25, 2015

Attended SQL Server Geeks conference - Aug2015

Introduction

In this post I will share my experience at SQL Server Geeks Annual Summit 2015. Am very eager and excited while attending the Asia's first SQL Server Geeks conference by 27Aug2015 to 29Aug2015 at Bangalore NIMHAUNS convention centre. The three day session was really amazing and excellent. My previous post Improve IIS Performance by effective ways.

SQL sessions

The first day the session started with the keynote by Rengarajan at Hydra hall, was simply superb continue to that I have attended the all the major sessions Power BI, SQL server 2016 new innovations, Working with Streaming Data with streamsight, Column store Index, Advanced SQL 2014. The speaker's are all explained the concepts very well. The person I admired in between the sessions in Amit Bansal. The person who organised and successfuly conducted the conference. He is a dynamic person and providing solution to the situations.

Tuesday, May 26, 2015

Difference between stored procedure and user defined functions

Introduction

In this post I will explain the difference between SQL Stored procedure and functions. My previous post Send email to multiple receipent in asp.net.

Stored Procedure

In our projects we are frequently using the stored procedures and functions.Here I will explain the difference and example.Stored Procedures are set of executable statement which are already pre-compiled and stored in SQL server.Stored procedures no need to return output.We cannot use Stored Procedures in DML statements like (insert/update/delete.In Stored Procedures we can call functions and Stored Procedures inline.Stored Procedures cannot be used in SQL statements like where/having/select section.We can use try/catch block for error handling in stored procedures.

Monday, January 19, 2015

Difference between union and union all in sql server

Introduction

In this post I will explain the difference between union and union all in SQL server table. My previous post Bulk update in sql server table columns using joins , SQL Query to find Nth Highest or Lowest salary of an employee table.

Explanation

Usually Union means it will return the common unique things from two different entities.In SQL server Union and Union All key words are used to retrieve the similar data between two tables in SQL select query, the major thing the tables must have the same column names and same data type.

Saturday, January 17, 2015

Bulk update in sql server table columns using joins

Introduction

In this post I will explain how to update bulk columns in SQL server table. My previous post Javascript PAN Number validation in Asp.net Textbox onkeypress event, SQL Query to find Nth Highest or Lowest salary of an employee table.

Explanation

Sometimes we may need to update some columns in a table from another related tables.So here am using joins for update the columns in a table.In stored procedures it will be very useful and this will avoid cursor looping for bulk updates.It will reduce the execution timing.

Saturday, December 6, 2014

3-Tier Architecture in ASP.Net C# with step by step example

Introduction

In this post we will learn how to implement the three tier architecture in our application using Asp.Net c#. My previous post Highlight Asp.net gridview row color on mouseover using javascript and css

Explanation

Many interviews we faced the question whether you used 3-tier architecture in your application.Because it is mandatory to know the 3-tier architecture for developing a project. Three tier architecture is a separation of our application into multiple portion which is called as a layer.So we have to understand about the layer in 3-tier architecture.

Saturday, November 29, 2014

Highlight Asp.net gridview row color on mouseover using javascript and css

Introduction

In this post I will explain how to highlight gridview row color using javascript and CSS. My previous post Email id validation using javascript in Asp.net.Gridview in asp.Net c#.

Explanation

Asp.Net Gridview control is an adjustable and adaptable control which is used to show bulk information on a column and row basis.As we all know Gridview control will rendered as a table. Even though gridview control is having many features but it has missed some client based attractive things like highlighting gridview control row color. But we can achieve highlighting row in gridview using the below given code. Highlighting a Asp.Net gridview control row is more than just to make it looks good. It serves to distinguish and concentrate on a specific row, since the Gridview shows numerous lines of information at once.

Tuesday, November 18, 2014

SQL Query to find Nth Highest or Lowest salary of an employee table

Introduction

In this post I will explain how to find Nth Highest or Lowest salary of Employee.

Description

Here i will explain how to find Nth Highest or Lowest salary of Employee in Asp.Net.

In many interviews, frequently asking question is how to find Nth Highest or Lowest salary of Employee. Many ways are there to achieve this. Here i will explain some types.

Before that, First create a table EmployeeWage with the following columns. EmployeeID, EmployeeName, EmployeeSalary.

Followers