Stevens

Stevens

  • NA
  • 3
  • 0

MS SQL Command Practice.

May 19 2008 12:52 PM
    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....

Answers (2)