No announcements
Found 2861564 threads
-
1 VotesUsing A Scalar Valued Function
Hi, I created a simple regex scalar-valued function as explained here, and it seems that asAnswered | 3 Replies | 3128 Views | Created by Ofer Elboher - Tuesday, August 27, 2013 7:03 PM | Last reply by Ofer Elboher - Wednesday, August 28, 2013 1:23 PM
-
1 Votes
Looking how to call a function within an update
Hi Miles, It sounds like you are using a scalar-valued function. Based on your example above the code would look like ...Answered | 2 Replies | 647 Views | Created by Miles Bradley - Friday, October 11, 2013 3:45 PM | Last reply by Miles Bradley - Friday, October 11, 2013 3:57 PM -
0 Votes
Problem to use scalar valued function in EF.
Hi to work around some limitation in EF, include using scalar valued function, i found a code snippet inUnanswered | 2 Replies | 5805 Views | Created by Hamed_1983 - Wednesday, October 21, 2009 12:02 PM | Last reply by Devart team - Friday, March 12, 2010 4:20 PM -
0 Votes
Can I use a value returned from a Scalar-Value Function to then join to a table
So I am using a Hierarchy Scalar-valued function to pass me back an INTEGER. I then want to use that INTEGER value returned from the ...Proposed | 3 Replies | 305 Views | Created by ITBobbyP - Thursday, April 26, 2018 3:57 PM | Last reply by Visakh16 - Thursday, April 26, 2018 6:14 PM -
0 Votes
problem executing scalar valued function in remote database's View
I have my local DB say "HD" on my machine and remote server say "RM-S/2005" has DB "R-DB", in R-DB there is scalar ...Answered | 2 Replies | 6986 Views | Created by spydaios - Monday, November 23, 2009 12:54 PM | Last reply by spydaios - Wednesday, November 25, 2009 10:01 AM -
0 Votes
Scalar-valued function performance
Hi I have implemented a scalar-valued function called by a stored procedure that reads a table to execute an insert in another table. The ...Answered | 4 Replies | 3965 Views | Created by pscorca - Monday, July 5, 2010 2:24 PM | Last reply by Uri Dimant - Tuesday, July 6, 2010 6:28 AM -
0 Votes
Scalar Valued Function Import Problem.
.with.LINQ.and.the.Entity.Framework book which supply a common solution for scalar valued function, but i didn't sucessful to use this solution and i create another ...Answered | 11 Replies | 10335 Views | Created by Hamed_1983 - Sunday, October 18, 2009 9:48 PM | Last reply by Hamed_1983 - Wednesday, October 21, 2009 11:40 AM -
0 Votes
Scalar-valued user-defined function fetching data from multiple rows
articles about scalar-valued functions but none of them talk about looping through multiple rows from a query. Many thanks for any who can ...Answered | 3 Replies | 3771 Views | Created by Lewis Kapell - Wednesday, June 23, 2010 3:48 PM | Last reply by Lewis Kapell - Wednesday, June 23, 2010 7:21 PM -
2 Votes
Scalar-Valued Function Help...
Hi, I'm using SQL 2008 I'm trying to write this query that will return the top most parent of a given company. The company has a ...Answered | 2 Replies | 5442 Views | Created by Westside2008 - Saturday, June 2, 2012 2:52 AM | Last reply by Westside2008 - Saturday, June 2, 2012 3:21 AM -
1 Votes
scalar-valued functions
Yes, don't use a scalar valued function! What you want is easily achieved with a CASE statement and using function ...Answered | 8 Replies | 7801 Views | Created by fjaconda199 - Sunday, March 7, 2010 9:51 PM | Last reply by Adam Tappis - Wednesday, March 24, 2010 5:27 PM -
0 Votes
Problems saving edited Functions in SQL server database using Visual Studio .Net 2003
;running on the same computer as VS2003. Using VS2003 Server Explorer, scalar-valued functions can be created in the VS2003 code and text editor. But then further edits ...Answered | 2 Replies | 8804 Views | Created by Maroller - Monday, November 21, 2005 9:45 AM | Last reply by Maroller - Tuesday, November 22, 2005 3:20 PM -
0 Votes
sp to scalar valued function
Hi all I am new to T-sql and have come across with this. I have a stored proc which I have to convert into scalar valued function. ...Answered | 6 Replies | 4008 Views | Created by Mikeeey - Thursday, March 11, 2010 3:14 PM | Last reply by Parry2k - Thursday, March 11, 2010 4:31 PM -
0 Votes
Performance drop while doing Scalar valued function & table-valued function
The script of this scalar valued functionAnswered | 5 Replies | 5536 Views | Created by Roland Andreas - Thursday, January 6, 2011 7:00 AM | Last reply by Tom Li - MSFT - Friday, January 7, 2011 8:09 AM -
6 Votes
Scalar-Valued Function Automatically Rounded
I have a scalar-valued function that is supposed to divide two decimal numbers and return a decimal value but when I execute the function it ...Answered | 4 Replies | 4534 Views | Created by Nick Olsen - Thursday, July 29, 2010 3:29 PM | Last reply by Nick Olsen - Thursday, July 29, 2010 3:53 PM -
1 Votes
Problem calling Scalar-valued Function
Why can't I call a Scalar-valued Function stored on a SQL2005 server from a VB.Net program? The member functionAnswered | 3 Replies | 6154 Views | Created by Rich McD - Wednesday, January 10, 2007 11:42 PM | Last reply by Rich McD - Thursday, January 11, 2007 5:10 PM -
0 Votes
SQL Server Scalar-Valued Function Question
That query returns a table (2 columns, 0 or more rows). So it would naturally used in a table valued function, not a scalar valued ...Answered | 5 Replies | 5661 Views | Created by Minuend - Saturday, October 11, 2014 6:03 PM | Last reply by Minuend - Sunday, October 12, 2014 11:06 PM -
0 Votes
Function local to fullname?
Welcome Verena. Unfortunately there is no such system function provided natively to SQL. You could create such a scalar valued function ...Answered | 1 Replies | 4722 Views | Created by Verena Thiebus - Thursday, June 26, 2008 1:11 PM | Last reply by David Dye - Thursday, June 26, 2008 1:45 PM -
0 Votes
C# Web Service - Access Scalar-valued Function via Entity Framework
I am trying to access a SQL Scalar-valued Function I created in a C# Web Service through Entity Framework. Anything I seem to try keeps failing. I have ...Answered | 2 Replies | 885 Views | Created by espink - Friday, January 17, 2014 4:52 PM | Last reply by espink - Monday, January 20, 2014 2:56 PM -
0 Votes
Problem with Scalar-valued function
I get the errors below. Why? I've also tried using a CASE statement and I get the same type of ...Answered | 1 Replies | 5104 Views | Created by mah-skeet - Thursday, September 11, 2008 5:05 PM | Last reply by a1Dave - Thursday, September 11, 2008 6:31 PM -
3 Votes
What makes a Scalar Valued Function "deterministic"
Thanks Erland! This did the trick. BTW: When using a CLR-UDF I can set IsDeterministic as a function attribute. After doing this, a ...Answered | 20 Replies | 1120 Views | Created by Jörg Debus - Monday, February 9, 2015 6:50 PM | Last reply by Jörg Debus - Friday, February 13, 2015 7:11 PM - Items 1 to 20 of 2861564 Next ›
No announcements
