Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2003
    Posts
    42

    Unanswered: would you like to give me some advice

    hi,everyone
    i use sybase before,and i want to learn ms sqlsr2000,can anybodu give me some advice,or give me some matrial
    thx in advance

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    there are many books u would like to refer:
    like Inside sql server
    The Guru's Guide to Transact-SQL
    Professional SQL Server 2000 Programming

    plus don't miss a post on
    www.dbforums.com
    www.sqlteam.com

    u'll find great inputs on
    http://vyaskn.tripod.com/


    and this i should have mentioned the first
    as enigma like to call it the holy book

  3. #3
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Hey Harshal ... what about www.sqldude.4t.com
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Harshall, you need to drop this code sample from your site:

    --Function for retrieving the Date part from datetime field.
    Create Function JustDate (@dttm datetime)
    returns nvarchar(10)
    as
    begin
    declare @a nvarchar(20)
    set @a= RIGHT('0' + CAST(Month(@dttm) AS Varchar(2)), 2) + '/' + RIGHT('0' + CAST(Day(@dttm) AS Varchar(2)), 2) + '/' + CAST(Year(@dttm) AS Varchar(4))
    --select @a
    return (@a)
    end

    Just tell people to use convert(char(10), @dttm, 120) instead...
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    hey blindman thanks for bringing it to my notice,
    its been quite a while since i have updated that site.

  6. #6
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    hey harshal ... that looks like code from your childhood days
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •