Articles by Wendelius (Articles: 29, Technical Blogs: 2, Tip/Tricks: 38, Reference: 1)

Articles: 29, Technical Blogs: 2, Tip/Tricks: 38, Reference: 1

• Articles
• Technical Blogs
• Tips and Tricks
• Reference Articles
• Projects

Average article rating: 4.89

Database Development
SQL Server	How to pass multiple records to a Stored Procedure 2 Dec 2008   Updated: 2 Dec 2008   Rating: 4.92/5    Votes: 31   Popularity: 7.11 Licence: CPOL    Views: 135,397     Bookmarked: 90   Downloaded: 1,152 Please Sign up or sign in to vote. How to pass multiple records to a Stored Procedure in a single roundtrip.
	Physical location of a row in SQL Server 20 Feb 2011   Updated: 25 Feb 2011   Rating: 4.85/5    Votes: 18   Popularity: 6.08 Licence: CPOL    Views: 91,276     Bookmarked: 33   Downloaded: 227 Please Sign up or sign in to vote. This article describes the pseudo column to identify the unique physical location of a single row.
	Custom Aggregates in SQL Server 17 Mar 2011   Updated: 26 Mar 2011   Rating: 4.95/5    Votes: 24   Popularity: 6.84 Licence: CPOL    Views: 87,464     Bookmarked: 41   Downloaded: 567 Please Sign up or sign in to vote. SQL Server not having the aggregates you need? Why not build your own.
	Using Table-Valued Functions in SQL Server 10 Mar 2011   Updated: 6 Aug 2011   Rating: 4.92/5    Votes: 51   Popularity: 8.27 Licence: CPOL    Views: 580,204     Bookmarked: 65   Downloaded: 1,223 Please Sign up or sign in to vote. This article shows few examples for using Table-Valued Functions.
	Mimicking null-safe equal to operator in SQL Server 19 Sep 2011   Updated: 20 Sep 2011   Rating: 0.00/5    Votes: 0   Popularity: 0.00 Licence: CPOL    Views: 34,842     Bookmarked: 4   Downloaded: 91 Please Sign up or sign in to vote. This article describes how to mimic the null-safe equal to operator using an UDF in SQL Server.
	Executing multiple SQL statements as one against SQL Server 27 Dec 2011   Updated: 27 Dec 2011   Rating: 4.91/5    Votes: 16   Popularity: 5.78 Licence: CPOL    Views: 267,124     Bookmarked: 27   Downloaded: 1,335 Please Sign up or sign in to vote. This article describes a few techniques for how multiple SQL statements can be executed with one SqlCommand.
	Control trigger logic based on user 20 May 2012   Updated: 20 May 2012   Rating: 4.90/5    Votes: 7   Popularity: 4.14 Licence: CPOL    Views: 18,800     Bookmarked: 10   Downloaded: 117 Please Sign up or sign in to vote. This article describes a mechanism how trigger actions bypassed based on database user information
	About transaction log and its truncation in SQL Server 7 May 2012   Updated: 9 Aug 2012   Rating: 4.55/5    Votes: 8   Popularity: 4.11 Licence: CPOL    Views: 71,431     Bookmarked: 25   Downloaded: 0 Please Sign up or sign in to vote. Article describes basic information about transaction log behavior and truncation of the log.
	Calculating simple running totals in SQL Server 15 Dec 2011   Updated: 12 Dec 2014   Rating: 4.90/5    Votes: 40   Popularity: 7.86 Licence: CPOL    Views: 397,245     Bookmarked: 50   Downloaded: 1,000 Please Sign up or sign in to vote. Some simple scenarios to calculate running totals in SQL Server.
	Logging from inside a transaction 19 Jan 2015   Updated: 21 Feb 2015   Rating: 4.94/5    Votes: 30   Popularity: 7.23 Licence: CPOL    Views: 49,730     Bookmarked: 39   Downloaded: 262 Please Sign up or sign in to vote. How to log information into a table from inside a transaction, even if the transaction is rolled back.
	What should be considered when NOLOCK hint is used 11 Feb 2011   Updated: 12 Jul 2016   Rating: 4.97/5    Votes: 17   Popularity: 6.11 Licence: CPOL    Views: 51,242     Bookmarked: 16   Downloaded: 61 Please Sign up or sign in to vote. When considering to use NOLOCK hint, there are a few things that should be kept in mind.
	How to store and fetch binary data into a file stream column 3 Jan 2009   Updated: 11 Dec 2016   Rating: 4.87/5    Votes: 44   Popularity: 7.95 Licence: CPOL    Views: 215,391     Bookmarked: 91   Downloaded: 5,234 Please Sign up or sign in to vote. Desribes how to store and fetch binary data to a filestream column compared to a varbinary column.
	What You See Is What You Update 2 Apr 2017   Updated: 2 Apr 2017   Rating: 4.95/5    Votes: 4   Popularity: 2.98 Licence: CPOL    Views: 9,401     Bookmarked: 0   Downloaded: 91 Please Sign up or sign in to vote. This is an alternative for "What You See Is What You Update"
	How to Prevent When a Transaction Accidentally Overwrites Modified Data 23 Mar 2017   Updated: 30 Apr 2017   Rating: 4.91/5    Votes: 15   Popularity: 5.62 Licence: CPOL    Views: 22,121     Bookmarked: 16   Downloaded: 517 Please Sign up or sign in to vote. This article explains the problem, when another transaction (concurrent or not) accidentally overwrites previously modified data and how to prevent this from happening.
	Properly executing database operations 19 Aug 2015   Updated: 10 Jul 2017   Rating: 4.91/5    Votes: 40   Popularity: 7.70 Licence: CPOL    Views: 50,087     Bookmarked: 60   Downloaded: 876 Please Sign up or sign in to vote. This article discusses some basic requirements for successful database operations such as error handling, use of parameters and transactions.
	Custom String Split Function with Few Enhancements 26 Dec 2018   Updated: 26 Dec 2018   Rating: 5.00/5    Votes: 4   Popularity: 3.01 Licence: CPOL    Views: 7,003     Bookmarked: 4   Downloaded: 110 Please Sign up or sign in to vote. This article shows a custom SQL Server function to split a string delimited by a character or a set of characters. The function also contains a few handy enhancements.
	Restricting Logon to SQL Server 13 Oct 2016   Updated: 18 Oct 2016   Rating: 5.00/5    Votes: 4   Popularity: 3.01 Licence: CPOL    Views: 16,743     Bookmarked: 12   Downloaded: 394 Please Sign up or sign in to vote. Discussion and a few approaches to restrict logging into SQL Server using a logon trigger or into a database by using a specific procedure
	Writing into a File from Database 2 Oct 2016   Updated: 4 Nov 2016   Rating: 5.00/5    Votes: 10   Popularity: 5.00 Licence: CPOL    Views: 22,782     Bookmarked: 20   Downloaded: 552 Please Sign up or sign in to vote. Few CLR procedure concepts to write into a file from SQL Server database
	Data Versioning in SQL Server using Snapshot a.k.a. Row Versions 11 Oct 2008   Updated: 7 Feb 2018   Rating: 4.34/5    Votes: 23   Popularity: 5.91 Licence: CPOL    Views: 64,843     Bookmarked: 35   Downloaded: 198 Please Sign up or sign in to vote. Enable SQL Server internal row versioning to achieve greater concurrency in OLTP systems using Snapshots
Desktop Programming
ATL	SQL Server: Query to find upcoming birthdays for the current week 13 Sep 2012   Updated: 13 Sep 2012   Rating: 5.00/5    Votes: 10   Popularity: 5.00 Licence: CPOL    Views: 71,668     Bookmarked: 11   Downloaded: 0 Please Sign up or sign in to vote. This is an alternative for "SQL Server: Query to find upcoming birthdays for the current week"
WPF	Directory size browser 10 Feb 2015   Updated: 17 Feb 2015   Rating: 4.92/5    Votes: 47   Popularity: 8.13 Licence: CPOL    Views: 62,143     Bookmarked: 94   Downloaded: 3,416 Please Sign up or sign in to vote. This article shows how to build a responsive directory size browser application utilizing threading. The source code includes both C# and VB.Net
Programming Languages
F#	Simple trend calculation 22 May 2016   Updated: 15 Aug 2017   Rating: 4.97/5    Votes: 14   Popularity: 5.53 Licence: CPOL    Views: 53,879     Bookmarked: 31   Downloaded: 1,966 Please Sign up or sign in to vote. Simple linear trend calculation with different types for X values implemented in C#, VB, and F#
SQL	Custom Aggregates in Oracle 19 Mar 2011   Updated: 19 Mar 2011   Rating: 4.91/5    Votes: 8   Popularity: 4.43 Licence: CPOL    Views: 36,293     Bookmarked: 10   Downloaded: 151 Please Sign up or sign in to vote. How to create custom aggregates in Oracle using PL/SQL
	Installing Oracle 11g XE (Express Edition) 14 Sep 2011   Updated: 14 Sep 2011   Rating: 4.72/5    Votes: 11   Popularity: 4.92 Licence: CPOL    Views: 190,369     Bookmarked: 24   Downloaded: 0 Please Sign up or sign in to vote. This article briefly describes basic information about installing the Oracle 11g XE database on Windows and few Developer tools such as SQL Developer
	Mimicking SQL Server identity column in Oracle 8 Jan 2012   Updated: 8 Jan 2012   Rating: 4.94/5    Votes: 5   Popularity: 3.45 Licence: CPOL    Views: 49,062     Bookmarked: 7   Downloaded: 312 Please Sign up or sign in to vote. This article describes how to use a sequence to mimic the SQL Server identity column in Oracle.
	Examples for Creating Oracle Functions 13 Mar 2011   Updated: 1 Apr 2012   Rating: 4.75/5    Votes: 11   Popularity: 4.75 Licence: CPOL    Views: 163,604     Bookmarked: 13   Downloaded: 1,011 Please Sign up or sign in to vote. The article starts with building a simple toolkit package using basic PL/SQL but also covers some more advanced techniques, such as pipeline.
	Logging information in Oracle 30 Apr 2012   Updated: 30 Apr 2012   Rating: 5.00/5    Votes: 5   Popularity: 3.49 Licence: CPOL    Views: 35,717     Bookmarked: 8   Downloaded: 286 Please Sign up or sign in to vote. This article describes techniques such as autonomous transactions and action information that can be used when logging information about operations in Oracle database.
