Short Codes of Samsung Mobile

//////codes of samsung mobiles


*2767*JAVA# Java Reset and (Deletes all Java Midlets)
*2767*MEDIA# Reset Media (Deletes All Sounds and Pics)

(no 2 code for delete hiden fav vedios in phone memory which can not be deleted simply )
*2767*WAP# Wap Reset
*2767*CUST# Reset Custom EEPR0M
*2767*FULL# Reset Full EEPR0M (Caution)


//////some others code for samsung also by mithilesh

*#06# IMEI code
*#9998*4357# Help Menu
*#9998*5282# Java menu (GRPS/CSD settings for JAVA server)
*#9999#0# Monitor Mode

*#9998*746# or *#9998*0746# or *#0746# Sim Infos
*#9998*523# or *#9998*0523# or *#0523# Display Contrast
*#8999*638# show network information
*#9998*5646# change operator logo at startup
*#9998*76# production number
*#9998*842# or *#9998*0842# or *#0842# Vibration On (until you push OK)

*#3243948# Digital Audio Interference Off

*#9998*968# view melody for alarm
*#9998*585# Non-Volatile Memory (NVM)
*#8888# or *#9998*8888# Hardware Version
*#9999# or *#9998*9999# Software Version
*#9998*289# or *#9998*0289# or *#0289# Buzzer On (until you push OK)
*#9998*288# or *#9998*0288# or *#0288# Battery & Field Infos

*#9998*377# or *#9998*0377# Error log
*#9998*778# or *#9998*0778# or *#0778# Sim Service table
*#9998*782# show date and alarm clock

*#32436837# Digital Audio Interference On


///////////miscellneous codes for samsung.......

*#06# -> Show IMEI
*#9999# -> Show Software Version
*#0001# -> Show Serial Parameters

*2767*3855# -> Full EEPROM Reset ( THIS CODE REMOVES SP-LOCK!!!! but also change IMEI to 447967-89-400044-0, you must use CHGIMEI to restore it)

*2767*2878# -> Custom EEEPROM Reset
*#8999*228# -> Battery status (capacity, voltage, temperature)
*#8999*246# -> Program status

*#8999*862# -> Vocoder Reg
*#8999*872# -> Diag
*#8999*947# -> Reset On Fatal Error

*#8999*786# -> Run, Last UP, Last DOWN
*#8999*837# -> Software Version
*#8999*289# -> Change Alarm Buzzer Frequency
*#8999*324# -> Debug screens
*#8999*364# -> Watchdog
*#8999*377# -> EEPROM Error Stack
*#8999*427# -> Trace Watchdog
*#8999*523# -> Change LCD contrast

*#8999*746# -> SIM File Size
*#8999*778# -> SIM Service Table
*#8999*785# -> RTK (Run Time Kernel) errors

*#8999*544# -> Jig detect
*#8999*636# -> Memory status

*#8999*862# -> Vocoder Reg
*#8999*872# -> Diag
*#8999*947# -> Reset On Fatal Error
*#8999*999# -> Last/Chk
*#8999*9266# -> Yann debug screen (=Debug Screens?)
*#8999*9999# -> Software version *#8999*842# -> Test Vibrator

*#8999*999# -> Last/Chk
*#8999*9266# -> Yann debug screen (=Debug Screens?)
*#8999*9999# -> Software version

for unlocking........

47*869#08#9

- unlock code / change roaming code / ID

/////////////unverifed code(use at own risk)

*7465625*27*
*7465625*2827# – Auto CP lock activated

*7465625*28746# – Auto SIM lock activated
*7465625*638*
*7465625*746
*335#
*663867# – mm file dumped
*7465625# –
*7465625*228# – Activa lock personalized
*7465625*28638# – Auto Network lock activated
*7465625*746*
*7465625*2877# – Auto SP lock activated

*7465625*28782# – Auto subset lock activated

*7465625*77*
*7465625*782*

For maintain session state in sql server database

go to vs command prompt and type following ,if u r using Express Edition.

aspnet_regsql –E -S .\SQLEXPRESS –ssadd –sstype p

then a new data base will be created Name "AspState" which is used for
maintain session and your application.




//////for stateserver(out proc)


first goto control panel then admin services then start the
astnet state server ,,,,,,
after that type the following in web.config file.




  

   sessionState mode="StateServer" stateConnectionString="tcpip=127.0.0.1:42424"

