Piyush Tripathi

Hi, I am Piyush Tripathi, a Software Engineer (San Francisco) and expert in micro service base API design and development. 

Technical Article

Extract parts of the strings from the SQL results directly by using SQL's substring-extraction API functions

If you need to extract a substring or create a longer string by combining multiple strings, there are a few methods you can use. To extract a specific portion of a string, you can utilize a substring-extraction function.

You rated this post out of 5. Change rating

2023-05-09 (first published: )

244 reads

Technical Article

Python 3 Script for Generating SQL Insert Statements from CSV Data

This Python 3 script is designed to take CSV file data pasted into the csv_data variable and generate SQL insert statements that can be used to insert the data into a MySQL database. The script is easy to use and can save you a lot of time when working with large amounts of data.

You rated this post out of 5. Change rating

2023-05-08 (first published: )

3,527 reads

Blogs

T-SQL Tuesday #174 – My Favorite Interview Question

By

This month is a great topic to me. I think growing and improving your...

T-SQL Tuesday #174: Job Interview Questions

By

Once upon a time, I used to think of difficult technical questions to ask...

Power BI: Refreshable Excel Files in PBI Service

By

Ever since Excel made its debut in the 1980’s, it has been used as...

Read the latest Blogs

Forums

Combining Silver Tables into a Model – Data Engineering with Fabric

By John Miner

Comments posted to this topic are about the item Combining Silver Tables into a...

Full Text Editions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Full Text Editions

Help on grouping to sets of rows in my sql data

By Mond

Hello I need help on writing this query. This is what i need. I...

Visit the forum

Question of the Day

Full Text Editions

In which editions can I use Full-Text and semantic search?

See possible answers