Sql Server deterministic user-defined function
You just need to create it with schemabinding. SQL Server will then verify whether or not it meets the criteria to be considered as deterministic (which it does as it doesn’t access any external tables or use non deterministic functions such as getdate()). You can verify that it worked with SELECT OBJECTPROPERTY(OBJECT_ID(‘[dbo].[FullNameLastFirst]’), ‘IsDeterministic’) Adding the … Read more