ITEM_IDENTITY

        public int InsertRecord(XXXXXX)
        {

            int RowNO = -1;

            string stSQL = string.Empty;
            try
            {
                stSQL = "INSERT INTO XXXXXXXX("
                                     + "UpdateDateTime, "
     
                        + ")  VALUES ( "
                                   +  "'20120530'"
                                  + ")";
                stSQL = stSQL + "select cast(ITEM_IDENTITY() AS int)";
                Cmd.CommandText = stSQL;

                RowNO = (int)Cmd.ExecuteScalar();

                return RowNO;
            }
        }