title: SQL Server identity issue
body: <p>I have a query like below</p>
  
  <pre><code>declare @str_CustomerID int
  Insert into IMDECONP38.[Customer].dbo.CustomerMaster
  ( CustomerName , CustomerAddress , CustomerEmail , CustomerPhone )
  values ( ‘werw12e’ , ‘jkj12kj’ , ‘3212423sdf’ , ‘1212121′
  )
  
  select @str_CustomerID= scope_identity()
  </code></pre>
  
  <p>After execution it returns null in my parameter.</p>
  
  <p>I want to get the value of identity. How can I do that?</p>
  
  <p>The main issue over here is "IMDECONP38" - the server name that I used. If I remove this I can get the value of identity in my parameter.</p>