Visual Basic	Creating basic Excel workbook with Open XML 22 Apr 2012   Updated: 5 May 2012   Rating: 4.93/5    Votes: 48   Popularity: 8.24 Licence: CPOL    Views: 277,535     Bookmarked: 110   Downloaded: 20,273 Please Sign up or sign in to vote. This article describes how to create a basic Excel workbook using Open XML.
	Encrypting a dataset using AES, including compression 9 Sep 2012   Updated: 21 Aug 2015   Rating: 4.98/5    Votes: 49   Popularity: 8.37 Licence: CPOL    Views: 114,967     Bookmarked: 127   Downloaded: 4,808 Please Sign up or sign in to vote. Article describes how to encrypt a dataset using AES. Optionally the dataset is compressed before the encryption.

Average blogs rating: 4.72

Database Development
SQL Server	Struggling with System.IO.Packaging when Creating a CLR Procedure [Technical Blog] 7 Oct 2012   Updated: 19 Oct 2012   Rating: 0.00/5    Votes: 0   Popularity: 0.00 Licence: CPOL    Views: 14,160     Bookmarked: 2   Downloaded: 0 Please Sign up or sign in to vote. System.IO.Packaging namespace in WindowsBase may cause problems when trying to create a CLR procedure.
Programming Languages
SQL	Let’s SELECT Errors... [Technical Blog] 23 Aug 2015   Updated: 25 Aug 2015   Rating: 4.72/5    Votes: 6   Popularity: 3.68 Licence: CPOL    Views: 17,520     Bookmarked: 10   Downloaded: 0 Please Sign up or sign in to vote. This post discusses about how to add checks into a SQL statement in order to prevent wrong results in case of possible future changes.

Average tips rating: 4.84

