title: Converting smalldatetime datatype to varchar datatype
body: <p>How to convert smalldatetime to varchar? I've tried everything from <a href="http://msdn.microsoft.com/en-us/library/ms187928.aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/ms187928.aspx</a>, but it didn't work.</p>
  <p>I want to convert smalldatetime into varchar, because I want to use it in select like this:</p>
  <p><code>select 'Some text'+@Date</code></p>
  <p>thanks in advance</p>