irpersian20
جمعه 25 اسفند 1391, 12:31 عصر
سلام
این کوئری ببنیدی لطفا
USE AdventureWorks2012; GO DECLARE @find varchar(30); /* Also allowed: DECLARE @find varchar(30) = 'Man%'; */ SET @find = 'Man%'; SELECT p.LastName, p.FirstName, ph.PhoneNumber FROM Person.Person AS p JOIN Person.PersonPhone AS ph ON p.BusinessEntityID = ph.BusinessEntityID WHERE LastName LIKE @find;با این نتایجش هیچ فرق نداره
پس کاربردش چیه؟
Declare به چه کاربردی هست؟
USE AdventureWorks2008R2;
GO
/* Also allowed:
DECLARE @find varchar(30) = 'Man%';
*/
SELECT p.LastName, p.FirstName, ph.PhoneNumber
FROM Person.Person AS p
JOIN Person.PersonPhone AS ph ON p.BusinessEntityID = ph.BusinessEntityID
WHERE LastName LIKE 'Man%';
این کوئری ببنیدی لطفا
USE AdventureWorks2012; GO DECLARE @find varchar(30); /* Also allowed: DECLARE @find varchar(30) = 'Man%'; */ SET @find = 'Man%'; SELECT p.LastName, p.FirstName, ph.PhoneNumber FROM Person.Person AS p JOIN Person.PersonPhone AS ph ON p.BusinessEntityID = ph.BusinessEntityID WHERE LastName LIKE @find;با این نتایجش هیچ فرق نداره
پس کاربردش چیه؟
Declare به چه کاربردی هست؟
USE AdventureWorks2008R2;
GO
/* Also allowed:
DECLARE @find varchar(30) = 'Man%';
*/
SELECT p.LastName, p.FirstName, ph.PhoneNumber
FROM Person.Person AS p
JOIN Person.PersonPhone AS ph ON p.BusinessEntityID = ph.BusinessEntityID
WHERE LastName LIKE 'Man%';