Re: Question/Answering over SQL Data Using LangGraph Framework Programming Computer Science by Pelorus_1 Through its combination of natural language processing and structured query generation, LangGraph makes interfacing with databases and extracting insights over SQL data easier than ever. "Between" SQL function Problem Programming Software Development by kamae … in using "[COLOR="red"]between[/COLOR]" sql function. I don't know how to use it. I am… working with SQL Function in Entity Framework ? Programming Web Development by Ahmed_39 … - i have create an sql function in my database that take to Date params with code: CREATE FUNCTION [dbo].[SelectEmployee](@frm_date DATE, @to_date… DataTable but i need to do that from Entity with sql function and what is difference between "SelectEmployee" that is… SQL Function Programming Databases by Tank50 … CommonName='Japan' Return @Description END[/CODE] After creating function I use below SQL statement [CODE] select dbo.udf_GetCountryID(Distinct(F.CommonName))CountryName….udf_GetCountryID'. [/COLOR] Once I create the function its comes under scalar-valued function.I am using sql server 2005.Please help me Thanks… Re: SQL Function Programming Databases by sknake ….com/forums/forum127.html"]MS SQL Forum[/URL] To answer your question: [code=sql] CREATE FUNCTION getRows ( @id int ) RETURNS int AS… Re: SQL Function Programming Databases by Nfurman ….com/forums/forum127.html"]MS SQL Forum[/URL] To answer your question: [code=sql] CREATE FUNCTION getRows ( @id int ) RETURNS int AS… Re: SQL Function Programming Databases by MeSampath … is working properly. The thing is while calling the function you may get an error like [CODE][COLOR="Red… not a recognized built-in function name.[/COLOR][/CODE] because, we are calling the function without dbo If you are …getting this error means call the function as, [CODE]select dbo.getRows(1)[/CODE] Please … SQL Function Programming Databases by Nfurman Please someone can help me. I need a function which just returns the number of rows from known… table. I tried it like: [CODE] CREATE FUNCTION getRows ( @id int ) RETURNS int AS BEGIN DECLARE @rownums… Procedure getRows, Line 9 Select statements included within a function cannot return data to a client. what's wrong … Re: SQL Function Programming Databases by skgopy … 10, Line 1.'AS_REP' is not a recognized built-in function name. when i try to call it with a dbo… find either column "dbo" or the user-defined function or aggregate "dbo.AS_REP", or the name is… Re: SQL Function Programming Databases by skgopy … 10, Line 1.'AS_REP' is not a recognized built-in function name. when i try to call it with a dbo… find either column "dbo" or the user-defined function or aggregate "dbo.AS_REP", or the name is… Re: working with SQL Function in Entity Framework ? Programming Web Development by Ahmed_39 … code is: CREATE FUNCTION [dbo].[SelectEmployee](@frm_date DATE, @to_date DATE) RETURNS TABLE AS RETURN … SQL Problem - System.Data.OleDb.OleDbException was unhandled Programming Software Development by Tobyjug2222 …Sub MakeSQLUser(ByVal SQLStringUserEdit As String) 'This function will apply SQL to databse, string built by other functions Dim… & "'" MsgBox(SQLSend) MakeSQLUser(SQLSend) 'Calls SQL function with above string as parameter MsgBox("Record has been… SQL function problem Programming Databases by y2kshane … , ItemTotalPrice) a)considering the above table write a function to calculate the IemTotalPrice as ItemTotalPrice=Quantity*UnitPrice b)Write… a SQL statement to create the above table (you must use the above created function so that … or wrong this is my answer [CODE] create function calc (@qty int,@up int) return int as … Re: SQL function problem Programming Databases by darkagn For part A, they are wanting a function that uses the specific fields in your table,… not passes them as parameters to the function. Your function will probably look something like this: [code] -- … meaningful name, and return an appropriate data type CREATE FUNCTION GetItemTotalPrice() RETURN MONEY AS DECLARE @TotalPrice MONEY -- total… Re: SQL Date functions Programming Databases by d5e5 … which is located on the database column name(DOB)..which sql function do i use and how do i use it on… somebody's date of birth you don't need a function. Assuming that DOB is defined as a DATE datatype you… sql function returning wrong value Programming Databases by HunainHafeez ALTER FUNCTION [dbo].[customers_udfMin2] ( @decission tinyint ) RETURNS int AS BEGIN -- Declare the … DECLARE @min int Declare @default int = 10 -- Add the T-SQL statements to compute the return value here if (@decission = 1… Re: "Between" SQL function Problem Programming Software Development by kamae … more or less what you're looking for in a SQL string. The DatePicker Value property is the Value you're… you can use. Hank[/QUOTE] Thank you so much, the sql works properly but another problem. How am I going to… Re: "Between" SQL function Problem Programming Software Development by debasisdas you need to convert the date and time to proper format before passing the same to database for processing through SQL statement. Re: "Between" SQL function Problem Programming Software Development by hkdani … more or less what you're looking for in a SQL string. The DatePicker Value property is the Value you're… SQL Date functions Programming Databases by Graffixnerd I want to calculate somebody date using his/her Date of Birth which is located on the database column name(DOB)..which sql function do i use and how do i use it on the Sqlquery..please help Re: SQL Function Programming Databases by MeSampath Hi, Could you give a try with following code change; [CODE]SELECT DISTINCT(dbo.udf_GetCountryID(F.CommonName)) AS CountryName FROM dbo.Test_Table F [/CODE] Good luck. Re: SQL Function Programming Databases by Tank50 Thanks MeSampath.Its works.Thank you Tank50 Re: SQL Function Programming Databases by sknake What do you mean "doesnt work" ? Re: SQL Function Programming Databases by Nfurman Ok. thank you today it works. Looks like sometimes it's useful to restart SqlServer.:icon_wink: Thank you for helping me. addition of date in sql function Programming Software Development by Manisha_4 … in 3rd row). i want to create a function in sql using create function functioname (eg function name as interval) that should return the… of output so that i can use that function(dbo.interval) in my sql query written in c# as string query = @"…-07/12/2013 3 i had tried using RecursiveCTE in sql but it is not of much help as it gives… formula parser in T-SQL help needed Programming Computer Science by padtes I have a T-SQL function (transact SQL is SQL server 2005 programming language, with many limitations compared to say … string (formula) that has ternary operators used in it. The function converts it into CASE statement and returns it. For ex… a>0 then 111 else 222 end [/icode] The function works as long as there is no brackets nesting in… Re: addition of date in sql function Programming Software Development by Santanu.Das More easy process if yo use C# codifications without creating Function in SQL. Make a Do...Loop and do your job. It should… be likely Do Until Date > ToDate '''open Connection '''SQL Statement with Where Clause Date beteen FromDate and ToDate '''Pick… Re: sql server probelm Programming Software Development by lolafuertes The most similar in SQL [CODE]SELECT dbo.Trans_Head.Doc_Date, dbo.Trans_Head.Document_No, dbo.Trans_Head.… return 0 if the value is null. We use the SQL function to do the same behaviour. DECODE(CompareFiled, CompareValue, ReturnValueIfTrue) will… ReturnValueIfTrue can be also NULL we still using the ISNULL SQL Function. Hope this helps. Re: SQL Server 2005 Date/Time Problem , Please Help Programming Databases by Difou Hi, You should give a look to the SQL function DATEDIFF [URL="http://msdn.microsoft.com/en-us/library/ms189794(SQL.90).aspx"]http://msdn.microsoft.com/en-us/library/ms189794(SQL.90).aspx[/URL] Because you can't substract date directly in an expression. Bie What is SQL Function? and When we should use SQL Functions? Programming Databases by adil.ghori Hi All I just want to know the following thing; When SQL Functions are used? Provide a couple of examples of situations in which they are necessary. Awaiting response... Also can anyone refer me a ebook for SQL for beginners in which Functions is desscribed detailed...