Note: An incorrect revision of this answer was edited out. Please review all answers. A subselect in the WHERE clause to retrieve the greatest BALANCE aggregated over all rows. If multiple ID values share that balance value, all would be returned. SELECT ID, BALANCE FROM CUSTOMERS WHERE BALANCE = (SELECT MAX(BALANCE) FROM CUSTOMERS)
The last argument of CONVERT seems to determine the format used for parsing. Consult MSDN docs for CONVERT. 111 – the one you are using is Japan yy/mm/dd. I guess the one you are looking for is 103, that is dd/mm/yyyy. So you should try: SELECT convert(datetime, ’23/07/2009′, 103)
UPDATE q SET country = a.country FROM quantity q JOIN acronym a ON a.acronym = q.country
The syntax I was looking for is: alter table TABLE_NAME add [column_name] as (**COLUMN-SQL**)
ISNUMERIC will not do – it tells you that the string can be converted to any of the numeric types, which is almost always a pointless piece of information to know. For example, all of the following are numeric, according to ISNUMERIC: £, $, 0d0 If you want to check for digits and only digits, … Read more
Interesting – I’ve honestly never even noticed that before. I would suspect that it’s an early oversight that was just never corrected, though I’m a little surprised that support wasn’t later added for RAISEERROR, with the mis-spelling left alone for compatibility. Update: Aparently, there’s even some internal confusion about what it ought to be – … Read more
Tip: generate error. declare @Day int, @Config_Node varchar(50) set @Config_Node=”value to trace” set @Day = @Config_Node You will get this message: Conversion failed when converting the varchar value ‘value to trace’ to data type int.
I just had the same problem and… declare @userId uniqueidentifier set @userId = (select top 1 UserId from aspnet_Users) or even shorter: declare @userId uniqueidentifier SELECT TOP 1 @userId = UserId FROM aspnet_Users
You can use a CASE statement. SELECT CASE WHEN currate.currentrate IS NULL THEN 1 ELSE currate.currentrate END FROM …