you have to call it like this

    SELECT dbo.CheckIfSFExists(23, default)

From [Technet][1]:

&gt; When a parameter of the function has a default value, the keyword
&gt; DEFAULT must be specified when the function is called in order to
&gt; retrieve the default value. This behaviour is different from using
&gt; parameters with default values in stored procedures in which omitting
&gt; the parameter also implies the default value. An exception to this
&gt; behaviour is when invoking a scalar function by using the EXECUTE
&gt; statement. When using EXECUTE, the DEFAULT keyword is not required.


  [1]: http://technet.microsoft.com/en-us/library/ms186755.aspx

You can call it three ways - with parameters, with DEFAULT and via EXECUTE

    SET NOCOUNT ON;

    DECLARE
	@Table	SYSNAME = &#39;YourTable&#39;,
	@Schema	SYSNAME = &#39;dbo&#39;,
	@Rows	INT;

    SELECT dbo.TableRowCount( @Table, @Schema )

    SELECT dbo.TableRowCount( @Table, DEFAULT )

    EXECUTE @Rows = dbo.TableRowCount @Table

    SELECT @Rows

With user defined functions, you have to declare every parameter, even if they have a default value.

The following would execute successfully:

    IF dbo.CheckIfSFExists( 23, default ) = 0
        SET @retValue = &#39;bla bla bla;

One way around this problem is to use stored procedures with an output parameter.

exec sp_mysprocname @returnvalue output, @firstparam = 1, @secondparam=2

values you do not pass in default to the defaults set in the stored procedure itself.  And you can get the results from your output variable.

I have implemented a custom dialog for my application. I want to implement that when the user clicks outside the dialog, the dialog will be dismissed.
What do I have to do for this?

How to dismiss the dialog with click on outside of the dialog?

I have a WCF service that has been working perfectly, and something has changed and I don&#39;t know what.

I get this exception:

&gt;System.ServiceModel.FaultException: The server was unable to process the request due to an internal error.  For more information about the error, either turn on IncludeExceptionDetailInFaults (either from ServiceBehaviorAttribute or from the &lt;serviceDebug&gt; configuration behavior) on the server in order to send the exception information back to the client, or turn on tracing as per the Microsoft .NET Framework 3.0 SDK documentation and inspect the server trace logs.

This is confusing because I am running .NET 4.0.

Where do I turn on `IncludeExceptionDetailInFaults`? I&#39;m battling to find it.

Turn on IncludeExceptionDetailInFaults (either from ServiceBehaviorAttribute or from the &lt;serviceDebug&gt; configuration behavior) on the server

I have this script:

    CREATE FUNCTION dbo.CheckIfSFExists(@param1 INT, @param2 BIT = 1 )
    RETURNS BIT
    AS
    BEGIN
	    IF EXISTS ( bla bla bla )
		    RETURN 1;
	    RETURN 0;
    END
    GO

I want to use it in a  procedure in this way:

    IF dbo.CheckIfSFExists( 23 ) = 0
	    SET @retValue = &#39;bla bla bla&#39;;

But I get the error:

&gt; An insufficient number of arguments were supplied for the procedure or function dbo.CheckIfSFExists.

Why does it not work?

T-SQL - function with default parameters

I have this script:
<pre><code class="hljs language-less">CREATE FUNCTION dbo.CheckIfSFExists(@param1 INT, @param2 BIT = 1 )
RETURNS BIT
AS
BEGIN
 IF EXISTS ( bla bla bla )
	 RETURN 1;
 RETURN 0;
END
GO
</code></pre>
I want to use it in a procedure in this way:
<pre><code class="hljs language-ini">IF dbo.CheckIfSFExists( 23 ) = 0
 SET @retValue = 'bla bla bla';
</code></pre>
But I get the error:
> An insufficient number of arguments were supplied for the procedure or function dbo.CheckIfSFExists.
Why does it not work?

Using T-SQL, how would I go about getting the **last 3** characters of a varchar column?

So the column text is **`IDS_ENUM_Change_262147_190`** and I need **`190`**

T-SQL Substring - Last 3 Characters

    SELECT logcount, logUserID, maxlogtm
       , DATEDIFF(day, maxlogtm, GETDATE()) AS daysdiff
    FROM statslogsummary
    WHERE daysdiff &gt; 120

I get

&gt; &quot;invalid column name daysdiff&quot;.  

Maxlogtm is a datetime field.  It&#39;s the little stuff that drives me crazy.

Referring to a Column Alias in a WHERE Clause

In SQL Server 2008 I have a table **CUSTOMERS** that has two columns as:

**ID,
BALANCE**

How can I write the query that selects the ID of the customer who has maximum balance, &quot;*in the most effective way*&quot;?

Option 1: `ORDER BY BALANCE and SELECT TOP(1)` --&gt; costs too much.

Option 2: Firstly `Get MAX amount`, then make another query that uses the amount in `where clause` --&gt; costs too much and not seem reliable.

Selecting a Record With MAX Value

