-
sql server - How to use T-SQL group by
I know I need to have (although I don't know why) a GROUP BY clause on the end of a SQL query that uses any aggregate functions like count, sum, avg, etc: SELECT count(userID), userName FROM user...
q&a -
mysql - What do I need to escape when I send a query?
When you execute a SQL query, you have to clean your strings or users can execute malicious SQL on your website. I usually just have a function escape_string(blah), which: Replaces escapes (\) ...
q&a -
Full Stack Developer
Dear recruiters, if you are looking for: - Java, Python PHP - React, Angular - PostgreSQL, Redis, MongoDB - AWS S3. EC2. ECS EKS - *nix system adminis
jokes · try2ex -
-
git - Getting started with version control
I need to implement version control, even for just the developing I do at home. I have read about how great Subversion is for the past couple years and was about to dedicate myself to learning th...
q&a -
What is the best way to determine if there are temporary tables in SQL Server?
When writing a T-SQL script that I plan on re-running, often times I use temporary tables to store temporary data. Since the temp table is created on the fly, I'd like to be able to drop that tab...
q&a -
sql - How to split a string to access item x?
Using SQL Server, how do I split a string so I can access item x? Take a string "Hello John Smith". How can I split the string by space and access the item at index 1 which should return "John"? ...
q&a -
Language agnostic - what are the web-based knowledge base solutions?
I've used a WordPress blog and a Screwturn Wiki (at two separate jobs) to store private, company-specific KB info, but I'm looking for something that was created to be a knowledge base. Specifica...
q&a -
Install IIS on win Server 2003 without installation CD?
The title says most of it. I have a VM running Windows Server 2003. While setting it up, I didn't install IIS. Now I need it and the installation ISO I installed from is on another machine that I...
q&a -
What is your favorite shell cmdlet?
I just found /n softwares free Powershell NetCmdlets, and after playing with them I love the functionality they bring to the command line. So it raises the question what are your favorite Cmdlets...
q&a
