title: How do I do an insert with DATETIME now inside of SQL server mgmt studio
body: <p>I have a website that does inserts into this table below.  I need to do some manual inserts but I wasn't sure how do pass in the equivalent of DateTime.Now in C#.  </p>
  
  <p>I am running this below from the query editor in SQL server mgmt studio.  Is there any way to pass in the current date time in this query below.</p>
  
  <pre><code>INSERT INTO [Business]
             ([IsDeleted]
             ,[FirstName]
             ,[LastName]
             ,[LastUpdated]
             ,[LastUpdatedBy])
       VALUES
             (0, 'Joe', 'Thomas', 
             ,&lt;LastUpdated, datetime,&gt;
             ,&lt;LastUpdatedBy, nvarchar(50),&gt;)
  </code></pre>