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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Labeling

Author  Topic 

Highness
Starting Member

1 Post

Posted - 2010-05-20 : 10:35:30
Hi,

I'm searching for a solution for the following 'problem':

I want to design my database in a way, where it is not possible to run a query without a certain parameter in the where clause.

For example:

SELECT * FROM files => will not return any results or give an error.

SELECT * FROM files WHERE company = 'A' => will return the files from company A.

Is this possible?

Grtz,

Ruud
   

- Advertisement -