Passing parameters to query without TVFs
This article looks at an interesting way to help your users get filtered data from a TVF instead of using a stored procedure or specialized view.
2023-03-27
4,808 reads
This article looks at an interesting way to help your users get filtered data from a TVF instead of using a stored procedure or specialized view.
2023-03-27
4,808 reads
Inline Table Valued Functions (iTVFs) are one type of user defined function that is available to implement in SQL Server since SQL Server 2000.
iTVFs remain a very useful tool in our SQL armoury, so let's quickly revisit them and the different ways we can use them in our code.
2020-10-07 (first published: 2020-09-08)
42,463 reads
This table Valued Function return the Modified Objects (SP /Views) For the Date specified.
2011-10-07 (first published: 2007-11-23)
1,379 reads
This tabled valued function can be used to parse a comma seperated list of IDs so you can pass a parameter to use in a in clause without having to use dynamic SQL.
2007-11-22 (first published: 2007-10-04)
885 reads
By Steve Jones
I had to demo the Flyway Autopilot system recently and created a GitHub Actions...
This is more complicated than using the Azure Migration method, but because it’s maxed...
I’ve covered how to create Elastic Jobs in the portal (this one is important...
Accidental DBA here. After looking at all the work that needs to be done,...
Hello SSC, Hope you are all having a great Monday! I am trying to...
I'm having a bit of an issue with SSRS permissions. Users (Operations Manager Report...
Which of these is not a requirement for a database to be added to an Availability Group (AG)?
See possible answers