SQL error: Incorrect syntax near the keyword ‘User’

by

User is a reserved keyword, so you must use square brackets to make it explicit that you mean the object named “User” it, i.e. use [User] instead of User.

More Related Contents:

  1. What represents a double in sql server?
  2. Passing List to SQL Stored Procedure
  3. Generate class from database table
  4. Generating sql code programmatically
  5. How can I round a value in SQL
  6. How do I update a value in C# and SQL Server? [closed]
  7. How to pass an array into a SQL Server stored procedure
  8. How to get last inserted id?
  9. Execute Insert command and return inserted Id in Sql
  10. Adding multiple parameterized variables to a database in c#
  11. Getting return value from stored procedure in C#
  12. SQL WHERE clause matching values with trailing spaces
  13. Query extremely slow in code but fast in SSMS
  14. SqlBulkCopy from a List
  15. Code to validate SQL Scripts
  16. WHERE IN (array of IDs)
  17. SQLException : String or binary data would be truncated
  18. SQL: Update a row and returning a column value with 1 query
  19. SqlConnection.Close() inside using statement
  20. ALTER TABLE DROP COLUMN failed because one or more objects access this column
  21. When executing a stored procedure, what is the benefit of using CommandType.StoredProcedure versus using CommandType.Text?
  22. Can I use ADFS 2.0 to authenticate certain users against SQL Server?
  23. What is passing parameters to SQL and why do I need it?
  24. The variable name ‘@’ has already been declared. Variable names must be unique within a query batch or stored procedure
  25. How to pass a null variable to a SQL Stored Procedure from C#.net code
  26. How to insert data into SQL Server
  27. How do I calculate the equivalent to SQL Server (hashbytes(‘SHA1’,[ColumnName])) in C#?
  28. Use SQL Server time datatype in C#.NET application?
  29. How to give ADO.NET Parameters
  30. Is SqlConnection.Close() need inside a Using statement?

Leave a Comment