Home > database >  SQL SERVER to variable assignment, (' {0} ') what is this for?
SQL SERVER to variable assignment, (' {0} ') what is this for?

Time:10-01

DECLARE
@ ORDERID varchar (50)
The SET @ ORDERID=(' {0} ')
SELECT * FROM TABLE WHERE ORDERID=@ ORDERID




The above statement, this is a report software within the SQL query set. I want to ask the (' {0} ') what do you mean? I will write SQL query statement, the statement is smooth, but did not find the data. But the report within the software can give (' {0} ') this assignment. I went on a map.





In addition the inside there is no other writing?


Thank you
  • Related