query for select columns from sql server

Question

0.00/5 (No votes)

See more:

SQL-Server

How to select random columns from table in sql server
(columns name not specify)

Posted 18-Jun-12 21:14pm

bhartimithilesh

Add a Solution

Comments

Prasad_Kulkarni 19-Jun-12 3:21am

Why you want to do this?
and what does this means?
Please elaborate.

bhartimithilesh 19-Jun-12 3:34am

I am want to show some columns from database , I have 210 table again and again do not need to right

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2012-06-18T21:30:00

You can't do it easily - there is no mechanism for accessing columns by their ordinal number directly, although you could do it by querying the information_schema table to convert the ordinals to column names. You would still have to do the random number bit outside SQL or build some dynamic SQL to do it.

Nasty to implement, nasty to maintain. Much, much easier to maintain a table or dictionary in your external app which translates numbers to SQL columns and fetch them that way. However, that you want to do this may mean that your SQL database design is wrong and there may be a better way to do it altogether. What are you trying to achieve, and why do you think that this would be a good solution?

Prosan · Answer 2 · 2012-06-18T21:44:00

you can do it by dynamic query

example:-

SQL

create proc uspSelectData
@FieldNames varchar(max)=null
@TableName varchar(30)=null
as 
begin
declare @Qry nvarchar(max)

set @Qry='Select '+ @FieldNames +'  from '+ @TableName + ' 
EXECUTE  (@Qry)
end

call it as

SQL

exec uspSelectData @FieldNames ='colum1,colum2',@TableName='urtableName'

Mohamed Mitwalli · Answer 3 · 2012-06-18T22:07:00

Solution 3

Hi ,
You can make view and Give your columns Alias Number from 1 to 210
and you can generate every time random and number and you can pass it to your statement

SQL

SELECT CONVERT(INT, (210+1)*RAND())-- return Random int

Hope it gives you idea
Best Regards
M.Mitwalli

Posted 18-Jun-12 22:07pm

Mohamed Mitwalli

query for select columns from sql server

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0