Search DaniWeb - sql-function

Re: VB60, Run-time error 3709 solution 3 Weeks Ago by rproffitt … and more, it's all for naught as the key SQL component is dead now. Yes we could do a re…. While other than the SQL we used back then being dead, the other parts of VB6 function but it's time to… Re: Database wrapper for Codeigniter 3 2 Weeks Ago by pyeri … with SQL queries. I use a couple of helper functions which make the task of query building easier: ``` function build_insert_query…(',', $fields) . ") values(" . implode(',', $padding) . ")", $value_array ]; } function build_update_query($table, $values, $where) { $ss = "update ".$table."… Using Natural Language to Query SQL Databases with Python LangChain Module 2 Months Ago by usmanmalik57 …= 0.5 ) ``` Next, we define a `get_db_response` function that accepts the database object and the user query as…input parameters. Inside the function, we create a LangChain SQL agent using the `create_sql_agent()` function. You pass the … and the query string to the `get_db_response()` function you defined earlier. In the following script, … Re: Using Natural Language to Query SQL Databases with Python LangChain Module 1 Month Ago by aishamushtaq very helpful working with SQL Function in Entity Framework ? 9 Years Ago 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… "Between" SQL function Problem 15 Years Ago by kamae … in using "[COLOR="red"]between[/COLOR]" sql function. I don't know how to use it. I am… Re: SQL Function 14 Years Ago 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 14 Years Ago 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 14 Years Ago 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 14 Years Ago 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 14 Years Ago 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 14 Years Ago 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… SQL Problem - System.Data.OleDb.OleDbException was unhandled 11 Years Ago 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 14 Years Ago 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… SQL function problem 12 Years Ago 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 12 Years Ago 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: working with SQL Function in Entity Framework ? 9 Years Ago by Ahmed_39 … code is: CREATE FUNCTION [dbo].[SelectEmployee](@frm_date DATE, @to_date DATE) RETURNS TABLE AS RETURN … Re: SQL Date functions 14 Years Ago 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 10 Years Ago 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… SQL Date functions 14 Years Ago 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: "Between" SQL function Problem 15 Years Ago 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 15 Years Ago 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 15 Years Ago by hkdani … more or less what you're looking for in a SQL string. The DatePicker Value property is the Value you're… Re: SQL Function 14 Years Ago by sknake What do you mean "doesnt work" ? Re: SQL Function 14 Years Ago by Nfurman Ok. thank you today it works. Looks like sometimes it's useful to restart SqlServer.:icon_wink: Thank you for helping me. formula parser in T-SQL help needed 14 Years Ago 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… What is SQL Function? and When we should use SQL Functions? 10 Years Ago 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... Table valued functions C#, SQL, CLR 12 Years Ago by normmy …how to make a Table Valued Function (TVF) work in C# and T-SQL. I have managed to get a…not match. using the following T-SQL code to do it [code] create FUNCTION fncParsePatients(@NhsNo_in nvarchar(256), @CaseNo_in nvarchar…results in that can be accepted by the T-SQL function declaration or am I missing something more fundamental? Apologies… How to make Multiply / divide sql tables to show real price? 11 Years Ago by logicaweb …gt;pagina = $pagina; $this->desconto = $desconto; } } function ListarProducts($sql) { global $adb, $cfg, $_t; $lines=''; $count = …quot;REAL PRICE SPACE". I think SQL function can be something like this `SELECT preco… Re: SQL Problem - System.Data.OleDb.OleDbException was unhandled 11 Years Ago by Tobyjug2222 Works a treat, thanks very much! - Howcome the [ ] are required around the headers in the SQL string? Thanks again.