LiteSpeed for SQL Server 8.9.5 - Integration with TSM Guide

Supported SELECT Statements

LiteSpeed only supports a small subset of the possible T-SQL SELECT statements. In addition, it does not support computed columns and OUTER JOIN.

LiteSpeed supports the following syntax to execute SELECT statements against a backup file:

SELECT
[ TOP <expression> ]
<select_list>     
FROM <select_source>       
[ WHERE <search_condition> ]   
[ <offset_fetch> ]

<select_list> ::=
<select_item>     
| <select_list> , <select_item>  

<select_item> ::=
column     
| column_wild   
| column alias   
| alias = column   

<select_source> ::=
<table_source>     
| <select_source> , <table_source>   
| <select_source> JOIN <table_source> ON <search_condition>   
| <select_source> INNER JOIN <table_source> ON <search_condition>   

<table_source> ::=
table     
| table alias   
| table AS alias   

<search_condition> ::=
{ [ NOT ] <predicate> | ( <search_condition> ) }   
[ { AND | OR } [ NOT ] { <predicate> | ( <search_condition> ) } ][,...n]   

<predicate> ::=
<expression> { = | > | < | >= | <= | <> | !< | != | !> } <expression>     
| expression [ NOT ] LIKE string_constant [ ESCAPE 'escape_char' ]   
| expression [ NOT ] BETWEEN expression AND expression   
| expression [ NOT ] IN (expression [,...n])
| expression IS [ NOT ] NULL   

<expression> ::=
constant     
| column    

<offset_fetch> ::=
{ OFFSET { integer_constant | offset_row_count_expression } { ROW | ROWS }
[ FETCH { FIRST | NEXT } {integer_constant | fetch_row_count_expression } { ROW | ROWS } ONLY ] }

Examples

SELECT * FROM LiteSpeedActivity OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY

SELECT TOP 10 * FROM LiteSpeedActivity WHERE DatabaseID = 6

Related Topics

About Restoring Objects (Object Level Recovery)

Execute SELECT Statements