Thanks!!!

PinAnt

Hi, try this

declare @a table (x int null)

insert into @a(x) values (1)

insert into @a(x) values (2)

insert into @a(x) values (3)

insert into

Hi, try this to disable

ALTER TABLE samp_test DISABLE TRIGGER samp_test_update_trigger

and this to enable

ALTER TABLE samp_test ENABLE TRIGGER samp_test_update_trigger

PinAnt

GREAT!!!

Hi all,

try this

SELECT Customers.Cust_Name, accounts.acc_type,

CASE WHEN Accounts.Account_No IS NOT NULL THEN Accounts.Account_No ELSE 'NO ACCOUNT' END

FROM Customers

LEFT OUTER JOIN Accounts

ON Customers.Cust_Name = Accounts.Cust_Name

AND Customers.Location = Accounts.Location

AND ((Customers.Acc_Type = Accounts.Type...

hi,

you can use this syntax

CREATE TRIGGER InsteadTrigger on InsteadView

INSTEAD OF INSERT

AS

BEGIN

.

.

.

Antonio

HI,

the syntax is :

http://FTP.EXE -A -s:e:\a.txt http://ftp.nai.com

where a.txt is:

cd /virusdefs/4.x

prompt

lcd c:mget sdat*.exe sdat*.exe

quit

Bye

Antonio

hi,

sp_help yourtable

Bye

Hi,

in English, please

Bye

HI,

correct syntax is:

INSERT INTO staff (staff.EmployeeName, staff.Adresse)

SELECT EmployeeName, Address FROM Table1

bye Antonio

hi Vijay

if you want some suggestions please contact me!

bye antonio

hi,

after sp_addlinkedserver, you must run sp_addlinkedsrvlogin

bye antonio

HI,

the basic operation to access to SQLServer 2000 with vb is to use ADO.

In your project reference Microsoft Activex Data Object 2.6 or upper.

In you project type something like this.

To...

HI

another tool is DATAJUNCTION

you find at this address: http://www.datajunction.com

bye

Antonio

hi,

I have worked on the statement and i have discoverd this:

Delete from tblItem where field1 in (Select did )

where field1 is a field in the table

this statement is the...