Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jylland
Starting Member
27 Posts |
 Posted - 2011-11-18 : 07:40:05
|
| I try to execute this SQL but no succes, what do I wrong ??it should insert if no same valueIF(SELECT COUNT(*) FROM tblProject where ProjectIDNo = @ProjectIDNo) = 0)BeginINSERT INTO tblProject(ProjectIDNo) VALUES (@ProjectIDNo) END |
|
|
Ifor
Aged Yak Warrior
700 Posts |
Posted - 2011-11-18 : 07:46:10
|
| [code]INSERT INTO tblProject(ProjectIDNo)SELECT @ProjectIDNoWHERE NOT EXISTS( SELECT * FROM tblProject WITH (UPDLOCK, SERIALIZABLE) WHERE ProjectIDNo = @ProjectIDNo)[/code] |
 |
|
|
jylland
Starting Member
27 Posts |
Posted - 2011-11-18 : 09:07:12
|
| Greate thanks |
|
|
|
|
|
|
count problem