Trying to put a function call that returns an int into a call for a stored procedure. Getting \"Incorrect syntax near \'.\'.\"
I\'m trying to create a user defined function in Oracle that will return a DATE when given a text argument containing a date substring.I\'ve tried a couple ways of writing this, and all seem to throw
I\'m trying to write a UDF in C that inserts val开发者_Python百科ues into a table and returns this table.
This works: Dim rst As New ADODB.Recordset rst.Open \"SELECT * FROM dbo.ftblTest(1,2,3)\", CP.Connection, adOpenKeyset, adLockReadOnly
I have a function that takes 2 parameters: @iEmployeeID and @dDate. It\'s purpose is to find a budget rate for the given parameters. In other words, it should find the largest date being smaller or e
I\'m trying to write a UDF to translate a string that is either a guid or a project code associated with that guid into the guid:
I have a complex expression calculating a value from a date that I have to use on multiple date columns.
HERE IS THE FUNCTION: ALTER FUNCTION dbo.FN_GET_QUARTER -- the parameters for the function here ( @FN_Qtr_datedatetime
I writing code to determine how many days in a year. I am trying to keep it really simple. I found code that I think is very clean to determine a leap year. I am passing the inputted date using DATEP
I am writing a scalar function in T-SQL. The function should insert leading zeros into an input field of numbers the length of the input can vary in length, i,e,. 123, 1234567, 9876543210 and so forth
加载中,请稍侯......