sql query export data from local database to online database

       IF NOT EXISTS(SELECT * FROM master.dbo.sysservers
        WHERE srvname='OnlineSqlServerName')
         BEGIN
            EXEC sp_addlinkedserver 'OnlineSqlServerName',N'Sql server'
         END
   EXEC sp_addlinkedsrvlogin 'OnlineSqlServerName','false','sa','OnlineSqlUser','onlineSqlPwd'
INSERT INTO [OnlineSqlServerName].OnlineDatabase.dbo.OnlineTable(column1,column2,column3,column4,column5,column6)
 SELECT column1,column2,column3,column4,column5,column6
 from [dbo].[LocalTable]

 Example:
 ---------------------
        IF NOT EXISTS(SELECT * FROM master.dbo.sysservers
        WHERE srvname='898.9.999.996')
         BEGIN
            EXEC sp_addlinkedserver '898.9.999.996',N'Sql server'
         END
   EXEC sp_addlinkedsrvlogin '898.9.999.996','false','sa','Retailuser','ms12345'


INSERT INTO [898.9.999.996].dbRetail.dbo.Mst_EmployeeMast(EmpName,Addresss,city,mob,dob,statuss)
 SELECT EmpName,Addresss,city,mob,dob,statuss
 from [dbo].[EMP] 

C# Random number

 protected void btnRandom_Click(object sender, EventArgs e)
    {
        Random Rnumber = new Random();
       // int x = Rnumber.Next(maxValue);
        int RandommaxValue = Rnumber.Next(99999999);
        //int RandomMaxMinValue = Rnumber.Next(MinVal, MaxVal);
        int RandomMaxMinValue = Rnumber.Next(0,99999999);
        Response.Write(RandommaxValue);
    }

c# Join and Split String

 string[] Arr = { "Microsoft", "IBM", "Oracle" };    
        // ... Join strings into a single string.
        string joinedString = string.Join("|", Arr);
        Response.Write("joined :"+"<br>");
        Response.Write(joinedString + "<br>");// Result Microsoft|IBM|Oracle
        Response.Write("Splits :" + "<br>");
        string[] SplitArr = joinedString.Split('|');
        Response.Write(SplitArr[0]);// Result Microsoft

c# Array last item,first Item index of

 string[] myarray = { "Pabi", "Pabitra", "Gitu", "Ram" };

               //Find First Element of an array
               //---------------------------------    
               Response.Write(myarray[0].ToString());
               // Last Element
               //-----------------
               int totalLength = myarray.Length;
               int LastItemIndex = totalLength - 1;
               Response.Write(myarray[LastItemIndex].ToString());

                 ////Index of an Array
                //-----------------
                //     Tips:
               //IndexOf methods return -1 when no element is found. This value often must be checked in an if-statement.
               int PositionOfIndex = Array.IndexOf(myarray, "Pabi");
               Response.Write(myarray[PositionOfIndex]);

c# Array looping and array length

protected void btnArrayForloop_Click(object sender, EventArgs e)
    {
        string[] array = new string[3];
        array[0] = "Thanks";
        array[1] = "Pabitra";
        array[2] = "Behera";
        for (int i = 0; i < array.Length; i++)
        {
            // Get element by index.
            string element = array[i];
            Response.Write(element);
        }
        Console.WriteLine(); // Write blank line.
        foreach (string element in array)
        {
            // Cannot assign element in this loop.
            Response.Write(element);
        }

//Array Length
Response.Write(array [array .Length - 1]);
    }

Array Declaration in c#

///Array Declaration
        string[] array = new string[3];
        string[] array1 = new string[]{};
        string[] array13 = {};
        string[] arr = new string[]
   {
   "cat",
   "dog",
   "panther",
   "tiger"
};

Join in array element

   protected void Button1_Click(object sender, EventArgs e)
    {
        Response.Write(string.Join(" ", Method()));
    }


static string[] Method()
    {
        string[] array = new string[3];
        array[0] = "THANK";
        array[1] = "YOU";
        array[2] = "Pabitra";
       // string[] array = {"THANK","YOU","Pabitra"};
       
        return array;
    }
  

What is var in c#

