TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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....
Reply
Answers (
2
)
Parent and child
Delete and Truncate