Author |
Topic |
mikecro
Starting Member
21 Posts |
Posted - 2011-04-11 : 19:05:54
|
Hi,I've been wrestling with this query in SqlServer 2005 and get the error message:"Incorrect syntax near the keyword 'WHERE'."Here's the query:insert into Roles_Users (role_id, user_id)values (@role_id, @user_id) WHERE NOT EXISTS (SELECT user_id, role_id FROM Roles_Users WHERE user_id=@role_id AND role_id=@user_id)I don't see a problem with it. Any ideas?Thanks! |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
mikecro
Starting Member
21 Posts |
Posted - 2011-04-11 : 19:11:31
|
Insert a set of values in to the table if they don't already exist. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
mikecro
Starting Member
21 Posts |
Posted - 2011-04-11 : 19:20:42
|
That would appear to be the easiest approach. Thanks for your help. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
jcelko
Esteemed SQL Purist
547 Posts |
Posted - 2011-04-11 : 21:20:25
|
>> I don't see a problem with it. Any ideas? <<INSERT INTO does not have a WHERE clause. --CELKO--Books in Celko Series for Morgan-Kaufmann PublishingAnalytics and OLAP in SQLData and Databases: Concepts in Practice Data, Measurements and Standards in SQLSQL for SmartiesSQL Programming Style SQL Puzzles and Answers Thinking in SetsTrees and Hierarchies in SQL |
|
|
wided
Posting Yak Master
218 Posts |
Posted - 2011-04-12 : 12:05:42
|
if NOT EXISTS (SELECT user_id, role_id FROM Roles_Users WHERE user_id=@role_id AND role_id=@user_id)insert into Roles_Users (role_id, user_id)values (@role_id, @user_id) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|