Menu
Menu
DaniWeb
Log In
Sign Up
Read
Contribute
Meet
Search
Search
About 1,000 results for
sql-function
- Page 1
Re: Question/Answering over SQL Data Using LangGraph Framework
Programming
Computer Science
2 Months Ago
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
16 Years Ago
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
10 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…
SQL Function
Programming
Databases
15 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…
Re: SQL Function
Programming
Databases
15 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
15 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
15 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
15 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
15 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
15 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: working with SQL Function in Entity Framework ?
Programming
Web Development
10 Years Ago
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
12 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 problem
Programming
Databases
13 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
13 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: SQL Date functions
Programming
Databases
15 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
11 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…
Re: "Between" SQL function Problem
Programming
Software Development
16 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
16 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
16 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…
SQL Date functions
Programming
Databases
15 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: SQL Function
Programming
Databases
15 Years Ago
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
15 Years Ago
by Tank50
Thanks MeSampath.Its works.Thank you Tank50
Re: SQL Function
Programming
Databases
15 Years Ago
by sknake
What do you mean "doesnt work" ?
Re: SQL Function
Programming
Databases
15 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.
addition of date in sql function
Programming
Software Development
10 Years Ago
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
15 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…
Re: addition of date in sql function
Programming
Software Development
10 Years Ago
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
14 Years Ago
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
15 Years Ago
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
11 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...
1
2
3
17
Next
Last
Search
Search
Forums
Forum Index
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
Top Members
Meet People
Community Functions
DaniWeb Premium
Newsletter Archive
Markdown Syntax
Community Rules
Developer APIs
Connect API
Forum API Docs
Tools
Backlink Auditor
Legal
Terms of Service
Privacy Policy
FAQ
About Us
Advertise
Contact Us
© 2025 DaniWeb® LLC