SQL Programmers Blog


  

Need help with Microsoft SQL Server? Ask our Experts, or simply Email your query.

About Sql Server Programmers

Our clients can be found both locally in the Chicagoland area and throughout the country. We have over 18 years of experience and are extremely proud of our track record of successfully assisting hundreds of our clients to improve their productivity while focusing on cost.

Microsoft Certified Partner

  

SQL Server Programmers Blog

Author: host Created: 11/20/2009 2:57 PM
A weblog containing tips and advice on Microsoft SQL Server.

 In order to reuse or simplify part of code, it’s common to break down your stored procedure into multiple smaller stored procedures and call them as nested stored procedures.  In most of the cases, your original stored procedure affects the content of the database. In order to make sure that the database is still consistent in case something unexpected occurs, the best solution is to use transactions and proper error handling.

Read More »

With SQL Server 2012 currently available for download as a Release Candidate and an official launch coming early this year, now is a better time than ever to start learning about some of the new features it offers.

Read More »

LINQ to SQL is a component found in the .NET Framework version 3.5 and higher. It provides a run-time infrastructure for mapping relational data as objects. This

Read More »

While developing an application, there is a necessary of showing and hiding the particular controls during the run time. Today’s tip is how to show or hide a Jquery controls dynamically.

Read More »

There are different ways split the string based on the delimiter. Here is one of the examples in C# to split the string. Place two textboxes in the form. Rename the first textbox to txtString and second textbox to txtDelimited.

Read More »

There are different methods to load a data in the dropdown control. Some of the common methods that are used are xml, hashtable, arraylist and database.

Read More »

The User Defined functions is routines that can take parameters, perform operations and return the result. There are three types of functions available.

Read More »

Normally we can set a tooltip for column header in the gridview during the mouse over using ColumnHeaderTooltip. If there is a requirement of setting a tooltip to column cells depending on the data, it is somewhat tedious. Here is an example of setting a tooltip to gridview Column during mouse over.

Read More »

In .net applications, printing and previewing the form can be done using PrintDocument class. The PrintDocument component is an object that allows users to send an output to a printer.

Read More »

In an asp.net application while using grid view to display a data there will be a requirement of exporting Grid view data to excel file. The following code will be used to export the grid view data to excel.

Read More »

In the Common language runtime CLR stored procedure will be implemented as public static methods on a class in a Microsoft .Net Framework Assembly. Static Methods can be declared as void or return an integer value.

Read More »

Usually you can able to sort a grid view by clicking the header of the grid. If you want to sort the grid view dynamically, without changing the store procedure of the binding object, the following code will help.

Read More »

The IsNullOrEmpty() is a user defined function in SQL server which is used to check the given variable is null or empty.

Read More »

To pass dynamic value to table valued function we can use the cross apply

Read More »

When developing and testing an application we insert dummy data that is stored in a database.  When the testing phase is complete and the application is ready to go live, the identity column of a table needs to be reset.

Read More »