Can I use a column number instead of a column name in which the query selection condition in SQL Server 2005?

Question

we can use the column number instead of the column name in which the query selection condition in SQL Server 2005 is such that even if the column name takes so long.

early.

Answer 1

no, you cannot directly, just drag the column name you want from the explorer object into your query ... you don't need to enter it

Press F8, Object Browser will open. Go to DatabaseName / TableName / Columns. Click on the column folder and drag the column folder into the code window. Once released, you will see that all column names are in the code window.

( )

SQL Information_schema.columns _ . 5, _ 5, . , ,

Answer 2

. , , . , , .

SQL; , , .

Answer 3

, , :

SELECT  *
FROM    (
        SELECT  Supercalifragilisticexpialidociousness AS s
        FROM    mytable
        ) q
WHERE   s = 1

SQL Server , , .

Answer 4

.

, SELECT / WHERE...

Answer 5

, . , . , , , ( , 128 MS SQL)

Answer 6

select * from table_name somecolumn = 5 insted,

, , , . , SQL-.

declare @colname varchar(128)
declare @sql varchar(max)
set @colname = 'Server'
set @sql = 'select * from Jobs where '+@colname+'='+'''S02AAPEXP01'''
exec (@sql)

, , !!!

Answer 7

, WHERE. ORDER BY. , ORDER BY

SELECT ServerCode, Count(*) as Databases 
FROM DatabaseList 
GROUP BY ServerCode 
ORDER BY 2 DESC

SELECT EventCode, EndTime, Convert(Varchar(50),TextData) as QueryName, CPU, READS
FROM TraceData
ORDER BY 3

, proc? .

Answer 8

, SQL intellisense, , RedGate .

SqL Prompt

SQL 2008, , Intellisense.

Answer 9

, , , / SQL Server.

1 - Query Analyzer ( ). Alt - F1. , . , , Ctrl - C, Ctrl - V, . , .

2 - Script /SELECT To/Clipboard. , .