Database Development
SQL Server	How to remove duplicate rows in SQL Server 2008 when no key is present [Tip/Trick] 20 Feb 2011   Updated: 20 Feb 2011   Rating: 4.95/5    Votes: 12   Popularity: 5.34 Licence: CPOL    Views: 104,317     Bookmarked: 22   Downloaded: 0 Please Sign up or sign in to vote. This tip describes how to delete duplicate rows from a table that doesn't have a key.
	List SQL Server Table Column Name as Rows [Tip/Trick] 5 May 2012   Updated: 6 May 2012   Rating: 5.00/5    Votes: 1   Popularity: 0.00 Licence: CPOL    Views: 24,691     Bookmarked: 4   Downloaded: 0 Please Sign up or sign in to vote. This is an alternative for "List SQL Server table column name as rows".
	Applying Running Total to a Result set [Tip/Trick] 14 May 2012   Updated: 14 May 2012   Rating: 5.00/5    Votes: 1   Popularity: 0.00 Licence: CPOL    Views: 9,400     Bookmarked: 3   Downloaded: 33 Please Sign up or sign in to vote. This is an alternative for "Applying Running Total to a Result set"
	How to Guarantee a Fixed Amount of Rows in a Table [Tip/Trick] 19 May 2012   Updated: 19 May 2012   Rating: 0.00/5    Votes: 0   Popularity: 0.00 Licence: CPOL    Views: 6,960     Bookmarked: 2   Downloaded: 24 Please Sign up or sign in to vote. This tip describes how to guarantee a fixed amount of rows in a table by using triggers
	How to remove duplicate rows in SQL Server 2005 when no key is present [Tip/Trick] 20 Feb 2011   Updated: 20 Dec 2012   Rating: 5.00/5    Votes: 6   Popularity: 3.89 Licence: CPOL    Views: 32,730     Bookmarked: 16   Downloaded: 0 Please Sign up or sign in to vote. This tip describes how to delete duplicate rows from a table that doesn't have a key.
	Calculate aggregates for dynamic columns using UNPIVOT [Tip/Trick] 27 Dec 2012   Updated: 17 Jan 2013   Rating: 5.00/5    Votes: 1   Popularity: 0.00 Licence: CPOL    Views: 29,878     Bookmarked: 5   Downloaded: 48 Please Sign up or sign in to vote. This tip describes how to calculate an aggregate for dynamically defined columns using UNPIVOT clause.
	Check if a number is a power of 2 with Sql Server 2012 [Tip/Trick] 18 Dec 2012   Updated: 19 Jan 2013   Rating: 5.00/5    Votes: 4   Popularity: 3.01 Licence: CPOL    Views: 37,283     Bookmarked: 5   Downloaded: 38 Please Sign up or sign in to vote. This tip shows how to get rows from a table where a field contains a number that is a power of 2 using LOG function.
	Generating a set of random numbers in SQL Server [Tip/Trick] 26 Aug 2014   Updated: 26 Aug 2014   Rating: 5.00/5    Votes: 2   Popularity: 1.51 Licence: CPOL    Views: 51,977     Bookmarked: 7   Downloaded: 190 Please Sign up or sign in to vote. Generate a set of random numbers by using CTE
	Fibonacci sequence using SQL Server CTE [Tip/Trick] 26 Aug 2014   Updated: 28 Aug 2014   Rating: 4.83/5    Votes: 10   Popularity: 4.83 Licence: CPOL    Views: 41,370     Bookmarked: 7   Downloaded: 104 Please Sign up or sign in to vote. Generate Fibonacci numbers using CTE
	How to fetch data from the previous or next rows in the resultset [Tip/Trick] 27 Jul 2011   Updated: 31 Aug 2014   Rating: 5.00/5    Votes: 4   Popularity: 3.01 Licence: CPOL    Views: 27,592     Bookmarked: 11   Downloaded: 70 Please Sign up or sign in to vote. This tip demonstrates the use of LAG and LEAD functions in SQL Server.
	To cause an error when updating a row with non-existing lookup reference [Tip/Trick] 10 Sep 2014   Updated: 10 Sep 2014   Rating: 5.00/5    Votes: 1   Popularity: 0.00 Licence: CPOL    Views: 8,480     Bookmarked: 4   Downloaded: 24 Please Sign up or sign in to vote. The tip shows how to intentionally cause an error in a situation where a non-existing reference would be updated.
	First and Last Occurrence of Day of Week Within a Month using SQL [Tip/Trick] 13 Sep 2014   Updated: 13 Sep 2014   Rating: 5.00/5    Votes: 1   Popularity: 0.00 Licence: CPOL    Views: 12,302     Bookmarked: 2   Downloaded: 58 Please Sign up or sign in to vote. This tip describes how to fetch the first or the last occurrence of given day of week within a month by using a single SQL statement.
	Generating Desired Amount of Rows in SQL using CTE [Tip/Trick] 26 Aug 2014   Updated: 16 Sep 2014   Rating: 4.64/5    Votes: 5   Popularity: 3.24 Licence: CPOL    Views: 59,353     Bookmarked: 10   Downloaded: 93 Please Sign up or sign in to vote. How to generate desired amount of rows in SQL Server using CTE
	Difference Between Two datetime Values in Hours, Minutes, etc. [Tip/Trick] 18 Sep 2015   Updated: 18 Sep 2015   Rating: 5.00/5    Votes: 7   Popularity: 4.23 Licence: CPOL    Views: 99,597     Bookmarked: 6   Downloaded: 197 Please Sign up or sign in to vote. This tip shows how to calculate a difference between two datetime values and to express the difference in years, days, hours, minutes and so on.
	TrimChar to Remove Desired Character [Tip/Trick] 26 Sep 2016   Updated: 30 Sep 2016   Rating: 5.00/5    Votes: 4   Popularity: 3.01 Licence: CPOL    Views: 10,580     Bookmarked: 3   Downloaded: 0 Please Sign up or sign in to vote. TrimChar function which removes occurences of the desired character from both ends of a string.
	How to Establish Dedicated Admin Connection (DAC) to SQL Server [Tip/Trick] 4 Oct 2016   Updated: 4 Oct 2016   Rating: 4.56/5    Votes: 6   Popularity: 3.54 Licence: CPOL    Views: 24,351     Bookmarked: 2   Downloaded: 0 Please Sign up or sign in to vote. Few tips for connecting to an SQL Server instance using DAC
	How to Format Repeating Values in SQL Result Set [Tip/Trick] 13 Oct 2016   Updated: 13 Oct 2016   Rating: 5.00/5    Votes: 8   Popularity: 4.52 Licence: CPOL    Views: 12,874     Bookmarked: 6   Downloaded: 36 Please Sign up or sign in to vote. A little tip on how to format repeating values in SQL output using LAG function
	Selecting Valid Records [Tip/Trick] 7 Dec 2016   Updated: 7 Dec 2016   Rating: 5.00/5    Votes: 4   Popularity: 3.01 Licence: CPOL    Views: 9,990     Bookmarked: 2   Downloaded: 29 Please Sign up or sign in to vote. This tip demonstrates how to select valid records from a table that contains validity date limits.
	Types Don't Match between the Anchor and the Recursive Part in Column... [Tip/Trick] 28 Dec 2019   Updated: 28 Dec 2019   Rating: 5.00/5    Votes: 5   Popularity: 3.49 Licence: CPOL    Views: 13,094     Bookmarked: 1   Downloaded: 19 Please Sign up or sign in to vote. How to overcome the error message "Types don't match between the anchor and the recursive part in column..." for varchar columns in a recursive CTE query
	All the jobs in SQL Server [Tip/Trick] 10 Aug 2011   Updated: 10 Aug 2011   Rating: 4.60/5    Votes: 3   Popularity: 2.19 Licence: CPOL    Views: 7,530     Bookmarked: 0   Downloaded: 0 Please Sign up or sign in to vote. Or simply:exec msdb..sp_help_jobsp_help_job (Transact-SQL)[^]
