Skip to content

pSovit

mixing literature, programming and some fun

  • .NET
  • SQL
  • Scrapy
  • Misc
  • Tips
  • Thoughts
  • .NET
  • SQL
  • Scrapy
  • Misc
  • Tips
  • Thoughts

Category: SQL

sqlite

Query Mapping between MS-SQL and SQLite

If for some reason you need to migrate your MS-SQL Server database to SQLite Database,... Read more

Jun 9, 2018Feb 9, 2021

Create Table In SQL Based On .NET Datatable

Here’s a quick code to generate a “Create Table” query based on your Datatable object.... Read more

Mar 18, 2018Feb 9, 2021

SQL: Get Database Name From Physical Name

Here’s a SQL Function to get name of the database from it’s physical full name.... Read more

Apr 17, 2017Feb 8, 2021

SQL: Save Result From RESTORE FILELISTONLY

RESTORE FILELISTONLY is a Transact Statement in MS-SQL that returns a result set containing a... Read more

Apr 17, 2017Feb 8, 2021

SQL Pivot with Dynamic Column Names

Found a great solution to writing a complex PIVOT function in SQL on the web!... Read more

Apr 2, 2017Feb 8, 2021

SQL: String Format Function

Here’s a handy SQL function that allows to insert string(s) inside a larger string. This... Read more

Mar 27, 2017Feb 8, 2021

Are you ready to work as a SQL Developer?

A SQL Developer is responsible for managing data in a relational database. Database Providers like... Read more

Mar 16, 2017Feb 8, 2021

Connecting to SQL Server using RODBC package in R

RODBC is a useful package for making SQL queries to SQL Server database for R... Read more

Mar 9, 2017Feb 8, 2021

Uploading Unknown Format Excel File To A SQL Database

Introduction Usually it is expected from client side to upload only structured Excel sheets (sheet... Read more

Mar 8, 2017Feb 8, 2021

7 Handy SQL Scripts for SQL Developers

Finally got my article published at Tuts+ I had written this article “7 Handy SQL... Read more

Jun 2, 2016Feb 8, 2021

Posts navigation

Older posts
Archives
  • December 2018
  • September 2018
  • August 2018
  • June 2018
  • March 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • August 2017
  • July 2017
  • June 2017
  • April 2017
  • March 2017
  • December 2016
  • November 2016
  • July 2016
  • June 2016
  • September 2015
  • August 2015
  • May 2015
  • April 2015
  • September 2014
  • June 2014
  • April 2014
  • March 2014

Proudly powered by WordPress