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
Category: SQL
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
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
SQL: Save Result From RESTORE FILELISTONLY
RESTORE FILELISTONLY is a Transact Statement in MS-SQL that returns a result set containing a... Read more
SQL Pivot with Dynamic Column Names
Found a great solution to writing a complex PIVOT function in SQL on the web!... Read more
SQL: String Format Function
Here’s a handy SQL function that allows to insert string(s) inside a larger string. This... Read more
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
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
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
7 Handy SQL Scripts for SQL Developers
Finally got my article published at Tuts+ I had written this article “7 Handy SQL... Read more