Var:The var type is an implicitly-typed local variable. It is the same to the compiler as an explicit string array.

execute dynamic sql command in sql server 2008

DECLARE @sqlCommand varchar(1000)
DECLARE @columnList varchar(75),@G_Id int
DECLARE @city varchar(75)
SET @columnList = 'a.Id,a.Name,a.City,a.G_Id'
SET @city = '''bbsr'''
set @G_Id=1
SET @sqlCommand = 'SELECT ' + @columnList + ' FROM mytable a
 WHERE a.City='+@city+'and a.G_Id='+convert(varchar,@G_Id)
 --print @sqlCommand
EXEC (@sqlCommand)

execute dynamic sql command in sql server 2008

DECLARE @sqlCommand varchar(1000)
DECLARE @columnList varchar(75),@G_Id int
DECLARE @city varchar(75)
SET @columnList = 'a.Id,a.Name,a.City,a.G_Id'
SET @city = '''bbsr'''
set @G_Id=1
SET @sqlCommand = 'SELECT ' + @columnList + ' FROM mytable a
 WHERE a.City='+@city+'and a.G_Id='+convert(varchar,@G_Id)
 --print @sqlCommand
EXEC (@sqlCommand)

sql server procedure list on created date

SELECT name,create_date, modify_date
FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,create_date, GETDATE()) < 500
order by create_date asc
-----------------------------------------------------



SELECT
    name,
    create_date,
    modify_date
FROM sys.procedures
order by create_date desc
or
SELECT
    name,
    create_date,
    modify_date
FROM sys.procedures
order by create_date asc









---------------------------
SELECT name
FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,create_date, GETDATE()) < 30
---------------------

2 down vote

SELECT name FROM sys.objects WHERE type = 'P' AND DATEDIFF(D,modify_date, GETDATE()) < 7 -------------------------------------- SELECT name,create_date, modify_date FROM sys.objects WHERE type = 'P' AND DATEDIFF(D,create_date, GETDATE()) < 30

numeric validation in jquery textbox

Only number or validate text box which receive only number in javascript function


 <script type="text/javascript">
function isNumber(evt) {
            evt = (evt) ? evt : window.event;
            var charCode = (evt.which) ? evt.which : evt.keyCode;
            if (charCode > 31 && (charCode < 48 || charCode > 57)) {
                return false;
            }
            return true;
        }
    </script>



For html input Control
-------------------------
<input type="text" id="txtEidNo" onkeypress="isNumber(event)" />



For ASPX TextBox Control
-------------------------
<asp:TextBox ID="txtEidNo" runat="server" onkeypress="return isNumber(event)"></asp:TextBox> 




In jquery 
----------------
For html input Control
------------------------------
<input type="text" id="txtEidNo" />

<script type="text/javascript">
        $(document).ready(function () {
            $("#txtEidNo").keydown(function (e) {
                if (e.shiftKey)
                    e.preventDefault();
                else {
                    var nKeyCode = e.keyCode;
                    //Ignore Backspace and Tab keys    
                    if (nKeyCode == 8 || nKeyCode == 9)
                        return;
                    if (nKeyCode < 95) {
                        if (nKeyCode < 48 || nKeyCode > 57)
                            e.preventDefault();
                    }
                    else {
                        if (nKeyCode < 96 || nKeyCode > 105)
                            e.preventDefault();
                    }
                }
            });
        });
    </script>




For ASPX TextBox Control
-------------------------
<asp:TextBox ID="txtEidNo" runat="server" ></asp:TextBox> 

<script type="text/javascript">
        $(document).ready(function () {
            $("#<%= txtEidNo.ClientID%>").keydown(function (e) {
                if (e.shiftKey)
                    e.preventDefault();
                else {
                    var nKeyCode = e.keyCode;
                    //Ignore Backspace and Tab keys      
                    if (nKeyCode == 8 || nKeyCode == 9)
                        return;
                    if (nKeyCode < 95) {
                        if (nKeyCode < 48 || nKeyCode > 57)
                            e.preventDefault();
                    }
                    else {
                        if (nKeyCode < 96 || nKeyCode > 105)
                            e.preventDefault();
                    }
                }
            });
        });
    </script>