I am using Views in my stored Procedure(SQL-Server). For Improving Performance, I have tried to created INDEX of that View.

    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    ALTER VIEW VW_Table_Name
    AS
    SELECT Col1,Col2,Col3 FROM Table_Name 
    GO
    CREATE UNIQUE CLUSTERED INDEX Index_Name ON [VW_Table_Name](Col1)
    GO

Here I am getting the Error like

&gt;Msg 1939, Level 16, State 1, Line 1
Cannot create index on view &#39;VW_FML&#39; because the view is not schema bound.

Can we created Index for View in SQL Server ?

Cannot create index on view &#39;View_Table_Name&#39; because the view is not schema bound

Regarding SQL Server, I understand :

- `var` means the memory is lazy allocated, meaning it fits to the data exactly (on insertion).

- `MAX` means there is no size restriction\limitation.

Then, is it always preferable to use `MAX` when using `varchar`, as we don&#39;t allocate the whole size anyhow?

Should we use a constant size only if there is a constraint we want to enforce on this DB column?

Is varchar(MAX) always preferable?

I&#39;m trying to ask the user to enter numbers that will be pushed into a vector,
then using a function call to count these numbers.

why is this not working?  I&#39;m only able to count the first number.

    template &lt;typename T&gt;
    void write_vector(const vector&lt;T&gt;&amp; V)
    {
       cout &lt;&lt; &quot;The numbers in the vector are: &quot; &lt;&lt; endl;
      for(int i=0; i &lt; V.size(); i++)
        cout &lt;&lt; V[i] &lt;&lt; &quot; &quot;;
    }
    
    int main()
    {
      int input;
      vector&lt;int&gt; V;
      cout &lt;&lt; &quot;Enter your numbers to be evaluated: &quot; &lt;&lt; endl;
      cin &gt;&gt; input;
      V.push_back(input);
      write_vector(V);
      return 0;
    }

How to cin values into a vector

Is there a way to let a javascript function know that a certain parameter is of a certain type?

Being able to do something like this would be perfect:

    function myFunction(Date myDate, String myString)
    {
        //do stuff
    }

Thank you!

**Update**: Being that the answer is a resounding &quot;no,&quot; if I want `myDate` to be treated as a date (in order to call date functions on it), I have to cast it as a date inside the function or set a new variable of type Date to it?

Set type for function parameters?

I have functions in a &#39;library&#39; file to be called from my &#39;worker&#39; script. 

**Library File**

    function ShowMessage($AValue)
    {
      $a = new-object -comobject wscript.shell
      $b = $a.popup( $AValue )
    }
    
    
**Worker File**

    . {c:\scratch\b.ps1}
    
    ShowMessage &quot;Hello&quot;

Running the &#39;worker&#39; script works fine when in the PowerShell IDE but when I right-click the worker file and choose &#39;Run with PowerShell&#39; it cannot find the function &#39;ShowMessage&#39;. Both files are in the same folder. What might be happening?







Call a function in another script when executing using &#39;Run With PowerShell&#39;

I&#39;m looking to write a function that takes an array of pages/categories (from a flat database result) and generates an array of nested page/category items based on the parent ids. I would like to do this recursively, so that any level of nesting can be done.

For example: I&#39;m fetching all the pages in one query, and this is the what the database table looks like

    +-------+---------------+---------------------------+
    |   id  |   parent_id   |           title           |
    +-------+---------------+---------------------------+
    |   1   |       0       |   Parent Page             |
    |   2   |       1       |   Sub Page                |
    |   3   |       2       |   Sub Sub Page            |
    |   4   |       0       |   Another Parent Page     |
    +-------+---------------+---------------------------+
 

And this is the array I would like to end up with to process in my view files:

    Array
    (
        [0] =&gt; Array
    	    (
    			[id] =&gt; 1
    			[parent_id] =&gt; 0
    			[title] =&gt; Parent Page
    			[children] =&gt; Array
    						(
    							[0] =&gt; Array
    								(
    									[id] =&gt; 2
    									[parent_id] =&gt; 1
    									[title] =&gt; Sub Page
    									[children] =&gt; Array
    												(
    													[0] =&gt; Array
    														(
    															[id] =&gt; 3
    															[parent_id] =&gt; 1
    															[title] =&gt; Sub Sub Page
    														)
    												)
    								)
    						)
    	    )
    	[1] =&gt; Array
    		(
    			[id] =&gt; 4
    			[parent_id] =&gt; 0
    			[title] =&gt; Another Parent Page
    		)
    )


I&#39;ve looked and tried nearly every solution I&#39;ve come across (there&#39;s a lot of them here on Stack Overflow, but have had no luck getting something generic enough that will work for both pages and categories.

