Dynamic SQL lets you create a query string based off of user input. SQL Server allows you to create dynamic SQL statements. The statements use a SQL string varchar data type, then you execute the ...

Put the query in a new query window in SQL Server Management Studio. Looking at the AdventureWords2012 database (available for download from CodePlex), review the uspGetEmployeeManagers stored ...

We could invoke a T-SQL query using the CREATE DATABASE term, we could write some code to use the [Create() method with SMO] or, if we're putting this SQL server in Azure, we could even use the ...

When saved in Base for long term use, a query becomes a view. You can create a query in any database set up in Base. In fact, Base offers you three different ways to write a query: in a wizard, which ...

In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.