dotnetspider.com
Login Login    Register      

TutorialsForumCareer DevelopmentResourcesReviewsJobsInterviewCommunitiesProjectsTraining

Subscribe to Subscribers
Talk to Webmaster
Tony John

Facebook
Google+
Twitter
LinkedIn
Online MembersPhagu Mahato
More...
Join our online Google+ community for Bloggers, Content Writers and Webmasters




Forums » .NET » SQL Server »

How many columns are created with one table in sql server


Posted Date: 12 Jul 2012      Posted By:: Rajalingam     Member Level: Silver    Member Rank: 619     Points: 1   Responses: 7



Hi Friends,

How many columns are created with one table in sql server .
Please any one tell me.




Responses

#679974    Author: Ajatshatru Upadhyay      Member Level: Gold      Member Rank: 19     Date: 12/Jul/2012   Rating: 2 out of 52 out of 5     Points: 0

Hi,

Please explain your question in more detail.

Hope it'll help you.
Regards
Ajatshatru



 
#679982    Author: Anil Kumar Pandey      Member Level: Platinum      Member Rank: 1     Date: 12/Jul/2012   Rating: 2 out of 52 out of 5     Points: 0

What do you mean by create table in one table.

Please can you be more specific???

Thanks & Regards
Anil Kumar Pandey
Microsoft MVP, DNS MVM



 
#680014    Author: Varun Bansal      Member Level: Gold      Member Rank: 410     Date: 12/Jul/2012   Rating: 2 out of 52 out of 5     Points: 0

hi

you want to ask for which table..

table object or html table.

if you want know about table object then you can create one table.
if you want know about html table then you can create multiple nested table like:


<table>
<tr>
<td>
<table>
<tr>
<td></td>
</tr>
</table>

</td>
</tr>
</table>


Regards
Varun bansal
Do not forget to Rate the post.....
Click here for visiting in my blogs






 
#680024    Author: Ultimaterengan        Member Level: Gold      Member Rank: 9     Date: 12/Jul/2012   Rating: 2 out of 52 out of 5     Points: 3

Dear friend,
The maximum number of columns per table is 1024.

Do you want to check it? if yes use below example


DECLARE @Count INT,@SqlQuery NVARCHAR(MAX)
SELECT @Count =1, @SqlQuery ='CREATE TABLE DynamicTable('
WHILE(@Count<=10)
BEGIN
SELECT @SqlQuery = @SqlQuery + 'Column' + CAST(@Count AS VARCHAR(4)) + ' Varchar(max),'

SELECT @Count = @Count +1

END
SELECT @SqlQuery = LEFT(@SqlQuery,LEN(@SqlQuery)-1) + ')'
EXEC(@SqlQuery)






Thanks & Regards
G.Renganathan
Nothing is mine ,Everything is yours!!!


http://renganathan1984.blogspot.com/



 
#680211    Author: Nirmala      Member Level: Silver      Member Rank: 837     Date: 13/Jul/2012   Rating: 2 out of 52 out of 5     Points: 1

Hi,

1024 is the maximum number of columns in a table.

Regards,
Nirmala



 
#680339    Author: suresh Babu M      Member Level: Silver      Member Rank: 703     Date: 14/Jul/2012   Rating: 2 out of 52 out of 5     Points: 1

HI,

you can create 1024 columns for a table in sql server



Regards



 
#683739    Author: Sriram      Member Level: Gold      Member Rank: 895     Date: 09/Aug/2012   Rating: 2 out of 52 out of 5     Points: 1

Hi,

can create 10224 columns can create in single table.



 
Post Reply

 This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.



Next : Need help with a query
Previous : Question on datename function
Return to Discussion Forum
Post New Message
Category:

Related Messages



Follow us on Twitter: https://twitter.com/dotnetspider

Active Members
TodayLast 7 Daysmore...

Awards & Gifts
Email subscription
  • .NET Jobs
  • .NET Articles
  • .NET Forums
  • Articles Rss Feeds
    Forum Rss Feeds


    About Us    Contact Us    Copyright    Privacy Policy    Terms Of Use    Revenue Sharing sites   Advertise   Talk to Tony John
    Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India
    2005 - 2012 All Rights Reserved.
    .NET and other trademarks mentioned in this site belong to Microsoft and other respective trademark owners.
    Articles, tutorials and all other content offered here is for educational purpose only.
    We are not associated with Microsoft or its partners.