.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Imran Ghani
Post New Web Links

ISNULL Function requires 2 Arguments

Posted By:      Posted Date: September 27, 2010    Points: 0   Category :Sql Server


Decalre @international SMALLINT

I am Getting @International from some other table in my cursor

Then i am doing an Insert

The requirement is if @international is NULL it should be 'N'

If it is not null then it should insert @international value from what ever joined tables


Insert Into Table_XYZ

Values(1,'Abc','USA',ISNULL(@International,'N',@international) )


Error:THE ISNULL Function requires 2 Arguments....


Can some me helpm on this...





View Complete Post

More Related Resource Links

SharePoint - Passing Dataview Row Arguments to a C# function from a button

RE: SharePoint - Passing Dataview Row infomration to a C# function I've done this with a asp.net Gridview. but does anybody have any examples on how to pass row information from an asp.net button in  SharePoint Dataview rows to an inline C# function? the button Repeats as follows: <asp:Button runat="server" Text="Delete" id="Delete{@ID}"  OnClick="DeleteDoc()"/> My function looks like this: void DeleteDoc(object sender, EventArgs e) { } I tried adding another parameter but get: No overload for 'DeleteDoc' matches delegate 'System.EventHandler' Thank you.

Procedure or function ... has too many arguments specified


When i execute this SP in DB, it works fine. But when i execute from asp.net app it is throwing error:

Procedure or function ... has too many arguments specified


ALTER PROC [dbo].[sp_Customer]

@brchID char(40),
@brchName VARCHAR(50),
@userID VARCHAR(50)



DECLARE @req_pk  int
DECLARE @customer_org_pk int

IF EXISTS(SELECT * FROM [customer] WHERE [org_id] like @brchID)

    SELECT [org_pk] FROM [customer] WHERE [org_id] like @brchID


    EXEC sp_get_next_control_no 'organization.org_pk',@customer_org_pk out;
    INSERT INTO [customer] (org_pk,[org_id],[org_name])
    SELECT [org_pk] FROM [customer] WHERE [org_id] like @brchID

--Address Book Entry

IF NOT EXISTS(SELECT * FROM [address_book] WHERE [prsn_id] like @userID)

    exec sp_get_next_control_no 'person.prsn_pk',@req_pk out;

IF (@@ERROR <> 0)


Use function name twice with different arguments


The question is about WCF and WSE.

