INSERT


INSERT INTO   table_name 
              (column1, column2)
VALUES (value1, value2)

this works in both SQL Server and Access

INSERT INTO zCUSTOMERS 
([CustomerID]
,[Company Name]
,ContactName
,ContactTitle
,Address
,City
,Region
,PostalCode
,Country
,Phone
,Fax
)
VALUES
('AsdKI'
,'Alfreds Futterkiste'
,'Maria Anders'
,'Sales Representative'
,'Obere Str. 57'
,'Berlin'
,NULL
,'34234'
,'Germany'
,'030-0074321'
,'030-0076545'
)



© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext