title: How to create datetime from date and string in tsql
body: <p>I have a Store Procedure in T-SQL. I want to create a datetime from date and string.</p>
  
  <p>So I have this:</p>
  
  <pre><code>DECLARE @DATE AS DATE
  DECLARE @TIME AS NVARCHAR(5)
  
  SET @DATE = NOW() /*2017-10-11*/
  SET @TIME = '08:00'
  </code></pre>
  
  <p>Now, I want to create this date '2017-10-11 08:00:00'</p>