Answer / ramakrishna

Some SQL Server 2000 and Access 2000 products limits:




Feature SQL Server 2000 Access 2000
database size 1,048,516 TB 2 GB plus
linked tables size
objects in a database 2,147,483,647 32,768
user name length 128 20
password length 128 14
table name length 128 64
column name length 128 64
index name length 128 64
Number of concurrent users limited 255
columns per table 1024 255
table size limited 1 GB
number of indexes in a table 250 32
number of columns in an index 16 10
bytes per row 8060 2000
number of tables in a query 256 32
columns per SELECT statement 4096 255
nested subqueries 32 50
number of enforced relationships 253 32

Answer / rajeshwari

it is an query language with an structure so we esily
access the data from data base

What is bcp? When does it use?

0 Answers  

---

What is acid properties?

0 Answers  

---

Explain hostprotectionattribute in sql server 2005?

0 Answers  

---

Some queries related to SQL

0 Answers   Motorola,

---

What new changes are being made in SQL Server?

0 Answers   Blue Star,

---

What do you understand by the denormalisation?

0 Answers  

---

What's the information that can be stored inside a bit column?

0 Answers  

---

Tell me what are cursors and when they are useful?

0 Answers  

---

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

0 Answers  

---

How to list all dsn entries on your local machine using odbc_data_source()?

0 Answers  

---

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

0 Answers  

---

what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;

13 Answers   Patni,

---