Database

LTM_it_kh wrote:

I want to protect this user, not allow him to delete any object such as database, table , view, function...

Can anyone help me please, I'm really stuck with searching...

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

SELECT tt.IdAmlak, tt.ParentId, tt.NameOpp, tt.Price, tt.[Square],
       tt.OstanShahrMantagha, tt.PhoneAddress, tt.CountAmount
INTO TestTable
FROM tblTesting tt

tblTesting :  Table in database Sql Server 2008 in server internet <br />
TestTable  :  Table in Database SQLite in local (android mobile)

csv file and processing it locally

if you can have an ODBC connection to the server on the web, and one to the android device

insert into CRM-CMS.dbo.tableName
select * from [217.66.216.77,1633].CRM-CMS.dbo.tblTesting

cmd.CommandText = @"SELECT top(5)  IdAmlak, ParentId, NameOpp, Price, [Square],
       OstanShahrMantagha, PhoneAddress, CountAmount
    INTO Melk
FROM      OPENDATASOURCE(
         'SQLOLEDB',
         'Data Source=217.66.216.77,1633;User ID=tinadbuser;Password=dbtin123ir'
                 ).[CRM-CMS].dbo.tblTesting";

i got this code :
but cannot run for SQLite :

i get this error in sqlite :

<code>SQLite error near "INTO" : syntax error </code>


<pre lang="sql">cmd.CommandText = @&quot;SELECT top(5)  IdAmlak, ParentId, NameOpp, Price, [Square],
       OstanShahrMantagha, PhoneAddress, CountAmount
    INTO Melk
FROM      OPENDATASOURCE(
         &#39;SQLOLEDB&#39;,
         &#39;Data Source=217.66.216.77,1633;User ID=tinadbuser;Password=dbtin123ir&#39;
                 ).[CRM-CMS].dbo.tblTesting&quot;;</pre>

Insert Melk (field, names, list) Select ...

select sum(iif(FIELDNAME = 'Bundle', 1, 0)) as NumBundles,  
sum(iif(FIELDNAME = 'Bowed Board', 1, 0)) as NumBowedBoards,  
sum(iif(FIELDNAME = 'Jam', 1, 0)) as NumJams  
from TABLENAME