Lab Sql

Someone decided to stuff a bunch of times together into a single column, so the column value might … Read more Tsql Udf To Split String Every 8 Characters

I am just studying how to use SQL in snowflake. Here is a snapshot: And this is the code used in h… Read more How To Use Sql User Defined Function In Snowflake?

I have a SQL CLR function like this one: public partial class UserDefinedFunctions { [Microsoft… Read more Clr Table-valued Function With Array Argument

I try to create a generic function that can be used like this example of using the new string_agg b… Read more Create A User Defined Function Like Sql Server 2017 String_agg On Earlier Versions

I have this SQL Server table table1 which I want to fill with dummy rows per acct up to latest prev… Read more Insert Dummy Rows To Fill Missing Values Into A Sql Table

Before posting I have read few articles about developing USD functions, but have not encountered so… Read more Tsql - If..else Statement Inside Table-valued Functions - Cant Go Through

SQL Server, trying to get day of week via a deterministic UDF. Im sure this must be possible, but c… Read more Deterministic Scalar Function To Get Day Of Week For A Date

In the application I'm working on porting to the web, we currently dynamically access different… Read more How Do I Supply The From Clause Of A Select Statement From A Udf Parameter