مطالب مرتبط با «using and sort in excel» در back soft | نویسنده: استخدام کار
Using filters and wildcards to find incorrect records on SQL server management studio
Vote count: 0 New to using SQL server management studio... Just trying to filter my table results to show only records that have (deceased) in them... So far I have select SURNAME, count(SURNAME) from [dbo].[blahblah] group by SURNAME order by SURNAME I would usually use TRIM/translate like the below, however it doesn't recognise these functions... select trim(translate(cast(GUAR_PHONE as string), '0123456789', ' ')),GUAR_PHONE from atable WHERE trim(translate(cast(GUAR_PHONE as string), '0123456789', ' '))'' ; asked 38 secs agoBenji Taylor Let's block ads! بخوانید...
ادامه مطلب
