As subject, I do some MS SQL command practice under Visual Studio
2005, have
following issue:
By using VS 2005 Dataset function (Solution Explore->Add New
Item->Dataset
templates) I put the following SQL command,
SELECT A, B, C
FROM DB
WHERE (B=@B)
Query from SQL mdf file, under VS 2005 Query Builder IDE environment,
it can execute
and B has parameter option as input. However, if I connect to the MS Access *.mdb file, the
VS 2005 IDE
generated the following:
SELECT A, B, C
FROM DB
WHERE (B='@B')
There are comma between @B, if I manually erase
the comma, than complier error...
Moreover, under Query Builder, there is no parameter option as input....
I don't know where I make mistake.... Please, help me....