Desktop Programming
Windows Forms	Resolve DesignMode for a User Control [Tip/Trick] 26 Aug 2012   Updated: 26 Aug 2012   Rating: 5.00/5    Votes: 10   Popularity: 4.77 Licence: CPOL    Views: 49,543     Bookmarked: 9   Downloaded: 686 Please Sign up or sign in to vote. The tip shows one way to resolve if a user control is in design mode.
WPF	MessageBox Problem with Large Strings [Tip/Trick] 5 Apr 2021   Updated: 5 Apr 2021   Rating: 4.53/5    Votes: 6   Popularity: 3.52 Licence: CPOL    Views: 5,773     Bookmarked: 6   Downloaded: 72 Please Sign up or sign in to vote. When a string longer that 65536 is shown using a message box, the result might be unexpected.
Oracle
	How to Change Password in Oracle [Tip/Trick] 21 Feb 2011   Updated: 26 Jul 2015   Rating: 4.86/5    Votes: 4   Popularity: 2.92 Licence: CPOL    Views: 17,980     Bookmarked: 4   Downloaded: 0 Please Sign up or sign in to vote. This alternative is created to correct few mistakes in the original tip. Most importantly: Never update system tables.
Programming Languages
C#	Small Utility to Swap Mouse Buttons [Tip/Trick] 29 Feb 2020   Updated: 29 Feb 2020   Rating: 5.00/5    Votes: 4   Popularity: 3.01 Licence: CPOL    Views: 13,800     Bookmarked: 0   Downloaded: 71 Please Sign up or sign in to vote. Toggle mouse button swapping between on and off
	Multiple partial definitions for a class [Tip/Trick] 17 Nov 2012   Updated: 17 Nov 2012   Rating: 0.00/5    Votes: 0   Popularity: 0.00 Licence: CPOL    Views: 8,610     Bookmarked: 7   Downloaded: 52 Please Sign up or sign in to vote. The tip shows an example for using multiple partial classes to define a single class.
	Cumulating values with LINQ [Tip/Trick] 26 Jul 2012   Updated: 26 Jul 2012   Rating: 4.72/5    Votes: 4   Popularity: 2.84 Licence: CPOL    Views: 26,831     Bookmarked: 4   Downloaded: 100 Please Sign up or sign in to vote. This tip describes few examples how ro cumulate values using an extension method with LINQ
	Using enum to define a new enum [Tip/Trick] 20 Jul 2012   Updated: 10 Aug 2012   Rating: 4.64/5    Votes: 10   Popularity: 4.64 Licence: CPOL    Views: 60,846     Bookmarked: 16   Downloaded: 112 Please Sign up or sign in to vote. This tip describes how to use an existing enum to define a new, for example a context specific enum.
	How To Extract Images From An Office Document [Tip/Trick] 26 Jul 2015   Updated: 26 Jul 2015   Rating: 4.60/5    Votes: 3   Popularity: 2.19 Licence: CPOL    Views: 9,051     Bookmarked: 5   Downloaded: 180 Please Sign up or sign in to vote. This tip shows how to extract images from an Office document saved in Office Open XML format.
	Manipulating a string array using a Lambda Expression [Tip/Trick] 7 Nov 2012   Updated: 7 Nov 2012   Rating: 5.00/5    Votes: 1   Popularity: 0.00 Licence: CPOL    Views: 25,903     Bookmarked: 4   Downloaded: 0 Please Sign up or sign in to vote. This is an alternative for "Manipulating a string array using a Lambda Expression"
	Getting publishing information for a ClickOnce deployment [Tip/Trick] 27 Mar 2012   Updated: 27 Mar 2012   Rating: 5.00/5    Votes: 2   Popularity: 1.51 Licence: CPOL    Views: 19,231     Bookmarked: 5   Downloaded: 0 Please Sign up or sign in to vote. This tip describes a way to get publishing information for a ClickOnce deployed application
