Database

Spawn@Melmac wrote:

could this be integrated into the ACCESSOR class mechanism I am using at present?

Spawn@Melmac wrote:

So when I came across the @@IDENTITY I thought I was sorted

using (var con = new SqlCeConnection(connectionString))
using (var cmd = new SqlCeCommand())
{
  con.Open();
  cmd.Connection = con;
  cmd.CommandText = "INSERT ...";
  cmd.ExecuteNonQuery();

  // execute a second command;
  cmd.Parameters.Clear();
  cmd.CommandText = "SELECT @@IDENTITY";
  object recordId = cmd.ExecuteScalar();
}

I are Troll

class CDBHubDetails
{
public:
// Data Elements
	TCHAR	f_LocSub[255];
	int		f_HubID;						// Input field

// Column binding map
BEGIN_COLUMN_MAP(CDBHubDetails)
   COLUMN_ENTRY(1, f_LocSub)
END_COLUMN_MAP()

// Parameter binding map
BEGIN_PARAM_MAP(CDBHubDetails)
   SET_PARAM_TYPE(DBPARAMIO_INPUT)
   COLUMN_ENTRY(1, f_HubID)
END_PARAM_MAP()

DEFINE_COMMAND_EX(CDBHubDetails, L" \
     SELECT  Hub.SubLoc \
     FROM    Location  \
     WHERE   Hub.id = ?")
};

CCommand<CAccessor<CDBHubDetails > > rs;

rs.f_HubID = pHub->m_iHubID;                                                 // pull the HubID from the CDevice object
hr = rs.Open(m_oDB->session);

d@nish wrote:

Other problem with ODP is that you have to dispose everything and I really mean everything you have created or your server would be down after some duration.

FEMDEV wrote:

what are it's pros cons?

I are Troll

update mytable set column='value' 
where id in (select id from mytable   group by id having (count(id)>1))

Update myItems<br />
set myField = 'more than 1 count'<br />
where item_class in <br />
(<br />
select item_class<br />
from myItems<br />
group by item_class<br />
having count(*) > 1<br />
)

solomon85 wrote:

split the data sent in a SELECT query?

DECLARE TblCursor CURSOR FOR

SELECT
    [name]
FROM
    sys.objects
WHERE
    [name] like '%' + @fnd + '%'
    and is_ms_shipped = 0
    and [type] = 'P'

OPEN TblCursor
FETCH next FROM TblCursor INTO @proc
WHILE @@fetch_status = 0
BEGIN

    SET @sql = 'DROP PROCEDURE ' + @proc

    EXEC @sql

    FETCH next FROM TblCursor INTO @proc
END
CLOSE TblCursor
DEALLOCATE TblCursor