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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2001-03-08 : 15:05:24
|
Srinivas writes "declare @name varchar(50) select @name = "fil_name" select * from tblfile order by @name
when i execute this i am getting error saying...
The SELECT item identified by the ORDER BY number 1 contains a variable as part of the expression identifying a column position. Variables are only allowed when ordering by an expression referencing a column name.
I want to know the reason and cause" |
|
|
|
|
|