SQL	How to Guarantee a Fixed Amount of Rows in a Table in Oracle [Tip/Trick] 19 May 2012   Updated: 19 May 2012   Rating: 5.00/5    Votes: 1   Popularity: 0.00 Licence: CPOL    Views: 11,120     Bookmarked: 1   Downloaded: 22 Please Sign up or sign in to vote. This tip describes how to guarantee a fixed amount of rows in a table by using triggers in Oracle.
	Generating desired amount of rows in Oracle using single statement [Tip/Trick] 31 Aug 2014   Updated: 31 Aug 2014   Rating: 5.00/5    Votes: 1   Popularity: 0.00 Licence: CPOL    Views: 16,213     Bookmarked: 1   Downloaded: 35 Please Sign up or sign in to vote. Two ways of generating desired amount of rows in Oracle by using a single SQL statement.
	Fibonacci sequence in Oracle using sinqle SQL statement [Tip/Trick] 5 Sep 2014   Updated: 5 Sep 2014   Rating: 4.20/5    Votes: 2   Popularity: 1.26 Licence: CPOL    Views: 24,683     Bookmarked: 5   Downloaded: 56 Please Sign up or sign in to vote. This tip shows two ways of generating Fibonacci numbers in a single SQL statement
	How to Fetch Data from the Previous or Next Rows in the Resultset [Tip/Trick] 22 Feb 2011   Updated: 26 Jul 2015   Rating: 4.82/5    Votes: 6   Popularity: 3.75 Licence: CPOL    Views: 24,110     Bookmarked: 3   Downloaded: 0 Please Sign up or sign in to vote. This tip demonstrates the use of LAG and LEAD functions in Oracle.
	What’s the Difference between a Full Index Scan and a Fast Full Index Scan in Oracle? [Tip/Trick] 13 Jul 2017   Updated: 13 Jul 2017   Rating: 5.00/5    Votes: 3   Popularity: 2.39 Licence: CPOL    Views: 175,013     Bookmarked: 1   Downloaded: 52 Please Sign up or sign in to vote. This is an alternative for "What’s the Difference between a Full Index Scan and a Fast Full Index Scan in Oracle?"
	Control Maximum Number of Rows in a Table [Tip/Trick] 16 May 2021   Updated: 1 Jun 2021   Rating: 3.43/5    Votes: 3   Popularity: 1.64 Licence: CPOL    Views: 6,030     Bookmarked: 2   Downloaded: 53 Please Sign up or sign in to vote. How to prevent insert for record when maximum number of rows has been reached
