Click here to Skip to main content
14,934,518 members

Articles by pankajupadhyay29 (Article: 1, Tip/Tricks: 6)

Article: 1, Tip/Tricks: 6

RSS Feed

Average article rating: 4.33

Web Development
Node.js
Posted: 10 Sep 2018   Updated: 10 Sep 2018   Views: 5,591   Rating: 4.33/5    Votes: 2   Popularity: 1.30
Licence: The MIT License      Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
A guide to creating an API Mocking utility in Node

Average blogs rating:

No blogs have been submitted.

Average tips rating: 4.33

Database Development
Posted: 2 May 2011   Updated: 2 May 2011   Views: 12,650   Rating: 3.67/5    Votes: 3   Popularity: 1.75
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
A nice way to get aggregated value without group by
MySQL
Posted: 10 May 2011   Updated: 10 May 2011   Views: 8,901   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
Nice one but it did not handle null values you can change it as following to handle null valuescreate table #TABLE_1 (COLUMN_1 varchar(5))insert into #TABLE_1select 'A'union allselect 'B'union allselect 'C'union allselect 'D'union allselect 'E'union allselect...
SQL Server
Posted: 24 Feb 2011   Updated: 25 Feb 2011   Views: 25,061   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
Use this when you want to perform a task on all tables in a database
Posted: 28 Feb 2011   Updated: 28 Feb 2011   Views: 17,731   Rating: 3.50/5    Votes: 3   Popularity: 1.67
Licence: The Code Project Open License (CPOL)      Bookmarked: 8   Downloaded: 0
Please Sign up or sign in to vote.
Nice and fast way for reporting
Programming Languages
C#
Posted: 24 Feb 2011   Updated: 24 Feb 2011   Views: 4,950   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
What about this :) string ToggleStringCase(string strToToggle){ StringBuilder sb = new StringBuilder(); foreach(char ch in strToToggle.ToCharArray()) { if((int)ch>=65&&(int)ch<91) { sb.Append((char)((int)ch+32)); } else...
Web Development
HTML
Posted: 28 Apr 2011   Updated: 28 Apr 2011   Views: 10,300   Rating: 4.50/5    Votes: 2   Popularity: 1.35
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
I have created a jQuery code to achieve this/*User Options --allowHex:Allow hexadecimal number default falseallowNeg:Allow negative default falseonlyInteger:did not allow decimal default true*/$(function () { var mergedOptions = {}; var common = { allowHex:...

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.

pankajupadhyay29
Architect
India India
• An Architect, developer, trainer, and student
• 10 years of experience in Architecture and Development of enterprise applications
• Extensive knowledge in designing and developing Web-based enterprise applications using open source and Microsoft Technologies
• Extensive experience in Angular, AngularJS, ReactJs, NodeJs, JavaScript, ASP.Net, C#, CSS, HTML