No announcements
Found 407266 threads
-
0 Votesfunction parameter
Let us assume you have the below function and you want to display the parameter i.e @param.Answered | 5 Replies | 969 Views | Created by manojkumar09 - Thursday, April 4, 2013 9:13 AM | Last reply by Ch. Rajen Singh - Thursday, April 4, 2013 9:27 AM
-
0 Votes
functions and parameters
hello, I have the following problem with the following code: function testInt { param ([int]$i,[int]$j) write-host $i ...Answered | 1 Replies | 8701 Views | Created by thierry schmit - Tuesday, May 5, 2009 12:05 PM | Last reply by Grégory Schiro - Tuesday, May 5, 2009 1:33 PM -
0 Votes
using named parameters in Functions
ok,now it is working for me, I misunderstood functionality of ParameterSetName , what exactly is the use of the this ?Answered | 7 Replies | 4761 Views | Created by Arun Prasath S (Arun) - Friday, June 1, 2012 5:50 PM | Last reply by GastoneCanali - Friday, June 1, 2012 6:59 PM -
1 Votes
Search function in SSRS Parameters
The first one is a text-box to let end users to type in parameter value when the default value of parameter has no be specified.Answered | 4 Replies | 6957 Views | Created by SPRR - Thursday, November 8, 2012 8:47 PM | Last reply by Charlie Liao - Friday, November 9, 2012 2:15 AM -
0 Votes
Passing multiple parameters to a function
Hi Daren There are a few ways to skin this cat, but I would replace the scalar function with a table function that accepts either a comma separated list of ...Answered | 3 Replies | 12320 Views | Created by Daren (DJ) Johnson - Tuesday, August 6, 2013 2:32 PM | Last reply by Daren (DJ) Johnson - Wednesday, August 7, 2013 1:13 PM -
1 Votes
Powershell Function Parameter issue
not sure about the SQL stuff, but you're calling the function incorrectly should be: test "MyServer" "MyDatabase" (notice: no ...Answered | 1 Replies | 1730 Views | Created by Dattatray Nale - Wednesday, December 16, 2015 3:08 AM | Last reply by Anthony.Stringer - Wednesday, December 16, 2015 3:22 AM -
0 Votes
creating a function with date parameters
You want use the parameter to filter data which is between start date and end date.Answered | 1 Replies | 892 Views | Created by Nadia_Azam - Sunday, February 2, 2014 11:04 AM | Last reply by Alisa Tang - Monday, February 3, 2014 6:38 AM -
0 Votes
Parameter nObject in Function
Formatting is better to be done in the client application, not in T-SQL with scalar function.Answered | 4 Replies | 1022 Views | Created by Jorge Flor - Wednesday, February 6, 2013 1:31 PM | Last reply by Olaf Helper - Wednesday, February 6, 2013 1:55 PM -
2 Votes
Calling Functions as Parameter
Contents of C:\test.ps1 param( [switch] $one, [switch] $two ) function one {echo 1} function two {echo 2} if ($one) { ...Answered | 4 Replies | 1355 Views | Created by Wael Altaqi - Thursday, January 24, 2013 5:47 PM | Last reply by Wael Altaqi - Thursday, January 24, 2013 10:20 PM -
0 Votes
Parameter in functions not assigned correctly
Klaus, So far as I know, using C-style parameters isn't supported in PowerShell.Answered | 2 Replies | 2166 Views | Created by Bodyguard100 - Tuesday, May 29, 2012 1:15 PM | Last reply by G. Samuel Hays - Tuesday, May 29, 2012 2:55 PM -
0 Votes
Object as function parameter ??
I had tested the function after fixing it.Answered | 9 Replies | 1122 Views | Created by Diego NV - Tuesday, October 27, 2015 10:58 PM | Last reply by Satyajit321 - Thursday, October 29, 2015 3:16 AM -
0 Votes
Passing a parameter to a function via an alias
The reason this does not work is that an alias can only alias another command, not a command with parameters.Answered | 3 Replies | 1164 Views | Created by Shnooter - Saturday, June 7, 2014 10:53 PM | Last reply by Al Dunbar - Sunday, June 8, 2014 3:32 PM -
0 Votes
Passing parameters to Oracle to_date function
you dont need to use the to_date function if the parameter is specified as a date type in visual studio then you can use it directly as so: where ...Answered | 1 Replies | 6858 Views | Created by _M3 - Monday, February 22, 2010 8:27 PM | Last reply by Nehemiah Willis - Monday, February 22, 2010 8:56 PM -
5 Votes
Powershell script - Function Parameter
We do not use commas when calling a function in PowerShell.Answered | 3 Replies | 3643 Views | Created by exit1337 - Friday, September 14, 2012 9:17 AM | Last reply by exit1337 - Monday, September 17, 2012 11:21 AM -
7 Votes
GETDATE() as Table-Valued Function Parameter
This is one many reason that good SQL do not use proprietary "features" like Table-valued functions.Answered | 6 Replies | 5578 Views | Created by Mike DePouw - Thursday, October 4, 2012 5:42 PM | Last reply by Mike DePouw - Thursday, October 11, 2012 12:56 PM -
0 Votes
IIF function together with Parameter and LOOKUP
You have an extra bracket before the last parameter of the Lookup.Answered | 1 Replies | 1026 Views | Created by HCMJ - Friday, February 7, 2014 12:33 PM | Last reply by AndrewBorgCardona - Friday, February 7, 2014 1:09 PM -
0 Votes
Function Parameter Selectlist
When I use the function I would like it to get a dropdown list of "ValidationSet" after I typed in "My-Function -Selected " ...Answered | 3 Replies | 830 Views | Created by ohenrikh - Tuesday, February 18, 2014 2:22 PM | Last reply by Mike Laughlin - Tuesday, February 18, 2014 9:02 PM -
1 Votes
SQL Function - Passing in a parameter not working
Hi, I'm using SQL 2008 I am trying to pass a parameter into my function in my SELECT statement.Answered | 3 Replies | 3758 Views | Created by Westside2008 - Tuesday, March 27, 2012 3:43 AM | Last reply by vinaypugalia - Tuesday, March 27, 2012 5:07 AM -
0 Votes
using Aggregate function on Parameter value
Create a parameter named Max, set it’s visibility to hidden and get available values and default values from the DataSet1 COL1.Answered | 2 Replies | 2021 Views | Created by CSharp Enthusiast - Thursday, September 26, 2013 6:25 PM | Last reply by CSharp Enthusiast - Monday, September 30, 2013 2:30 PM -
1 Votes
Multivalue parameter not working with split function
I think you have mentioned the same expression to put into the dataset properties for parameter value.Answered | 3 Replies | 4952 Views | Created by Jimmy_Jen - Wednesday, April 20, 2011 8:37 PM | Last reply by Jimmy_Jen - Thursday, April 21, 2011 5:55 PM - Items 1 to 20 of 407266 Next ›
No announcements
