Database

ma_refay wrote:

i want to modify the date apperance when i reterive it from table instead of
mdy it display ion dmy

"SELECT TOP 50 U.strName , (Select Count(*) From tbUser) as TotalRecords " +<br />
"FROM tbUser U " +<br />
"WHERE U.strName LIKE '%om%' "

select a.codeid, MIN(b.codeidalias) as MinCodeIdalias from tblcodes a
left outer join tblcodeslookup b on a.codeid = b.codeid
where a.codeid not in (select codeidalias from tblcodeslookup)
group by a.codeid

declare @stuff xml
set @stuff = '<xml><thing>Word</thing></xml>'
select @stuff.value('/xml[1]', 'varchar(20)')

    DECLARE curMasterGames CURSOR FOR
    SELECT MasterGameID FROM MasterGames
 
    OPEN curMasterGames
    DECLARE @GameID bigint
 
    -- Prime the pump.
    FETCH NEXT FROM curMasterGames INTO @GameID
    -- Check to see if the FETCH failed on the first record BEFORE we try
    -- to do any processing on that records data.
    WHILE @@FETCH_STATUS = 0
        BEGIN
            -- It seems the FETCH worked, do something with it.
            EXEC UpdatePlayerScoresOnMasterGameID @GameID
            -- Get the next record.
            FETCH NEXT FROM curMasterGames INTO @GameID
        END
    CLOSE curMasterGames
    DEALLOCATE curMasterGames
 
    -- Do the same exact pattern for the next cursor you open.
    -- Prime, test for failure, then process your loop.