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'
)




© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited

PrevNext