SQL Server Performance

DataType

Discussion in 'General Developer Questions' started by rajkolli_2000, Jun 14, 2006.

  1. rajkolli_2000 New Member

    Hi all,

    what are the differences between cast and convert.


    Regards
    Rajesh.
  2. mmarovic Active Member

    There is a topic in BOL about both. In short cast is ansi standard funtions but is missing a few feature convert supports.
  3. FrankKalis Moderator

    Yes, CAST is ANSI standard, while CONVERT is MS-specific. MS recommends to use CAST whenever possible. So you'll find the only use of CONVERT when using some style parameter when moving from DATETIME to some specific date format.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de
    Heute schon gebloggt?http://www.insidesql.de/blogs
  4. rajkolli_2000 New Member

    sorry to ask this.What is BOL ?

    Regards
    Rajesh.
  5. rajkolli_2000 New Member

    Thanks kalis.
  6. FrankKalis Moderator

  7. rajkolli_2000 New Member

  8. satya Moderator

    Ok Kalis [}<img src='/community/emoticons/emotion-1.gif' alt=':)' />][<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by FrankKalis</i><br /><br /> <br /><br />just call me Frank...<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">
  9. FrankKalis Moderator

    I don't know how this is handled in other societies exactly, but here it is regarded impolite and dismissive to call someone by just his last name. Either someone's first name or by adding Mr. or Mrs. I am aware that this differs from how other folks handle this and I don't feel offended by this, but it always looks strange to me.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de
    Heute schon gebloggt?http://www.insidesql.de/blogs
  10. rajkolli_2000 New Member

    I am very sorry Frank.

    I did not call with any intention.Just in our society we use to call like this. That is the reason why i called u like that.

    Any way i am sorry once again.

    i am RajeshKolli from india.Doing as a sql programmer.

    Regards
    Rajesh.
  11. FrankKalis Moderator

    As I said, I am aware, that other cultures handle this different and most folks make the mistake not to talk about such things and learn from each other. <br /><br />Not need to apologise! [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />But while we're at it. What is the difference when I call you "Rajesh" instead of "Kolli"?<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a>
  12. rajkolli_2000 New Member

    Rajesh is my first name.

    Regards
    Rajesh.
  13. FrankKalis Moderator

  14. Madhivanan Moderator

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by rajkolli_2000</i><br /><br />Ok Frank.<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />It is better to call the member by the user name of the Forum [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br />Dont cut anything<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  15. ranjitjain New Member

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by satya</i><br /><br />Ok Kalis [}<img src='/community/emoticons/emotion-1.gif' alt=':)' />][<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by FrankKalis</i><br /><br /> <br /><br />just call me Frank...<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">[<img src='/community/emoticons/emotion-1.gif' alt=':)' />][<img src='/community/emoticons/emotion-1.gif' alt=':)' />]
  16. vsnreddi New Member

    Hi all

    please discuss about topic..no execuses in this forum...

    SURYA

  17. satya Moderator

    I believe the topic is discussed and I;m sure Rajesh is happy with the content, rest of it is just a wayup from the discussions.<br /><br />(I'm sure Frank will be waiting to wind me up [<img src='/community/emoticons/emotion-1.gif' alt=':)' />].<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Contributing Editor & Forums Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided �AS IS� with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>
  18. FrankKalis Moderator

    Nope. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br />Though I don't have an answer to my question...<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a>

Share This Page