please solution needed for this questions

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

please solution needed for this questions

Author

Topic

sqllover
Constraint Violating Yak Guru

338 Posts

Posted - 2007-01-30 : 02:44:01

hi,
i have few questions,please can any one answer for me?
1. how many columns can we create in one table?does it depene on the size?
2. how many tables can be used in one select query? ie select * from emp1,emp2,emp3 etc.........
3. how many tables can be created in one database?
4,what is the size limitation of one table?

please any one answer me for this question.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-01-30 : 02:44:34

What does Books Online tell you?

Peter Larsson
Helsingborg, Sweden

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-01-30 : 02:49:21

1. Open SQL Server help, Index tab
2. Write "limitations-SQL Server objects" in the keyword to find box

Enjoy !!

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

sqllover
Constraint Violating Yak Guru

338 Posts

Posted - 2007-01-30 : 02:56:49

hi harsh_athalye,i tried it tells no records forund like that.

hi peso, i couldnot get anser from book.

please help me to know ..

sqllover
Constraint Violating Yak Guru

338 Posts

Posted - 2007-01-30 : 03:09:22

please can any one answer me?

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-01-30 : 03:16:23

refer to
for
SQL Server 2000 : http://msdn2.microsoft.com/en-us/library/aa933149(SQL.80).aspx
SQL Server 2005 : http://msdn2.microsoft.com/en-us/library/ms143432.aspx

sqllover
Constraint Violating Yak Guru

338 Posts

Posted - 2007-01-30 : 03:44:04

hi khtan i got it,thanks a lot for ur help

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources