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,849 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,849 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)
43,008 reads
This table Valued Function return the Modified Objects (SP /Views) For the Date specified.
2011-10-07 (first published: 2007-11-23)
1,380 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)
886 reads
By Steve Jones
lookaback– n. the chock of meeting back up with someone and learning that your...
Regarding managing databases in the cloud, security should never be an afterthought. That’s where...
By Steve Jones
In a couple of weeks, I’ll be in New York City for the Redgate...
Comments posted to this topic are about the item Deleting a Database
Comments posted to this topic are about the item Data Analyst AI tool
Comments posted to this topic are about the item Removing Log Shipping
If I want to delete a log shipping secondary server where only one database is used to restore the logs, what should I do?
See possible answers