A simple question for you on T-Sql


follow url Hi guys, Today i have a simple question for you & my question is what would be the result of the query-

here USE tempdb GO CREATE TABLE #Employee (EmpId INT, NAME VARCHAR(15), Salary INT, Expenses VARCHAR(5)) INSERT INTO #Employee SELECT 1056, 'Viraj', 230000, 5216 UNION SELECT 2095, 'Dheeraj', 98000, 7892 UNION SELECT 7258, 'Raman', 42000, 923 UNION SELECT 6323, 'jay', 12000, 8999 SELECT * FROM #Employee 2015-08-13_1100_exp SELECT max(Salary) 'Salarymax', max(Expenses) 'Expensesmax', max(Cast(Salary AS VARCHAR(6))) 'Salary_max', max(Cast(Expenses AS INT)) 'Expenses_max' FROM #Employee -- cp reifen trading paris addebito carta visa <--Answer for this query DROP TABLE #Employee

http://www.soundofthesirens.net/?delimeres=binary-options-trading-live-signals-robot-free-download-2017&50d=a4 Isn’t it a simple question-

follow site If you say, it should be 230000,8999,230000,8999. then it is wrong. You should check your basics.

get link The answer is 230000,923,98000,8999

http://clgsecurities.com/?hixorisima=billy-bob-thornton-dating-halle-berry&57e=d2 Do you know the datatype of salary is int & for expenses it is varchar. In comparison, integers are compared with complete number while string are compared with one by one character.


follow link I am Microsoft Certified Professional for querying & Administering Sql Server. I believe “The greatest barrier to success is the fear of failure.”
I am also available at http://dbavimal.blogspot.com


como conocer chicos de mi edad

%d bloggers like this: