6/2/2023 0 Comments Ms access mid functionReplacements for VBA functions Date() and Now()ĭate functions should be really easy, but I have to admit that it's my biggest T-SQL disappointment. ![]() With that out of the way, let's get on to the fun stuff. Suffice it to say, that you will need to convert any reference of DISTINCTROW to DISTINCT if you want it to run in SQL Server. I've read the help topic and hashed out the details with my Access developer friends, but I still can't remember the difference between DISTINCTROW and DISTINCT. This is an Access-specific SQL keyword that doesn't exist in SQL Server. ![]() One last point that isn't grand enough to be a topic, but deserves mention is the DISTINCTROW keyword. Suggestions for advanced issues: T-SQL Functions Merciless T-SQL string concatenation explainedĦ. ![]() How to convert the IIF() function to T-SQLĤ. T-SQL equivalents for InStr() and Mid()ģ. Replacements for VBA functions Date() and Now()Ģ.
0 Comments
Leave a Reply. |