Visual Basic	Cumulating values with LINQ [Tip/Trick] 28 Jul 2012   Updated: 27 Jul 2012   Rating: 0.00/5    Votes: 0   Popularity: 0.00 Licence: CPOL    Views: 10,600     Bookmarked: 1   Downloaded: 20 Please Sign up or sign in to vote. This is an alternative for "Cumulating values with LINQ"
	Query Hierarchical DataTable [Tip/Trick] 5 Oct 2015   Updated: 5 Oct 2015   Rating: 4.93/5    Votes: 11   Popularity: 5.13 Licence: CPOL    Views: 19,922     Bookmarked: 20   Downloaded: 567 Please Sign up or sign in to vote. This tip shows one way to query hierarchical data from a DataTable by using an AsTree() method.
	How to connect with different types of DataBase? [Tip/Trick] 25 Nov 2011   Updated: 24 Dec 2011   Rating: 4.73/5    Votes: 6   Popularity: 3.68 Licence: CPOL    Views: 22,921     Bookmarked: 3   Downloaded: 0 Please Sign up or sign in to vote. As a general rule of thumb, I'd suggest browsing http://www.connectionstrings.com/[^] for connection strings against popular data sources.
	Getting publishing information for a ClickOnce deployment [Tip/Trick] 1 Apr 2012   Updated: 1 Apr 2012   Rating: 5.00/5    Votes: 2   Popularity: 1.51 Licence: CPOL    Views: 14,520     Bookmarked: 4   Downloaded: 0 Please Sign up or sign in to vote. This is an alternative for "Getting publishing information for a ClickOnce deployment"

Average reference rating: 4.92

Your Development Tools [Reference] 5 Nov 2013   Updated: 4 Aug 2017   Rating: 4.92/5    Votes: 50   Popularity: 8.27 Licence: CPOL    Views: 277,892     Bookmarked: 213   Downloaded: 0 Please Sign up or sign in to vote. A list of useful development tools edited by members of CodeProject

Average project rating:

No projects have been posted.

Wendelius

Architect

 Europe

Biography provided