I`m looking for a way to re-use the function name for a different function.


Public Function Call(Byval iActivationCode as String) as String
Public Function Call(Byval iUser as Integer, Byval iProductNumber As Integer) as String

If it`s not possible, how does everyone else do this?
- create a request object (check inside the function for the filed fields, its not the right way i think)
- create they two different functions with different names (You get a lot of different and long function names)
- rename the functions for remote users (i don`t prefer this becaus you lose the compiler functionality and overview)


Procedure or function proc_SecGetIndividualUrlSecurityCheckEventReceivers has too many arguments spe


When upgrading from december 2009 CU update to the latest to date (office-kb2276472-fullfile-x86-glb & wss-kb2276474-fullfile-x86-glb) for MOSS 2007 i get an error when I try to delete a file. In the logs the following lines appear:

Unexpected query execution failure, error code 8144. Additional error information from SQL Server is included below. "Procedure or function proc_SecGetIndividualUrlSecurityCheckEventReceivers has too many arguments specified." Query text (if available): "{?=call proc_SecGetIndividualUrlSecurityCheckEventReceivers(?,?,?,?,?,?,?,?,?,?,?,?,?,?)}"

I already ran the SharePoint Products and Technologies Configuration Wizard several times but no result. I noticed that sharepoint gives 14 parameters and the stored procedure only takes 13 parameters...

Any suggestions?

Procedure or Function has too many arguments..


I m new with asp.net language & i m working with ASP.NET 3.5. I m using SQL server 2005. My Stored procedure is execute properly in SQL But when i call the SP & insert data in asp.net at that time the error occurs "Procedure or Function has too many arguments specified." This error occurs in so many pages. Please help me i m very confused what to do. Please solve my problem..


My Stored procedure is:

ALTER PROCEDURE [dbo].[insert_skill]
    @skill_name varchar(20)=null,
    @description varchar(100)=null
INSERT INTO skill_master


My C# code is:

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class Skill_Master : System.Web.UI.Page
    SkillBean obj = new SkillBean();

Passing multiple arguments from a listview to a JavaScript function


Hello, I have been stuck on how to pass multiple to a JavaScript function in a item template of a list view. Below is my code. Does anyone know the process? Thank you.


                            <td style="width: 114px; height: 139px;">

                                <div style="width: 105px; height: auto">

                                    <img alt="" id="Image7" runat="server" src='<%# DataBinder.Eval(Container.DataItem,"images")%>'

                                        width="100" height="125" border="0" onmouseover='"javascript:show(<%# DataBinder.Eval(Container.DataItem,"images")%>)","(<%# DataBinder.Eval(Container.DataItem,"filename")%>)","(<%# DataBinder.Eval(Container.DataItem,"caption")%>)",1,234'

Query failed for dataset + The LEFT function requires 2 argument(s).


Hi all,

I have a dataset 'DS1' below;which is working fine when i execute the query.

SELECT   Distinct Name
FROM   Project_RPT
WHERE [MonthName]  IN (LEFT(@Month,charindex(' ',@Month)))
AND [YEAR]  IN ( right(@Month,len(@Month)-charindex(' ',@Month)   ) )

 -->@Month parameter gives values as follows:

MAY 2010,MARCH 2010..etc

But when I tried to preview the report, Its giving error :

Query failed for dataset  'DS1' . The LEFT function requires 2 argument(s).

Can anyone help me on this?



Procedure or function CurrentHistoryHsttblSave_sp has too many arguments specified



I am trying to use SQL Server 2008 R2 with VS 2010 Pro, VB on a standalone Windows XP, Pro, SP3 computer to execute a stored procedure from a database using this code:

    Public Shared Function ExecuteNonQuery( _

            ByVal storedProcedureName As String, _

            ByVal ParamArray arrParam(

Procedure or function sp_MSenumchanges has too many arguments specified


I'm using SQL Server 2000 SP4 Enterprise Edition. I created a Merge Replication and a push subscription. I got the follow error message in Merge Agent:

Message: The process could not enumerate changes at the 'Publisher'.
Percent Complete: 0
Source:  Failed Command
Number:  0
Message: {call sp_MSenumchanges(?,?,?,?,?,?,?,?,?)}
Percent Complete: 0
Source:  WINSVR2003N
Number:  8144
Message: Procedure or function sp_MSenumchanges has too many arguments specified.

Anybody knows how to solve it?

VBScript IsNull() function not working as I expect



I've written some VBScript code that takes an incoming integer that represents NumberOfSeconds and converts it to a time in words (e.g. "1d 3 h 34m 6s"). The code is below, unfortunately its failing with an error:

 "There is an error on line 2 of custom code : [BC30451] Name 'IsNull' is not declared."

Any ideas?

Thanks in advance

Function TimeInWords (RemainderTimeInSeconds as Integer) AS String
	Dim ReturnValue As String
	IF (IsNull(RemainderTimeInSeconds) = True)
		RemainderTimeInSeconds = 0
	IF (RemainderTimeInSeconds > 86400)
		ReturnValue = TimeInDays(RemainderTimeInSeconds )
	ELSE IF (RemainderTimeInSeconds > 3600)
		ReturnValue = TimeInHours(RemainderTimeInSeconds )
	ELSE IF (RemainderTimeInSeconds > 60)
		ReturnValue = TimeInMinutes(RemainderTimeInSeconds )
		ReturnValue = TimeInSeconds(RemainderTimeInSeconds )
	End If
	Return ReturnValue
End Function

Function TimeInDays (RemainderTimeInSeconds AS Integer) AS String
	Return CStr(Round(RemainderTimeInSeconds / 86400)) + "d " + TimeInMinutes(RemainderTimeInSeconds Mod 86400)
End Function
Function TimeInHours (RemainderTimeInSeconds AS Integer) AS String
	Return CStr(Round(RemainderTimeInSeconds / 3600)) + 

Using the generic type 'System.Collections.Generic.IEnumerable' requires '1' type arguments



I'm trying to create a control out of a class I found, and one of the overridden functions is the following:

protected override void PerformDataBinding(IEnumerable data)

However, when I try to build the control I'm getting the error as shown in the subject. I've tried searching, and it seems the signature for the original function matches the one I have, and all other solutions I've seen uses the same signature.

Anyone able to help out?

Procedure or function has too many arguments specified - IN DESPERATE NEED OF IMMEDIATE ASSISTANCE!!


I have a stored procedure that was previously working but has since stopped since I imported date into the table that it should be altering.

The purpose of this stored proc is to take new patient data input by user and add data to new record in patient table and generate and output the new patients ID number.  But now upon execution I recieve the error msg: Procedure or function has too many arguments specified.  This is a critical and time sensitive issue so ANY assistance would be appreciated.


USE [Clinic2]
/****** Object:  StoredProcedure [dbo].[usp_InsPatient]    Script Date: 05/10/2011 10:16:43 ******/
-- Batch submitted through debugger: SQLQuery13.sql|7|0|C:\Users\Administrator\AppData\Local\Temp\1\~vsC167.sql
ALTER PROCEDURE [dbo].[usp_InsPatient]
 @LastName nvarchar(30),
 @FirstName nvarchar(30),
 @Street nvarchar(35),
 @City nvarchar(20),
 @State nvarchar(2),
 @Zip int,
 @DOB nvarchar(50),
 @PatientID int output
 --@err varchar(250) = null output

-- usp_InsPat 'test','ltest',null,null,null,null,'10/25/2010'

declare @err as varchar(100)
if @Firstname IS

Content page control passes as argument to javascript function


Here is the content page:


<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="JavaDynamicCopyValue.aspx.cs" Inherits="JavaDynamicCopyValue" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
 <script type="text/javascript" >
 function copyValue(input, output )
   ouput.value = input.value;
   return true;
 <asp:TextBox ID="txt1" runat="server" onchange="copyValue(this,document.getElementById('<%=txt2.ClientID%>'))"></asp:TextBox>
    <br />
    <br />
    <asp:TextBox ID="txt2" runat="server"></asp:TextBox>


I got a javascript run time error says output is undefined. if I view source of the page, the txt1 markup became:

<input name="ctl00$ContentPlaceHol

connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly.


I dont have the SQL EXPRESS installed instead I have SQL Standard Edition.

 I have two SQL Server instances installed.

 1- UserLT (this is sql 2000)
2- UserLT\SQL2005 (this is SQL 2005 named instance)

But when i try to add a database to my VS website project I get the following error:

Connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=4925

I went in Tools>Opetions>DataBase tools>Data Connection>Sql Server Instance Name (blank for default)

and changed the "SQLEXPRESS" to "USERLT\SQL2005".

But I still get the same error message. Any ideas how i can resolve this issue?

Public Shared function doubt????

I am using VB.net/ASP.NET and SQL Server 2000 for a web application.

For populating the dropdowns, I wrote a Public Shared function LoadDDL(), in which I pass the dataset and dropdown name to set.

I have my doubts that this function will produce unexpected results for concurrent users. And will mix the results among sessions because it is a Shared function.

I am confused here. Is it the right way to go?

Please advice. Thanks in advance.


Trim function in C Sharp

How do i use "trim" function in C Sharp? I have a string and i want to strip off spaces from the end of the string. Any idea how do i do it??


Pure C++: Invoking Generic or Function Templates


As I promised last time, in this month's column I'll walk through the process of defining and invoking a generic or template function under C++\CLI. A function template or a generic function begins with the template or generic keyword followed by its parameter list.

Stanley B. Lippman

MSDN Magazine October 2005

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend