title: Incorrect syntax near the keyword "INTO"
body: <p>This is the <code>insert</code> query which is causing error : </p>
  
  <pre><code> public int Insert(User obj){
  
       string query = "INSERT IGNORE INTO tblUser(Name,Photo,Email,Password,Branch,Phone,Address,Authority,Recover_Email,Facebook_ID)  values(@name,@photo,@email,@pass,@branch,@phone,@addr,@auth,@re,@fbID) ";
       List&lt;SqlParameter&gt; lstp = new List&lt;SqlParameter&gt;();
       lstp.Add(new SqlParameter("@name", obj.Name));
       lstp.Add(new SqlParameter("@photo", obj.Photo));
       lstp.Add(new SqlParameter("@email", obj.Email));
       lstp.Add(new SqlParameter("@pass", obj.Password));
       lstp.Add(new SqlParameter("@branch", obj.Branch));
       lstp.Add(new SqlParameter("@phone", obj.Phone));
       lstp.Add(new SqlParameter("@addr", obj.Address));
       lstp.Add(new SqlParameter("@auth", obj.Authority));
       lstp.Add(new SqlParameter("@re", obj.Recovery_Email));
       lstp.Add(new SqlParameter("@fbID", obj.Facebook_ID));
       return DBUtility.ModifyData(query, lstp);
  }
  </code></pre>
  
  <p><strong>Exception Details :</strong></p>
  
  <blockquote>
    <p>System.Data.SqlClient.SqlException: Incorrect syntax near the keyword
    'INTO'</p>
  </blockquote>
  
  <p><strong>Table Definition :</strong></p>
  
  <pre><code>CREATE TABLE [dbo].[tblUser] (
      [UserID]         INT           IDENTITY (1, 1) NOT NULL,
      [Name]           VARCHAR (100) NULL,
      [Photo]          VARCHAR (500) NULL,
      [Email]          VARCHAR (50)  NULL,
      [Password]       VARCHAR (500) NULL,
      [Branch]         VARCHAR (50)  NULL,
      [Phone]          VARCHAR (50)  NULL,
      [Address]        VARCHAR (500) NULL,
      [Recovery_Email] VARCHAR (100) NULL,
      [Facebook_ID]    VARCHAR (200) NULL,
      PRIMARY KEY CLUSTERED ([UserID] ASC)
  );
  </code></pre>
  
  <p>If at all needed, <strong>The Stack Trace :</strong></p>
  
  <pre><code> [SqlException (0x80131904): Incorrect syntax near the keyword 'INTO'.]
     System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +1787814
     System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5341674
     System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +546
     System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady) +1693
     System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +275
     System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task&amp; task, Boolean asyncWrite, SqlDataReader ds) +1421
     System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task&amp; task, Boolean asyncWrite) +177
     System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) +208
     System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +163
     DataAccess.DBUtility.ModifyData(String query, List`1 lstParams) in c:\Users\ABHISHEK\Documents\Visual Studio 2013\Projects\InventoryManagement\DataAccess\DBUtility.cs:36
     BusinessLogic.UserLogic.Insert(User obj) in c:\Users\ABHISHEK\Documents\Visual Studio 2013\Projects\InventoryManagement\BusinessLogic\UserLogic.cs:30
     InventoryManagementSys.FacebookSync.AuthorizeUser() in c:\Users\ABHISHEK\Documents\Visual Studio 2013\Projects\InventoryManagement\InventoryManagementSys\FacebookSync.aspx.cs:83
     InventoryManagementSys.FacebookSync.Page_Load(Object sender, EventArgs e) in c:\Users\ABHISHEK\Documents\Visual Studio 2013\Projects\InventoryManagement\InventoryManagementSys\FacebookSync.aspx.cs:20
     System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +51
     System.Web.UI.Control.OnLoad(EventArgs e) +92
     System.Web.UI.Control.LoadRecursive() +54
     System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +772
  </code></pre>