Menu
Menu
DaniWeb
Log In
Sign Up
Read
Contribute
Meet
Search
Search
About 1,000 results for
sql-function
- Page 1
Re: VB60, Run-time error 3709 solution
Programming
Software Development
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
Programming
Web Development
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
Programming
Computer Science
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
Programming
Computer Science
1 Month Ago
by aishamushtaq
very helpful
working with SQL Function in Entity Framework ?
Programming
Web Development
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
Programming
Software Development
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
Programming
Databases
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
Programming
Databases
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
Programming
Databases
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
Programming
Databases
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
Programming
Databases
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
Programming
Databases
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
Programming
Software Development
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
Programming
Databases
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
Programming
Databases
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
Programming
Databases
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 ?
Programming
Web Development
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
Programming
Databases
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
Programming
Databases
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
Programming
Databases
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
Programming
Software Development
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
Programming
Software Development
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
Programming
Software Development
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
Programming
Databases
14 Years Ago
by sknake
What do you mean "doesnt work" ?
Re: SQL Function
Programming
Databases
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
Programming
Computer Science
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?
Programming
Databases
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
Programming
Software Development
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?
Programming
Databases
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
Programming
Software Development
11 Years Ago
by Tobyjug2222
Works a treat, thanks very much! - Howcome the [ ] are required around the headers in the
SQL
string? Thanks again.
1
2
3
17
Next
Last
Search
Search
Forum Categories
Hardware/Software
Recommended Topics
Programming
Recommended Topics
Digital Media
Recommended Topics
Community Center
Recommended Topics
Latest Content
Newest Topics
Latest Topics
Latest Posts
Latest Comments
Top Tags
Topics Feed
Social
Forums
Top Members
Meet People
Community Functions
DaniWeb Premium
Newsletter Archive
Markdown Syntax
Community Rules
Developer APIs
Connect API
Forum API Docs
Tools
SEO Backlink Checker
Legal
Terms of Service
Privacy Policy
FAQ
About Us
Advertise
Contact Us
© 2024 DaniWeb® LLC