In this third in a series on working smarter with T-SQL, let's give the built-in sp_executesql stored proc a go. In my previous posts, I've described some methods for generating and executing T-SQL ...

Working with dynamic SQL is all well and good, but avoid the risks that can lead to your code being susceptible to a SQL injection attack. As much as making your T-SQL work smarter for you, a la ...

Building on the DATETIMEFROMPARTS, DATETIME2FROMPARTS offers similar functionality, but yields more precise DateTime2 data type, containing fractions of a second to a specified precision. Naturally, ...

I have a weird issue (well weird to me).<BR><BR>I'm using SSSRS and I'm using multivalued parms so people can select multiple values to pass for a single parameter. (i.e. EntryTypeId and they get a ...

Every day, businesses depend on data to operate. Customer orders, quotes for new business, conversations around products, campaigns for marketing—pretty much every business process today is based on ...

SQL, the Structured Query Language, remains one of the most widely used programming languages, coming in fourth in Stack Overflow’s research for 2023. Just over half (51.52%) of professional ...

this will return: "(1 row(s) affected)" But now I need to know, what data was actually inserted? SQL Server has answered this question in 2005 with the OUTPUT statement: This will return a dataset ...

PolyBase, a data virtualization feature for SQL Server, allows users to seamlessly query data from various external sources directly using T-SQL (Transact-SQL) without the need for separate client ...

One way that organizations are storing data in the cloud is by moving their databases to the cloud. What once meant building an entire physical server, patching it, installing software like Microsoft ...

At the Ignite conference today, Microsoft made a series of announcements about Azure databases. It announced a brand-new Azure database called HorizonDB, which is a fully managed PostgreSQL database ...