A Simple Introduction to Dynamic SQL
Dynamic SQL is essentially normal SQL written in such a way that you end up with a “customised” SQL script at run-time.
2018-02-12
3,693 reads
Escape Single Quote
RE: Creating Views: Changing column names
I have another one that I'm trying to solve: Create another view that returns the name of each country and the number of orders shipped to that country. Name the number of orders column "NumOrders.” Include code that checks if the view already exists. If it does, it should be dropped and re-created. Can any one […]
2005-03-12
Blogs
T-SQL Tuesday #176: That Piece of Technical Advice for the Past Me
By DataOnWheels
DIVERSIFY! We devote a lot of time to mastering the technology that we are...
So You Want to Deploy Power BI Project files (PBIPs)?
By Angela-Henry
Have you heard the news about the new Power BI Project files? Okay, maybe...
DBAs, Organizing Your SQL Scripts in Git
By Steve Jones
I wrote an article that was published on SQL Server Central on how to...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers