Well hell, what good is a variable in the query analyzer thing if I have to declare it up front every time. You don't.you must do:declare int - or other datatypeselect = 1 - or value you needselect * from any_table where field1 = trouble since 1980Blog: up SSMS development: it's not going to prompt you it's just going to complain about a missing parameter.-Charlie In Oracle, I can write something like this:select * from any_table where field1 = '&1' Upon execution, sqlplus or other compliant clients will prompt me for the value of &1 and then run the query.How do I do something similar in ManagementStudio 2005?TIA We've got lots of great SQL ServerĮxperts to answer whatever question you can come up with.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |