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 |
|
taunt
Posting Yak Master
128 Posts |
 Posted - 2010-12-27 : 15:18:39
|
| Hello, is there a SQL query that will display results not found? I have a label data base and I'm looking for 3 labelsku's. Lets say AAA, ABB, ACC. ABB and ACC aren't in the label database. I would like it to display a "not found" result, but don't know the syntax or ifs it even possible. Any help would be great.Thanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-27 : 15:45:44
|
| IF NOT EXISTS(SELECT fields FROM table WHERE...)BEGIN SELECT 'not found'ENDBut really, you should do this in the front end application. |
 |
|
|
taunt
Posting Yak Master
128 Posts |
Posted - 2011-06-08 : 15:01:17
|
| OK stupid question. Is there a way to do this in SQL Server Management Studio? If not what would be a good front end app? I know of Access, and that's about it.Thanks |
|
|
|
|
|
|
Display results not found