HOW TO ASSIGN VALUE TO PARAMETERS USED IN QUERY WHICH IS STORED IN A VARIABLE

DECLARE
  /* @STRQUERY AND @PARAMDEF SHOULD BE NVARCHAR
     BECAUSE "EXECUTE sp_executesql" ACCEPTS STATEMENT AND PARAMETER OF TYPE 'ntext/nchar/nvarchar' ONLY
     OTHERWISE
     "Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'."
     OR
     "Procedure expects parameter '@parameters' of type 'ntext/nchar/nvarchar'."  WILL BE RAISED*/
  @STRQUERY AS NVARCHAR(200),
  @STRNAME AS VARCHAR(100),
  @PARAMDEF AS NVARCHAR(100),
  @STRNAMEVALUE AS VARCHAR(100)
BEGIN
    --FOLLOWING STATEMENT ASSING VALUE
     SET @STRNAMEVALUE='MANINDER'
    --FOLLOWING VARIABLE CONTAINS A QUERY WHICH USES A PARAMETER
    SET @STRQUERY = 'SELECT ''YOUR NAME IS '' + @STRNAME'

    --FOLLOWING STATEMENT DEFINES THE PARAMETERS USED IN THE QUERY
    SET @PARAMDEF = '@STRNAME AS VARCHAR(100)'

    --IN THE FOLLOWING STATEMENT "@STRNAME = @STRNAMEVALUE" STATEMENT ASSIGNS VALUE TO THE PARAMETER
    --SYNTAX IS EXECUTE sp_executesql @STATEMENT, @PARAMETERS
    EXECUTE sp_executesql @STRQUERY, @PARAMDEF,@STRNAME = @STRNAMEVALUE;
END

A look at the difference between Convert.ToString() and .ToString() method.

 Below example clears the confusion between the usage of both the method. Thus developers will it appropriately

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace ExampleOfString
{
    class Program
    {
        static void Main(string[] args)
        {
            String UserName = null ;
            try
            {
                //Below statement WILL THROW an exception as .ToString() does not handles null values
                String strUserId = UserName.ToString();
            }
            catch (NullReferenceException ex)
            {
                Console.WriteLine("Error:{0}", ex.Message);
            }

            try
            {
                //Below statement WILL NOT THROW an exception as convert.tostring handles implicitly
                String strUserId = Convert.ToString(UserName);
                Console.WriteLine("UserName:{0}", strUserId);
            }
            catch (NullReferenceException ex)
            {
                Console.WriteLine("Error:{0}", ex.Message);
            }
        }
    }
}

/*
Below is the output of the console application

Error:Object reference not set to an instance of an object.
UserName:
Press any key to continue . . .
*/

Trim function in javascript to replaces leading and trailing spaces

 A simple trim function in javascript, which replaces leading and trailing spaces.

You can define a trim function which trims leading and trailing space in javascript by using any one of the following way:

way 1:

String.prototype.trim = function() 

{  return this.replace(/^\s+|\s+$/g, '');  }

way 2:

function trim()
{
 return this.replace(/^\s+|\s+$/g, ''); 
}

Following function shows how to use the trim function

function temp()
{
 var str='    maninder     ';
 alert(str.trim());
}

you will see 'maninder' in the alert box. All the leading and trailing space are trimmed