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
mixing literature, programming and some fun
If for some reason you need to migrate your MS-SQL Server database to SQLite Database,... Read more
Here’s a quick code to generate a “Create Table” query based on your Datatable object.... Read more
Here’s a SQL Function to get name of the database from it’s physical full name.... Read more
RESTORE FILELISTONLY is a Transact Statement in MS-SQL that returns a result set containing a... Read more
Found a great solution to writing a complex PIVOT function in SQL on the web!... Read more
Here’s a handy SQL function that allows to insert string(s) inside a larger string. This... Read more
A SQL Developer is responsible for managing data in a relational database. Database Providers like... Read more
RODBC is a useful package for making SQL queries to SQL Server database for R... Read more
Introduction Usually it is expected from client side to upload only structured Excel sheets (sheet... Read more
Finally got my article published at Tuts+ I had written this article “7 Handy SQL... Read more