Private: MY Note

ASP.NET 1.1 to ASP.NET 2.0 Migration Solutions

http://www.eggheadcafe.com/tutorials/aspnet/03cedfc8-e623-4fee-81d8-04663b71b675/aspnet-11-to-aspnet-2.aspx

migrate oracle to sql server

– TO_Date( ‘09/21/1979 12:00:00 AM’, ‘MM/DD/YYYY HH:MI:SS AM’)
– TO_Date( ‘05/05/1970 12:00:00 AM’, ‘MM/DD/YYYY HH:MI:SS AM’)
print convert(char(8),cast(’09/21/1979 12:00:00 AM’ as datetime),112)

แทน
TO_Date( ‘
ด้วย
convert(char(8),cast(’

แทน
‘, ‘MM/DD/YYYY HH:MI:SS AM’)
ด้วย
‘ as datetime),112)
 

CREATE PROCEDURE [recruit].SP_UPDATE_MST_PROVINCE
@province_id      char(5),
@province_name varchar(50),
@sap_code  char(2),
@created_by  varchar(8),
@flag   char(1)
AS
 UPDATE [recruit].MST_PROVINCE
 SET province_name = @province_name,
                     sap_code = @sap_code,
        created_date =  convert(char(8),getdate(),112),
         created_by = @created_by,
        flag  = @flag
 WHERE province_id  = @province_id

GO