What does the “@” symbol do in SQL?

by

The @CustID means it’s a parameter that you will supply a value for later in your code. This is the best way of protecting against SQL injection. Create your query using parameters, rather than concatenating strings and variables. The database engine puts the parameter value into where the placeholder is, and there is zero chance for SQL injection.

More Related Contents:

  1. How to display data in JOIN, and return null value? [closed]
  2. How to create a SQL Server function to “join” multiple rows from a subquery into a single delimited field? [duplicate]
  3. SQL multiple join statement
  4. Paging with Oracle
  5. How to select from subquery using Laravel Query Builder?
  6. Calculating difference between two timestamps in Oracle in milliseconds
  7. How to concatenate columns in a Postgres SELECT?
  8. Dynamic Pivot Columns in SQL Server
  9. How do I insert datetime value into a SQLite database?
  10. How can I find which tables reference a given table in Oracle SQL Developer?
  11. What is easier to read in EXISTS subqueries? [closed]
  12. PostgreSQL multi INSERT…RETURNING with multiple columns
  13. Selecting N rows in SQL Server
  14. Copy rows from one table to another, ignoring duplicates
  15. DB design to use sub-type or not?
  16. How can I INSERT data into two tables simultaneously in SQL Server?
  17. SQL “select where not in subquery” returns no results
  18. Extract date (yyyy/mm/dd) from a timestamp in PostgreSQL
  19. Oracle equivalent of Postgres’ DISTINCT ON?
  20. How to run a stored procedure every day in SQL Server Express Edition?
  21. What is causing Foreign Key Mismatch error?
  22. T-SQL: How to use parameters in dynamic SQL?
  23. Split words with a capital letter in sql
  24. Generate random int value from 3 to 6
  25. scope_identity vs ident_current
  26. WITH CHECK ADD CONSTRAINT followed by CHECK CONSTRAINT vs. ADD CONSTRAINT
  27. Add a row number to result set of a SQL query
  28. How to replace specific values in a oracle database column?
  29. is there a PRODUCT function like there is a SUM function in Oracle SQL?
  30. Connect different Windows User in SQL Server Management Studio (2005 or later)

Leave a Comment