hi,

 select replace(columnname,right(columnname,4),'1111') from tablename

regards

Anurag

hi,

       ur query is something like selecting all records from staff table which returns multiple records.

in the above query, u r only taking email column from table in a single...

hi,

    i am not confirmed that this should work or not. u can try this!!

first of all check ur network connections i.e whether u r able to ping ur...

Hi,

  U can use Indexes for that. Go to manage indexes & create new index using column a,b, c & click on "unique values check box".

u will get ur desired...

Actually both queries are correct but in first query by mistake you have typed comma before AS(shown in RED), delete that comma & the query gives the same result.

SELECT OrderID,...

COUNT(*) returns the number of items in a group, including NULL values and duplicates

But if you specify a column name in Count function i.e Count(age) then it will not return...

Its ok.

ya, its possible

DECLARE @StaffList varchar(100)

SELECT @StaffList = COALESCE(@StaffList + ', ', '') + Surname

FROM StaffList order by Surname asc

SELECT @StaffList

When @StaffList is NULL (the first row processed), it returns an empty string....