id,country_code,country_name,long,lat,geom  # point data

Select all Open in new window

id,country_code,country_name,geom  # polygons

Select all Open in new window

UPDATE geo.table
set g.country_code = b.country_code,g.country_name = b.country_name
FROM
geo_table g, boundary b
INNER JOIN on ST_intersect(geo_table.geom, b.geom) 

Select all Open in new window

INSERT INTO [TABLE1] 

SELECT 
         , IET.[From]
         , IET.[To]
 FROM [TABLE2] IET


WHERE [InvoiceItemGUID] NOT IN 
    (SELECT [InvoiceItemGUID] FROM TABLE1 )

Select all Open in new window

public string db_get_unhandled_items_CommandText(int? fromIdPerson, int? toIdPerson, int? fromIditem, int? toIditem)
{
    string IdPerson_cond = get_cond_str(fromIdPerson, toIdPerson, "aa.IdPerson");
    string Iditem_cond = get_cond_str(fromIditem, toIditem, "aa.Iditem");

    return @"
        select bb.Iditem,CONCAT('http://www.mysite.com/Items', replace(r.SourceURL, '\', '/')) urlSource, r.IdResource
        from [MYDB].[dbo].tblitem bb
          inner join [MYDB].[dbo].tblitemPerson aa
            on aa.Iditem = bb.Iditem AND " + Iditem_cond + @"
            inner join [MYDB].[dbo].tblResource r
            on bb.IdPrimaryAsset = r.IdAsset
            left join [dev].[AW_IR].[tblitem_labels] t2 on t2.Iditem = bb.Iditem
        where t2.Iditem is null AND " + IdPerson_cond + @"
        order by Iditem";
}

private static string get_cond_str(int? from, int? to, string Id_column)
{
    string query;
    if (from == null)
    {
        if (to == null)
        {
            query = "1 = 1";
        }
        else
        {
            query = Id_column + " <= " + to;
        }
    }
    else
    {
        if (to == null)
        {
            query = Id_column + " >= " + from;
        }
        else
        {
            query = Id_column + " >= " + from + " AND " + Id_column + " <= " + to;
        }
    }
    return query;
}

declare @mnt1 decimal(18,4), @mnt_r decimal(18,4), @nbr bigint  
  declare @ST_NB_DECIMAL_QTY INT  
  set @mnt1 = 16.60
    select @ST_NB_DECIMAL_QTY = 2
	  set @nbr = POWER(10 ,@ST_NB_DECIMAL_QTY)  
  Set @mnt_r = round(@nbr * @mnt1,@nbr)  
  IF @mnt_r < 0  
  Set @mnt_r = CEILING(@mnt_r)/ @nbr  
  ELSE  
  Set @mnt_r = FLOOR(@mnt_r)/ @nbr  
  Select  @mnt_r

Select all Open in new window

using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;

using System.Collections.Generic;
using System.ComponentModel;

using System.Drawing;
using System.Text;
using System.IO;
using System.IO.Ports;
using System.Threading;
using System.Text.RegularExpressions;
using System;

public partial class StoredProcedures
{
    [Microsoft.SqlServer.Server.SqlProcedure]
    public static void SqlStoredProcedure1(string strPortName, string strBaudRate, String strPhone, String StrMsg)
    {
        try
        {
            bool sms_status;
        SerialPort port = new SerialPort();
        port.PortName = strPortName;
        port.BaudRate = Convert.ToInt32(strBaudRate);               //updated by Anila (9600)
        port.DataBits = 8;
        port.StopBits = StopBits.One;
        port.Parity = Parity.None;
        port.ReadTimeout = 300;
        port.WriteTimeout = 300;
        port.Encoding = Encoding.GetEncoding("iso-8859-1");
        //  port.DataReceived += new SerialDataReceivedEventHandler(port_DataReceived);
        port.Open();
        port.DtrEnable = true;
        port.RtsEnable = true;
        StoredProcedures p = new StoredProcedures();
        sms_status = p.sendMsg(port, strPortName, strBaudRate, strPhone, StrMsg);
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }

    public AutoResetEvent receiveNow;



    //Close Port
    public void ClosePort(SerialPort port)
    {
  

Select all Open in new window