I made the following function in SQL Server 2008 earlier this week that takes two parameters and uses them to select a column of \"detail\" records and returns them as a single varchar list of comma s
I\'m having a problem with a MySQL UDF function (mychem.sourceforge.net) that\'s dependent on a large library (openbabel.org) which is in turn plugin based. The problem is that the format plugins to o
I have read-only access to a database that was set up for a third-party, closed-source app. Once group of (hopefully) useful table functions only returns the error:
What I want to do is implement submission scoring for a site with users voting on the content, much like in e.g. reddit (see the \'hot\' function in http://code.reddit.com/browser/sql/functions.sql).E
I have a UDF in sql server. I want t开发者_如何学Co call this function at frontend (C# Code). Is it possible to do it.Yeah, just grab a SqlConnection object and:
I am looking for a simple way (UDF?) to establish the similarity between strings. The SOUNDEX and DIFFERENCE function do not seem to do the job.
I have created the function below: Option Explicit Public Function fyi(x As Double, f As String) As String
I have a stored procedure on SQL Server 2005. It is pulling from a Table function, and has two joins. When the query is run using a load test it kills the CPU 100% across all 16 cores! I have determin
I\'m 99% sure that the answer is \"no\", but I\'m wondering if someone who is 100% sure can say so. Consider a VBA UDF:
A few examples to show, just incase: Inline Table Valued CREATE FUNCTION MyNS.GetUnshippedOrders() RETURNS TABLE