SQL Server Programmers Blog

SQL Server Programmers Blog A weblog containing tips and advice on Microsoft SQL Server. http://www.sql-programmers.com/Blog/tabid/153/BlogId/1/Default.aspx en-US expert@sql-programmers.com info@alligatortek.com Tue, 07 Feb 2012 22:03:11 GMT Tue, 07 Feb 2012 22:03:11 GMT http://backend.userland.com/rss Blog RSS Generator Version 3.5.1.19887 Nested Stored Procedures – Problems with Transaction count <p> 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.<span style="mso-spacerun:yes"> </span>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.</p><a href=http://www.sql-programmers.com/Blog/tabid/153/EntryId/77/Nested-Stored-Procedures-Problems-with-Transaction-count.aspx>More...</a> http://www.sql-programmers.com/Blog/tabid/153/EntryId/77/Nested-Stored-Procedures-Problems-with-Transaction-count.aspx expert@sql-programmers.com http://www.sql-programmers.com/Blog/tabid/153/EntryId/77/Nested-Stored-Procedures-Problems-with-Transaction-count.aspx#Comments http://www.sql-programmers.com/Blog/tabid/153/EntryId/77/Nested-Stored-Procedures-Problems-with-Transaction-count.aspx Fri, 03 Feb 2012 15:53:00 GMT 0 http://www.sql-programmers.com/DesktopModules/Blog/Trackback.aspx?id=77 SQL Server 2012 – Pagination with ORDER BY enhancements <p>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.</p><a href=http://www.sql-programmers.com/Blog/tabid/153/EntryId/76/SQL-Server-2012-Pagination-with-ORDER-BY-enhancements.aspx>More...</a> http://www.sql-programmers.com/Blog/tabid/153/EntryId/76/SQL-Server-2012-Pagination-with-ORDER-BY-enhancements.aspx expert@sql-programmers.com http://www.sql-programmers.com/Blog/tabid/153/EntryId/76/SQL-Server-2012-Pagination-with-ORDER-BY-enhancements.aspx#Comments http://www.sql-programmers.com/Blog/tabid/153/EntryId/76/SQL-Server-2012-Pagination-with-ORDER-BY-enhancements.aspx Wed, 01 Feb 2012 22:01:00 GMT 0 http://www.sql-programmers.com/DesktopModules/Blog/Trackback.aspx?id=76 Part I: Intro to LINQ to SQL <p>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</p><a href=http://www.sql-programmers.com/Blog/tabid/153/EntryId/75/Part-I-Intro-to-LINQ-to-SQL.aspx>More...</a> http://www.sql-programmers.com/Blog/tabid/153/EntryId/75/Part-I-Intro-to-LINQ-to-SQL.aspx expert@sql-programmers.com http://www.sql-programmers.com/Blog/tabid/153/EntryId/75/Part-I-Intro-to-LINQ-to-SQL.aspx#Comments http://www.sql-programmers.com/Blog/tabid/153/EntryId/75/Part-I-Intro-to-LINQ-to-SQL.aspx Wed, 01 Feb 2012 20:33:00 GMT 0 http://www.sql-programmers.com/DesktopModules/Blog/Trackback.aspx?id=75 Hide/Show Jquery Table controls Dynamically <p>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.</p><a href=http://www.sql-programmers.com/Blog/tabid/153/EntryId/74/Hide-Show-Jquery-Table-controls-Dynamically.aspx>More...</a> http://www.sql-programmers.com/Blog/tabid/153/EntryId/74/Hide-Show-Jquery-Table-controls-Dynamically.aspx .NET http://www.sql-programmers.com/Blog/tabid/153/EntryId/74/Hide-Show-Jquery-Table-controls-Dynamically.aspx#Comments http://www.sql-programmers.com/Blog/tabid/153/EntryId/74/Hide-Show-Jquery-Table-controls-Dynamically.aspx Fri, 13 Jan 2012 07:29:00 GMT 0 http://www.sql-programmers.com/DesktopModules/Blog/Trackback.aspx?id=74 String Split <p>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.</p><a href=http://www.sql-programmers.com/Blog/tabid/153/EntryId/73/String-Split.aspx>More...</a> http://www.sql-programmers.com/Blog/tabid/153/EntryId/73/String-Split.aspx .NET http://www.sql-programmers.com/Blog/tabid/153/EntryId/73/String-Split.aspx#Comments http://www.sql-programmers.com/Blog/tabid/153/EntryId/73/String-Split.aspx Tue, 10 Jan 2012 07:01:00 GMT 0 http://www.sql-programmers.com/DesktopModules/Blog/Trackback.aspx?id=73 Methods of Populating data to Dropdown Control <p>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.</p><a href=http://www.sql-programmers.com/Blog/tabid/153/EntryId/72/Methods-of-Populating-data-to-Dropdown-Control.aspx>More...</a> http://www.sql-programmers.com/Blog/tabid/153/EntryId/72/Methods-of-Populating-data-to-Dropdown-Control.aspx .NET http://www.sql-programmers.com/Blog/tabid/153/EntryId/72/Methods-of-Populating-data-to-Dropdown-Control.aspx#Comments http://www.sql-programmers.com/Blog/tabid/153/EntryId/72/Methods-of-Populating-data-to-Dropdown-Control.aspx Wed, 04 Jan 2012 11:55:00 GMT 0 http://www.sql-programmers.com/DesktopModules/Blog/Trackback.aspx?id=72 CLR User Defined Functions <p>The User Defined functions is routines that can take parameters, perform operations and return the result. There are three types of functions available.</p><a href=http://www.sql-programmers.com/Blog/tabid/153/EntryId/71/CLR-User-Defined-Functions.aspx>More...</a> http://www.sql-programmers.com/Blog/tabid/153/EntryId/71/CLR-User-Defined-Functions.aspx expert@sql-programmers.com http://www.sql-programmers.com/Blog/tabid/153/EntryId/71/CLR-User-Defined-Functions.aspx#Comments http://www.sql-programmers.com/Blog/tabid/153/EntryId/71/CLR-User-Defined-Functions.aspx Mon, 02 Jan 2012 09:39:00 GMT 0 http://www.sql-programmers.com/DesktopModules/Blog/Trackback.aspx?id=71 Set tool tip to the Gridview column <p>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.</p><a href=http://www.sql-programmers.com/Blog/tabid/153/EntryId/70/Set-tool-tip-to-the-Gridview-column.aspx>More...</a> http://www.sql-programmers.com/Blog/tabid/153/EntryId/70/Set-tool-tip-to-the-Gridview-column.aspx expert@sql-programmers.com http://www.sql-programmers.com/Blog/tabid/153/EntryId/70/Set-tool-tip-to-the-Gridview-column.aspx#Comments http://www.sql-programmers.com/Blog/tabid/153/EntryId/70/Set-tool-tip-to-the-Gridview-column.aspx Tue, 27 Dec 2011 06:02:00 GMT 1 http://www.sql-programmers.com/DesktopModules/Blog/Trackback.aspx?id=70 Printing in Asp.net <p>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.</p><a href=http://www.sql-programmers.com/Blog/tabid/153/EntryId/69/Printing-in-Asp-net.aspx>More...</a> http://www.sql-programmers.com/Blog/tabid/153/EntryId/69/Printing-in-Asp-net.aspx expert@sql-programmers.com http://www.sql-programmers.com/Blog/tabid/153/EntryId/69/Printing-in-Asp-net.aspx#Comments http://www.sql-programmers.com/Blog/tabid/153/EntryId/69/Printing-in-Asp-net.aspx Mon, 26 Dec 2011 06:41:00 GMT 0 http://www.sql-programmers.com/DesktopModules/Blog/Trackback.aspx?id=69 Export GridView to Excel <p>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.</p><a href=http://www.sql-programmers.com/Blog/tabid/153/EntryId/68/Export-GridView-to-Excel.aspx>More...</a> http://www.sql-programmers.com/Blog/tabid/153/EntryId/68/Export-GridView-to-Excel.aspx .NET http://www.sql-programmers.com/Blog/tabid/153/EntryId/68/Export-GridView-to-Excel.aspx#Comments http://www.sql-programmers.com/Blog/tabid/153/EntryId/68/Export-GridView-to-Excel.aspx Wed, 21 Dec 2011 06:48:00 GMT 0 http://www.sql-programmers.com/DesktopModules/Blog/Trackback.aspx?id=68 CLR Stored Procedure <p>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.</p><a href=http://www.sql-programmers.com/Blog/tabid/153/EntryId/67/CLR-Stored-Procedure.aspx>More...</a> http://www.sql-programmers.com/Blog/tabid/153/EntryId/67/CLR-Stored-Procedure.aspx expert@sql-programmers.com http://www.sql-programmers.com/Blog/tabid/153/EntryId/67/CLR-Stored-Procedure.aspx#Comments http://www.sql-programmers.com/Blog/tabid/153/EntryId/67/CLR-Stored-Procedure.aspx Tue, 20 Dec 2011 10:02:00 GMT 0 http://www.sql-programmers.com/DesktopModules/Blog/Trackback.aspx?id=67 Sorting grid view dynamically <p>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.</p><a href=http://www.sql-programmers.com/Blog/tabid/153/EntryId/66/Sorting-grid-view-dynamically.aspx>More...</a> http://www.sql-programmers.com/Blog/tabid/153/EntryId/66/Sorting-grid-view-dynamically.aspx .NET http://www.sql-programmers.com/Blog/tabid/153/EntryId/66/Sorting-grid-view-dynamically.aspx#Comments http://www.sql-programmers.com/Blog/tabid/153/EntryId/66/Sorting-grid-view-dynamically.aspx Wed, 14 Dec 2011 10:07:00 GMT 0 http://www.sql-programmers.com/DesktopModules/Blog/Trackback.aspx?id=66 IsNullOrEmpty – A user Defined Function in SQL server <p>The IsNullOrEmpty() is a user defined function in SQL server which is used to check the given variable is null or empty. </p><a href=http://www.sql-programmers.com/Blog/tabid/153/EntryId/65/IsNullOrEmpty-A-user-Defined-Function-in-SQL-server.aspx>More...</a> http://www.sql-programmers.com/Blog/tabid/153/EntryId/65/IsNullOrEmpty-A-user-Defined-Function-in-SQL-server.aspx SQL Server expert@sql-programmers.com http://www.sql-programmers.com/Blog/tabid/153/EntryId/65/IsNullOrEmpty-A-user-Defined-Function-in-SQL-server.aspx#Comments http://www.sql-programmers.com/Blog/tabid/153/EntryId/65/IsNullOrEmpty-A-user-Defined-Function-in-SQL-server.aspx Tue, 13 Dec 2011 04:34:00 GMT 0 http://www.sql-programmers.com/DesktopModules/Blog/Trackback.aspx?id=65 Table valued function using cross apply <p>To pass dynamic value to table valued function we can use the cross apply</p><a href=http://www.sql-programmers.com/Blog/tabid/153/EntryId/64/Table-valued-function-using-cross-apply.aspx>More...</a> http://www.sql-programmers.com/Blog/tabid/153/EntryId/64/Table-valued-function-using-cross-apply.aspx SQL Server expert@sql-programmers.com http://www.sql-programmers.com/Blog/tabid/153/EntryId/64/Table-valued-function-using-cross-apply.aspx#Comments http://www.sql-programmers.com/Blog/tabid/153/EntryId/64/Table-valued-function-using-cross-apply.aspx Mon, 12 Dec 2011 10:28:00 GMT 0 http://www.sql-programmers.com/DesktopModules/Blog/Trackback.aspx?id=64 Reset the Identity column <p></p> <p style="margin-bottom:0in;margin-bottom:.0001pt" class="MsoNormal">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. </p><a href=http://www.sql-programmers.com/Blog/tabid/153/EntryId/63/Reset-the-Identity-column.aspx>More...</a> http://www.sql-programmers.com/Blog/tabid/153/EntryId/63/Reset-the-Identity-column.aspx expert@sql-programmers.com http://www.sql-programmers.com/Blog/tabid/153/EntryId/63/Reset-the-Identity-column.aspx#Comments http://www.sql-programmers.com/Blog/tabid/153/EntryId/63/Reset-the-Identity-column.aspx Wed, 07 Dec 2011 08:19:00 GMT 0 http://www.sql-programmers.com/DesktopModules/Blog/Trackback.aspx?id=63