How to use temporary table in function
See a short and dirty example how to use temporary table in user defined function (UDF).
2011-07-21
9,345 reads
UDF
2011-03-07 (first published: 2011-02-21)
8,607 reads
Get Item from Delimited List at Position
Returns the item from a delimited list at the specified position. Both position and delimiter are parameters.
2011-03-10 (first published: 2011-02-21)
1,037 reads
2011-03-09 (first published: 2011-02-21)
780 reads
2011-03-04 (first published: 2011-02-21)
6,089 reads
Creating User-Defined Functions in Microsoft SQL Server
SQL Server's own list of functions is limited as far as what is available for database developers to use in their applications. Starting with SQL Server 2000, database developers were given the ability to create their own routines that accept parameters, perform custom actions and return results.
2010-09-28
4,570 reads
Blogs
T-SQL Tuesday #121: Gifts received for this year
It’s T-SQL Tuesday time again! This edition is hosted by Malathi (blog|twitter) and the...
A gift. T-SQL Tuesday #121
My good friend Malathi Mahadevan (blog|twitter) is hosting T-SQL Tuesday this month and wants...
Distributing Jupyter Notebooks
If you’re working with the Microsoft Data Platform, you should be, at the least,...
Forums
List of INDEX with create and DROP script should not include any constrains P/F
Hello Sir.. Please help me the script.. From entire database i want List of...
is there any better way to export SQL server data into csv file?
I have questions of exporting SQL server data, the details as below, thanks! how...
Uninstall SQL without uninstalling SSRS
We have a non-prod server that (long ago) we installed SQL Server on and...
Ask SSC