because your stater server is running on local host so the ip og state server is 127.0.0.1 an dthe port on which state servrer is running is 42424.....

Function of Date Time Conversion in sql server

create FUNCTION dbo.DateTimeFormat

(

@dt DATETIME,

@format VARCHAR(16)

)

RETURNS VARCHAR(64)

AS

BEGIN

DECLARE @dtVC VARCHAR(64)

SELECT @dtVC = CASE @format

WHEN 'ddmmmmyyyy' THEN

CAST(DAY(@dt) AS VARCHAR(2))

+ SPACE(1) + DATENAME(m, @dt)

+ SPACE(1) + CAST(YEAR(@dt) AS CHAR(4))

WHEN 'LONGDATE' THEN

DATENAME(dw, @dt)

+ ',' + SPACE(1) + DATENAME(m, @dt)

+ SPACE(1) + CAST(DAY(@dt) AS VARCHAR(2))

+ ',' + SPACE(1) + CAST(YEAR(@dt) AS CHAR(4))

WHEN 'LONGDATEANDTIME' THEN

DATENAME(dw, @dt)

+ ',' + SPACE(1) + DATENAME(m, @dt)

+ SPACE(1) + CAST(DAY(@dt) AS VARCHAR(2))

+ ',' + SPACE(1) + CAST(YEAR(@dt) AS CHAR(4))

+ SPACE(1) + RIGHT(CONVERT(CHAR(20),

@dt - CONVERT(DATETIME, CONVERT(CHAR(8),

@dt, 112)), 22), 11)

WHEN 'SHORTDATE' THEN

LEFT(CONVERT(CHAR(19), @dt, 0), 11)

WHEN 'SHORTDATEANDTIME' THEN

REPLACE(REPLACE(CONVERT(CHAR(19), @dt, 0),

'AM', ' AM'), 'PM', ' PM')

WHEN 'UNIXTIMESTAMP' THEN

CAST(DATEDIFF(SECOND, '19700101', @dt)

AS VARCHAR(64))

WHEN 'YYYYMMDD' THEN

CONVERT(CHAR(8), @dt, 112)

WHEN 'YYYY-MM-DD' THEN

CONVERT(CHAR(10), @dt, 23)

WHEN 'YYMMDD' THEN

CONVERT(VARCHAR(8), @dt, 12)

WHEN 'YY-MM-DD' THEN

STUFF(STUFF(CONVERT(VARCHAR(8), @dt, 12),

5, 0, '-'), 3, 0, '-')

WHEN 'MMDDYY' THEN

REPLACE(CONVERT(CHAR(8), @dt, 10), '-', SPACE(0))

WHEN 'MM-DD-YY' THEN

CONVERT(CHAR(8), @dt, 10)

WHEN 'MM/DD/YY' THEN

CONVERT(CHAR(8), @dt, 1)

WHEN 'MM/DD/YYYY' THEN

CONVERT(CHAR(10), @dt, 101)

WHEN 'DDMMYY' THEN

REPLACE(CONVERT(CHAR(8), @dt, 3), '/', SPACE(0))

WHEN 'DD-MM-YY' THEN

REPLACE(CONVERT(CHAR(8), @dt, 3), '/', '-')

WHEN 'DD/MM/YY' THEN

CONVERT(CHAR(8), @dt, 3)

WHEN 'DD/MM/YYYY' THEN

CONVERT(CHAR(10), @dt, 103)

WHEN 'HH:MM:SS 24' THEN

CONVERT(CHAR(8), @dt, 8)

WHEN 'HH:MM 24' THEN

LEFT(CONVERT(VARCHAR(8), @dt, 8), 5)

WHEN 'HH:MM:SS 12' THEN

LTRIM(RIGHT(CONVERT(VARCHAR(20), @dt, 22), 11))

WHEN 'HH:MM 12' THEN

LTRIM(SUBSTRING(CONVERT(

VARCHAR(20), @dt, 22), 10, 5)

+ RIGHT(CONVERT(VARCHAR(20), @dt, 22), 3))

ELSE

'Invalid format specified'

END

RETURN @dtVC

END

________________________Excute

DECLARE @now DATETIME

SET @now = GETDATE()

PRINT dbo.DateTimeFormat(@now, 'ddmmmmyyyy')

PRINT dbo.DateTimeFormat(@now, 'LONGDATEANDTIME')