Viewing 4 posts - 1 through 4 (of 4 total)
Hello,
execution of:
select EmployeeID, LastName, FirstName, MiddleName, Department, 0 as EmployeeLevel
into #tmptbl
from Employees where SupervisorID = (Select EmployeeID from #tmptbl where EmployeeLevel = 1)
gives error message:
The SELECT...
September 15, 2014 at 1:21 am
Indeed. "set @j-2 = @i--" is also a nice joke. Good idea for placing some T-SQL bombs in our companies
July 9, 2014 at 7:26 am
Hello,
it's worth to be mentioned that ++ and -- operators don't exist in TSQL. The following example code:
declare @ int = 1, @j-2 int, @k int
Set...
July 9, 2014 at 1:47 am
Viewing 4 posts - 1 through 4 (of 4 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy