A sub-statement found in the SELECT statement that uses any of various filter conditions, such as BETWEEN, IN, and LIKE, to limit the number of rows retrieved.
Windows application log
The operating system event log used to record application events sent by SQL Server services.
WITH ENCRYPTION
The WITH ENCRYPTION clause protects the definition of your view. If you specify this, you encrypt the definition of your view because you may not want users to display it. Encrypting using WITH ENCRYPTION disallows anyone from using sp_heptext to display your view or viewing it via the Enterprise Manager.
WITH SCHEMABINDING
The WITH SCHEMABINDING option specifies that the view be bound to the schema. This has to be specified when you want to create views with indexes. Also, when WITH SCHEMABINDING is specified, you have to adhere to the owner.object syntax when referencing tables or views in the creation of your view.