DECLARE @name nvarchar(50)
DECLARE @pwd INT
SET @name='zhangsan'
SET @pwd='123'
INSERT INTO dbo.People
( Name ,
Pwd ,
Company ,
CompanyAddress
)
DECLARE @pwd INT
SET @name='zhangsan'
SET @pwd='123'
INSERT INTO dbo.People
( Name ,
Pwd ,
Company ,
CompanyAddress
)
SELECT @name,@pwd,A.Company,A.Address FROM dbo.Company AS A WHERE CompanyID=1
由以上代码可以看出@name和@pwd是重新定义的
而A.Company和A.Address则是由表dbo.Company查询出来的。