Making your T-SQL work smarter for you by having it work as a code generator. Part 1 in a series. Want to save some time writing code? Many DBAs use the trick I'm going to show you this week to: A) ...
Ok in MSAccess I can send an SQL string to a server I'm connected to and as I understand it that string can contain anything.<BR><BR>Basically it would behave as if I was connected to the server ...
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 ...
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, ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results