Code:
USE Northwind
SELECT * FROM Customers
CREATE PROCEDURE dodaj_u_customer
(
@ID nvarchar(5),
@imeKompanije nvarchar(40)
)
AS BEGIN
INSERT INTO Customers(CustomerID, CompanyName)
VALUES (@ID, @imeKompanije)
END
-- iz AdventureWorks2012 prebaciti u Customers u Northwind bazi podataka
EXEC dodaj_u_customer SELECT TOP 1 '111', [FirstName]
FROM [AdventureWorks2012].[Person].[Person]
ORDER BY NewID()
USE Northwind
SELECT * FROM Customers
CREATE PROCEDURE dodaj_u_customer
(
@ID nvarchar(5),
@imeKompanije nvarchar(40)
)
AS BEGIN
INSERT INTO Customers(CustomerID, CompanyName)
VALUES (@ID, @imeKompanije)
END
-- iz AdventureWorks2012 prebaciti u Customers u Northwind bazi podataka
EXEC dodaj_u_customer SELECT TOP 1 '111', [FirstName]
FROM [AdventureWorks2012].[Person].[Person]
ORDER BY NewID()
Pomoć, kako da izvršim prebacivanje podataka iz AdventureWorks2012 u tabelu Customers u Northwind bazi podataka?