 |
How to use ORDER BY clause in the definition of a view?
|
| Total Hit (2505) |
SQL Server excludes an ORDER BY clause from a view to comply with the ANSI SQL-92 standard. Because analyzing the rationale for this standard requires a discussion of the underlying structure of the structured query language (SQL) and the mathematics upon which it is based, we can't fully explain th
....Read More |
Rating
 |
|
|
|
|
|
How to use stored proc inside View?
|
| Total Hit (2536) |
SQL Server allows you to define loopback Linked server. You can execute linked server stored proc using openquery statement. Before you use openquery make sure that 'data access' option is enabled.
«code LangId=6»exec sp_serveroption 'binaryworld','data access','true'
go
create view vw_Who
....Read More |
| Rating
|
|
|
|
|
|
Indexed Views Basics in SQL Server 2000
|
| Total Hit (1098) |
Indexes have been a method to improve the performance of SQL queries since the creation of relational databases in the 1970's. You are probably familiar with the ways that indexes can speed query operations at the expense of additional overhead during data inserts, updates, and deletes. Up until rec
....Read More |
| Rating
|
|