Click here to Skip to main content
15,886,110 members

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

Project: 1, Tip/Tricks: 6

RSS Feed

Average article rating:

No articles have been posted.

Average blogs rating:

No blogs have been submitted.

Average tips rating: 4.33

Database Development
2 May 2011   Updated: 2 May 2011   Rating: 3.67/5    Votes: 3   Popularity: 1.75
Licence: CPOL    Views: 13,220     Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
A nice way to get aggregated value without group by
MySQL
10 May 2011   Updated: 10 May 2011   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 9,471     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
24 Feb 2011   Updated: 25 Feb 2011   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: CPOL    Views: 27,951     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
28 Feb 2011   Updated: 28 Feb 2011   Rating: 3.50/5    Votes: 3   Popularity: 1.67
Licence: CPOL    Views: 19,681     Bookmarked: 8   Downloaded: 0
Please Sign up or sign in to vote.
Nice and fast way for reporting
Programming Languages
C#
24 Feb 2011   Updated: 24 Feb 2011   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 5,760     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
28 Apr 2011   Updated: 28 Apr 2011   Rating: 4.50/5    Votes: 2   Popularity: 1.35
Licence: CPOL    Views: 11,731     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: 4.33

Node.js
10 Sep 2018   Updated: 10 Sep 2018   Rating: 4.33/5    Votes: 2   Popularity: 1.30
Licence: MIT    Views: 6,822     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
A guide to creating an API Mocking utility in Node
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