Miscellaneous
|
General |
Posted: 29 Feb 2020
Updated: 29 Feb 2020
Views: 11,370
Rating: 5.00/5
Votes: 4
Popularity: 3.01
Licence: The Code Project Open License (CPOL)
Bookmarked: 0
Downloaded: 44
Toggle mouse button swapping between on and off
|
Database
|
General |
Posted: 21 Feb 2011
Updated: 26 Jul 2015
Views: 17,000
Rating: 4.86/5
Votes: 4
Popularity: 2.92
Licence: The Code Project Open License (CPOL)
Bookmarked: 4
Downloaded: 0
This alternative is created to correct few mistakes in the original tip. Most importantly: Never update system tables.
|
Oracle |
Posted: 19 May 2012
Updated: 19 May 2012
Views: 9,930
Rating: 5.00/5
Votes: 1
Popularity: 0.00
Licence: The Code Project Open License (CPOL)
Bookmarked: 1
Downloaded: 22
This tip describes how to guarantee a fixed amount of rows in a table by using triggers in Oracle.
|
|
Posted: 31 Aug 2014
Updated: 31 Aug 2014
Views: 12,812
Rating: 5.00/5
Votes: 1
Popularity: 0.00
Licence: The Code Project Open License (CPOL)
Bookmarked: 1
Downloaded: 33
Two ways of generating desired amount of rows in Oracle by using a single SQL statement.
|
|
Posted: 5 Sep 2014
Updated: 5 Sep 2014
Views: 21,083
Rating: 4.20/5
Votes: 2
Popularity: 1.26
Licence: The Code Project Open License (CPOL)
Bookmarked: 5
Downloaded: 55
This tip shows two ways of generating Fibonacci numbers in a single SQL statement
|
|
Posted: 22 Feb 2011
Updated: 26 Jul 2015
Views: 22,210
Rating: 4.82/5
Votes: 6
Popularity: 3.75
Licence: The Code Project Open License (CPOL)
Bookmarked: 3
Downloaded: 0
This tip demonstrates the use of LAG and LEAD functions in Oracle.
|
|
Posted: 13 Jul 2017
Updated: 13 Jul 2017
Views: 161,253
Rating: 5.00/5
Votes: 3
Popularity: 2.39
Licence: The Code Project Open License (CPOL)
Bookmarked: 1
Downloaded: 48
This is an alternative for "What’s the Difference between a Full Index Scan and a Fast Full Index Scan in Oracle?"
|
SQL Server |
Posted: 20 Feb 2011
Updated: 20 Feb 2011
Views: 98,077
Rating: 4.95/5
Votes: 12
Popularity: 5.34
Licence: The Code Project Open License (CPOL)
Bookmarked: 22
Downloaded: 0
This tip describes how to delete duplicate rows from a table that doesn't have a key.
|
|
Posted: 5 May 2012
Updated: 6 May 2012
Views: 22,421
Rating: 5.00/5
Votes: 1
Popularity: 0.00
Licence: The Code Project Open License (CPOL)
Bookmarked: 4
Downloaded: 0
This is an alternative for "List SQL Server table column name as rows".
|
|
Posted: 14 May 2012
Updated: 14 May 2012
Views: 8,260
Rating: 5.00/5
Votes: 1
Popularity: 0.00
Licence: The Code Project Open License (CPOL)
Bookmarked: 3
Downloaded: 32
This is an alternative for "Applying Running Total to a Result set"
|
|
Posted: 19 May 2012
Updated: 19 May 2012
Views: 6,380
Rating: 0.00/5
Votes: 0
Popularity: 0.00
Licence: The Code Project Open License (CPOL)
Bookmarked: 2
Downloaded: 24
This tip describes how to guarantee a fixed amount of rows in a table by using triggers
|
|
Posted: 20 Feb 2011
Updated: 20 Dec 2012
Views: 30,120
Rating: 5.00/5
Votes: 6
Popularity: 3.89
Licence: The Code Project Open License (CPOL)
Bookmarked: 16
Downloaded: 0
This tip describes how to delete duplicate rows from a table that doesn't have a key.
|
|
Posted: 27 Dec 2012
Updated: 17 Jan 2013
Views: 25,316
Rating: 5.00/5
Votes: 1
Popularity: 0.00
Licence: The Code Project Open License (CPOL)
Bookmarked: 5
Downloaded: 47
This tip describes how to calculate an aggregate for dynamically defined columns using UNPIVOT clause.
|
|
Posted: 18 Dec 2012
Updated: 19 Jan 2013
Views: 30,983
Rating: 5.00/5
Votes: 4
Popularity: 3.01
Licence: The Code Project Open License (CPOL)
Bookmarked: 5
Downloaded: 38
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.
|
|
Posted: 26 Aug 2014
Updated: 26 Aug 2014
Views: 45,727
Rating: 5.00/5
Votes: 2
Popularity: 1.51
Licence: The Code Project Open License (CPOL)
Bookmarked: 7
Downloaded: 189
Generate a set of random numbers by using CTE
|
|
Posted: 26 Aug 2014
Updated: 28 Aug 2014
Views: 33,489
Rating: 4.83/5
Votes: 10
Popularity: 4.83
Licence: The Code Project Open License (CPOL)
Bookmarked: 7
Downloaded: 101
Generate Fibonacci numbers using CTE
|
|
Posted: 27 Jul 2011
Updated: 31 Aug 2014
Views: 24,762
Rating: 5.00/5
Votes: 4
Popularity: 3.01
Licence: The Code Project Open License (CPOL)
Bookmarked: 11
Downloaded: 70
This tip demonstrates the use of LAG and LEAD functions in SQL Server.
|
|
Posted: 10 Sep 2014
Updated: 10 Sep 2014
Views: 7,550
Rating: 5.00/5
Votes: 1
Popularity: 0.00
Licence: The Code Project Open License (CPOL)
Bookmarked: 4
Downloaded: 24
The tip shows how to intentionally cause an error in a situation where a non-existing reference would be updated.
|
|
Posted: 13 Sep 2014
Updated: 13 Sep 2014
Views: 10,872
Rating: 5.00/5
Votes: 1
Popularity: 0.00
Licence: The Code Project Open License (CPOL)
Bookmarked: 2
Downloaded: 58
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.
|
|
Posted: 26 Aug 2014
Updated: 16 Sep 2014
Views: 47,353
Rating: 4.64/5
Votes: 5
Popularity: 3.24
Licence: The Code Project Open License (CPOL)
Bookmarked: 10
Downloaded: 93
How to generate desired amount of rows in SQL Server using CTE
|
|
Posted: 18 Sep 2015
Updated: 18 Sep 2015
Views: 69,109
Rating: 5.00/5
Votes: 7
Popularity: 4.23
Licence: The Code Project Open License (CPOL)
Bookmarked: 6
Downloaded: 181
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.
|
|
Posted: 26 Sep 2016
Updated: 30 Sep 2016
Views: 9,050
Rating: 5.00/5
Votes: 4
Popularity: 3.01
Licence: The Code Project Open License (CPOL)
Bookmarked: 3
Downloaded: 0
TrimChar function which removes occurences of the desired character from both ends of a string.
|
|
Posted: 4 Oct 2016
Updated: 4 Oct 2016
Views: 20,741
Rating: 4.50/5
Votes: 5
Popularity: 3.15
Licence: The Code Project Open License (CPOL)
Bookmarked: 1
Downloaded: 0
Few tips for connecting to an SQL Server instance using DAC
|
|
Posted: 13 Oct 2016
Updated: 13 Oct 2016
Views: 10,704
Rating: 5.00/5
Votes: 8
Popularity: 4.52
Licence: The Code Project Open License (CPOL)
Bookmarked: 6
Downloaded: 36
A little tip on how to format repeating values in SQL output using LAG function
|
|
Posted: 7 Dec 2016
Updated: 7 Dec 2016
Views: 9,370
Rating: 5.00/5
Votes: 4
Popularity: 3.01
Licence: The Code Project Open License (CPOL)
Bookmarked: 2
Downloaded: 28
This tip demonstrates how to select valid records from a table that contains validity date limits.
|
|
Posted: 29 Dec 2019
Updated: 29 Dec 2019
Views: 4,642
Rating: 5.00/5
Votes: 4
Popularity: 3.01
Licence: The Code Project Open License (CPOL)
Bookmarked: 1
Downloaded: 14
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
|
C#
|
General |
Posted: 17 Nov 2012
Updated: 17 Nov 2012
Views: 8,140
Rating: 0.00/5
Votes: 0
Popularity: 0.00
Licence: The Code Project Open License (CPOL)
Bookmarked: 7
Downloaded: 51
The tip shows an example for using multiple partial classes to define a single class.
|
Samples |
Posted: 26 Jul 2012
Updated: 26 Jul 2012
Views: 21,550
Rating: 4.72/5
Votes: 4
Popularity: 2.84
Licence: The Code Project Open License (CPOL)
Bookmarked: 4
Downloaded: 94
This tip describes few examples how ro cumulate values using an extension method with LINQ
|
|
Posted: 28 Jul 2012
Updated: 27 Jul 2012
Views: 9,790
Rating: 0.00/5
Votes: 0
Popularity: 0.00
Licence: The Code Project Open License (CPOL)
Bookmarked: 1
Downloaded: 18
This is an alternative for "Cumulating values with LINQ"
|
LINQ
|
General |
Posted: 5 Oct 2015
Updated: 5 Oct 2015
Views: 16,891
Rating: 4.93/5
Votes: 11
Popularity: 5.13
Licence: The Code Project Open License (CPOL)
Bookmarked: 19
Downloaded: 506
This tip shows one way to query hierarchical data from a DataTable by using an AsTree() method.
|
Programming Tips
|
Design and Strategy |
Posted: 20 Jul 2012
Updated: 10 Aug 2012
Views: 52,116
Rating: 4.64/5
Votes: 10
Popularity: 4.64
Licence: The Code Project Open License (CPOL)
Bookmarked: 16
Downloaded: 107
This tip describes how to use an existing enum to define a new, for example a context specific enum.
|
General |
Posted: 10 Aug 2011
Updated: 10 Aug 2011
Views: 7,130
Rating: 4.60/5
Votes: 3
Popularity: 2.19
Licence: The Code Project Open License (CPOL)
Bookmarked: 0
Downloaded: 0
Or simply:exec msdb..sp_help_jobsp_help_job (Transact-SQL)[^]
|
|
Posted: 25 Nov 2011
Updated: 24 Dec 2011
Views: 20,330
Rating: 4.73/5
Votes: 6
Popularity: 3.68
Licence: The Code Project Open License (CPOL)
Bookmarked: 3
Downloaded: 0
As a general rule of thumb, I'd suggest browsing http://www.connectionstrings.com/[^] for connection strings against popular data sources.
|
|
Posted: 26 Aug 2012
Updated: 26 Aug 2012
Views: 42,452
Rating: 5.00/5
Votes: 10
Popularity: 4.77
Licence: The Code Project Open License (CPOL)
Bookmarked: 8
Downloaded: 644
The tip shows one way to resolve if a user control is in design mode.
|
|
Posted: 26 Jul 2015
Updated: 26 Jul 2015
Views: 6,941
Rating: 4.50/5
Votes: 2
Popularity: 1.35
Licence: The Code Project Open License (CPOL)
Bookmarked: 5
Downloaded: 141
This tip shows how to extract images from an Office document saved in Office Open XML format.
|
String handling
|
Strings |
Posted: 7 Nov 2012
Updated: 7 Nov 2012
Views: 23,923
Rating: 5.00/5
Votes: 1
Popularity: 0.00
Licence: The Code Project Open License (CPOL)
Bookmarked: 4
Downloaded: 0
This is an alternative for "Manipulating a string array using a Lambda Expression"
|
Installation
|
General |
Posted: 27 Mar 2012
Updated: 27 Mar 2012
Views: 16,991
Rating: 5.00/5
Votes: 2
Popularity: 1.51
Licence: The Code Project Open License (CPOL)
Bookmarked: 5
Downloaded: 0
This tip describes a way to get publishing information for a ClickOnce deployed application
|
|
Posted: 1 Apr 2012
Updated: 1 Apr 2012
Views: 14,100
Rating: 5.00/5
Votes: 2
Popularity: 1.51
Licence: The Code Project Open License (CPOL)
Bookmarked: 4
Downloaded: 0
This is an alternative for "Getting publishing information for a ClickOnce deployment"
|