Thank you for visiting my personal blog. I’m Selim Ahmed, a tech-savvy who loves to learn a new technology every day. Innovation, research, and development is my daily activities. I love to work in a place where I can learn, innovate, and develop new things.Please feel free to reach me on any comments and feedback you have. I would be more than glad to listen and reply.
This is a new feature intorduced in Sql Server 2008. Table-Valued Parameters provides option for the Client Applications to pass multiple rows of Data to Stored Procedure.
Prior to this, if we were needed to pass multiple rows of Data from client application to Sql Server, then we use to model the input data as xml and pass it to the stored procedure and in Stored Procedure convert this xml to a table variable/temporary table.
In this post, we want to discuss an efficient techniques to learn or use Rowversion in SQL Server. Before we get started if you want to know about string case conversion to Title or Proper Case, please go through the […]
Ever marvel why some websites pump out viral put up after viral put up? Or why do some manufacturers have merchandise that flies off the cabinets whereas their competitors fall flat? Or why you couldn’t resist clicking on a hyperlink […]
In this tutorial, I’ll show you how to add a “Scroll to Top” button with CSS and jQuery to your website. Introduction This light-weight approach will enhance usability with a “Scroll to Top” or “Back to Top” button will be […]
In this post we discuss about way to export gridview to excel with advance feature. GridView control is used to display whole table data on web page. In GridView control each column define a filed or title, while each rows […]
The SQL Server MERGE command combines the INSERT, UPDATE, and DELETE commands into a single statement. Here is how to get started with the use of MERGE in SQL Server: Start by identifying the target table that will be used […]
Stored procedures give us many advantages over using SQL scripts and SQL statements that are dynamically created by our windows or web applications. Compilation and storing of the query execution plan: When SQL Server runs a query it calculates the most […]
In this post, we want to discuss a nice function to convert text to title case (Proper Case) in SQL Server. With this function, you can easily convert your desire test to a title case. Before we get started, if […]
This is a simple stored procedure in which you can search through all the data (table wise rows and size) in the SQL Server database. You can see all information like column name, schema name, row count & row size […]
In this article will present how we can write a Dynamic PIVOT query with an example, where we don’t need to mention the PIVOT columns each unique value, and no need to worry if the PIVOT column gets extra unique […]
