TSQL Problem:
Let's say you've got one or more scalar values that are VARCHAR 'strings' and you want to determine if they can be typed more appropriately.

For example '16:16:34.6733333' is data type TIME. It's easy to examine the value manually to make that determination. But how would you do it programatically (via TSQL)?

I've tried casting the VARCHAR as different types. TRY_CAST is successful for some data types. How would I know which one is 'right'?

#SQLHelp
#SQLServer
#SQL
#TSQL

Строковые константы в MS SQL

Строковые константы в MS SQL кажутся очень простыми в использовании. Но эта простота не всегда очевидна и порой приводит к тяжело выявляемым ошибкам в коде. По этой причине данная статья может оказаться полезной не только новичкам, но и тем, кто уже использует T-SQL в своей работе. Документация явно описывает два типа констант: обычные строковые и юникодные. Но на самом деле ситуация несколько сложнее, что и будет рассмотрено ниже.

https://habr.com/ru/articles/1001668/

#sql_server #sql #tsql

OPENROWSET and External Tables for Fabric SQL Databases
#SQL #SQLDatabase #MicrosoftFabric #DataVirtualization #Analytics #TSQL #OneLake

https://blog.fabric.microsoft.com/en-US/blog/openrowset-and-external-tables-for-fabric-sql-databases/?wt.mc_id=DP-MVP-4015656

#TodayILearned about table-valued scalar functions in Microsoft #TSql and why I should care.

These can be used in a view. If you need to run a procedure to calculate parts of the output, but use a middleware that is incapable of calling functions directly, scalar functions are your next best bet.

If they return their value as a table, you can "join" them to the main rowset in the view using the operations "cross apply" (which behaves like inner join) and "outer apply" (like outer join).

Do you write a lot of paper checks? (I don't--typically it's just one per month.) If so, do you screw up the year when writing in the date for the first few weeks/months of the new year?

This is my TSQL version of that. I'm off to a good start. 🙄

#TSQL
#SSMS
#NewYear

Dear Santa,

I wish for a IT remote job, so I can stop ruining my body as a laborer.

Thx a million

Yours Derek

Merry christmas to you all

#merrychristmas #santaclaus #remotejob #itjobs #msaccess #linux #vbnet #tsql #lowcode #noai