Here&#39;s the closest I&#39;ve gotten, but it doesn&#39;t work because I&#39;m assigning the children to the first level parent.

    function page_walk($array, $parent_id = FALSE)
    {	
    	$organized_pages = array();
	
    	$children = array();
	
    	foreach($array as $index =&gt; $page)
    	{
    		if ( $page[&#39;parent_id&#39;] == 0) // No, just spit it out and you&#39;re done
    		{
    			$organized_pages[$index] = $page;
    		}
    		else // If it does, 
    		{		
    			$organized_pages[$parent_id][&#39;children&#39;][$page[&#39;id&#39;]] = $this-&gt;page_walk($page, $parent_id);
    		}
    	}

    	return $organized_pages;
    }

    function page_list($array)
    {		
    	$fakepages = array();
    	$fakepages[0] = array(&#39;id&#39; =&gt; 1, &#39;parent_id&#39; =&gt; 0, &#39;title&#39; =&gt; &#39;Parent Page&#39;);
    	$fakepages[1] = array(&#39;id&#39; =&gt; 2, &#39;parent_id&#39; =&gt; 1, &#39;title&#39; =&gt; &#39;Sub Page&#39;);
    	$fakepages[2] = array(&#39;id&#39; =&gt; 3, &#39;parent_id&#39; =&gt; 2, &#39;title&#39; =&gt; &#39;Sub Sub Page&#39;);
    	$fakepages[3] = array(&#39;id&#39; =&gt; 4, &#39;parent_id&#39; =&gt; 3, &#39;title&#39; =&gt; &#39;Another Parent Page&#39;);
	
    	$pages = $this-&gt;page_walk($fakepages, 0);

    	print_r($pages);
    }

Recursive function to generate multidimensional array from database result

Searching for appropriate answer proved difficult because of the existence of many other problems related to my keywords, so I&#39;ll ask this here.

As we know, functions in javascript are objects and they have their own properties and methods (more properly, function istances, inherited from Function.prototype).

I was considering adding custom properties for one function (method), let&#39;s skip the &quot;why?&quot; part and go straight to the code:

    var something = {
        myMethod: function () {
            if (something.myMethod.someProperty === undefined) {
                something.myMethod.someProperty = &quot;test&quot;;
            }
            console.log(something.myMethod);
        }
    }

When inspected with Firebug&#39;s DOM explorer, the property is defined as expected. However, as I don&#39;t consider myself a javascript expert, I have the following questions:

 1. Can this method be considered &quot;proper&quot; and standards compliant? It works in Firefox but there are many things working as expected in web browsers and aren&#39;t by any means standards.
 2. Is this kind of altering objects by adding new properties to them a good practice?


Adding custom properties to a function

&gt; **Possible Duplicate:**  
&gt; [default value of parameter as result of instance method](https://stackoverflow.com/questions/13075044/default-value-of-parameter-as-result-of-instance-method)  

&lt;!-- End of automatically inserted text --&gt;

While it is possible to set default values to function parameters in python:

    def my_function(param_one=&#39;default&#39;)
        ...

It seems not to be possible to access the current instance (self):

    class MyClass(..):

        def my_function(self, param_one=self.one_of_the_vars):
            ...

My question(s): 

* Is this true that I cannot access the current instance to set the default parameter in functions?
* If it is not possble: what are the reasons and is it imaginable that this will be possible in future versions of python?

 

Using an attribute of the current class instance as a default value for method&#39;s parameter

Please explain to me why the following piece of code complies and works perfectly.
I am very confused.

    #include&lt;iostream&gt;
    template&lt;class A = int, class B=double&gt;
    class Base
    {};
    
    template&lt;class B&gt;
    class Base &lt;int, B&gt;
    {
    public:
      Base()
      {
         std::cout&lt;&lt;&quot;it works!!!!!\n&quot;;
      }
    };

    int main()
    {
      Base&lt;&gt; base; // it prints &quot;it works!!!!!&quot;
      return 0;
    }

Shouldn&#39;t it fall into the generalized form of the template class Base?


Default template parameter partial specialization

For example, if I have the following data class:

    data class Data(
        val name: String = &quot;&quot;,
        val number: Long = 0
    )

And functions that can return `null`:

    fun newName(): String? {}

    fun newNumber(): Long? {}

I know I can use the following to use the value of the functions if they are not `null`:

    val newName = newName()
    val newNumber = newNumber()

    val data = Data(
            if (newName != null) newName else &quot;&quot;,
            if (newNumber != null) newNumber else 0
    )

But is there a way to just use the default value specified in the constructor of the `Data` class when the values are `null`?

I could not find anything in the documentation, but I was hoping something like this would work:

    val data = Data(newName()?, newNumber()?)

But that does not compile.

Content Type	Original Author	Original Content on Stackoverflow
Question	nirmus	View Question on Stackoverflow
Solution 1 - Tsql	SQLMenace	View Answer on Stackoverflow
Solution 2 - Tsql	Douglas Osborne	View Answer on Stackoverflow
Solution 3 - Tsql	Curtis	View Answer on Stackoverflow
Solution 4 - Tsql	Jereme Guenther	View Answer on Stackoverflow

T-SQL - function with default parameters

Tsql Problem Overview

Tsql Solutions

Solution 1 - Tsql

Solution 2 - Tsql

Solution 3 - Tsql

Solution 4 - Tsql

Turn on IncludeExceptionDetailInFaults (either from ServiceBehaviorAttribute or from the <serviceDebug> configuration behavior) on the server

How to dismiss the dialog with click on outside of the dialog?

Attributions