support multiple sql statement seperate by semicolon support select, delete, update and insert type support drop, truncate and rename command output the table and column list that the sql visited with ...

This system stored procedure takes a table name as a parameter and generates a MERGE statement containing all the table data. This is useful if you need to migrate static data between databases, eg.

A database is an essential component of any modern application, providing a repository for storing and retrieving large amounts of information. Building a database can seem daunting, but it can be ...

SQL is neither the fastest nor the most elegant way to talk to databases, but it is the best way we have. Here’s why Today, Structured Query Language is the standard means of manipulating and querying ...

Update 2018-06-06: Please not that in the step involving reviewing the schema for the Response step, be sure to check that each column’s type is specified as string, integer, boolean, etc. or the flow ...

What a great last few days for PowerApps! I hope you have been enjoying the announcements in the Spring Update Blog bundle. Have you seen Satya’s video? This blog doesn’t quite rise to the level of ...

With SQL Server 2016, you can store JSON objects in your rows. Here’s how to work with JSON objects, including how to update them once you’ve found them. In a previous Practical .NET column I showed ...