Forum Replies Created

Viewing 2 posts - 1 through 3 (of 3 total)

  • RE: Proper Case

    DECLARE @str VARCHAR(255) =' rajneeh

    kumar

    is

    working in technext'

    SET @str = ' ' + @str

    SET @str = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(@str, ' a', ' A'), '...

  • RE: Date Format issue when querying SQL Server Database.

    if you are sending this date from the front end(i.e. .net, php) then always send you date in "yyyy-MM-dd" or "yyyy-MMM-dd hh:mm:ss" if you want time also. it will never...

Viewing 2 posts - 1 through 3 (of 3 total)