how much datas we can store in a table

hello world,
we r developing a software for our company.one table is for client support
and feedback.in tht table more than one pages of datas has to be inserted pe
r
client.is this possible?if not is it possible to shift the datas in tht tabl
e
to other table automatically when tht table is full.if so pls send the
queries for tht.Hi
There are limits to things like number of columns in a table and size of
database see:
http://msdn.microsoft.com/library/d...br />
8dbn.asp
The number of rows your table contains is limited by your hardware
constraints.
It is not clear exactly what you require, if you wish to archive/delete old
data, then you will need a means of identifying that data, but you don't giv
e
any information regarding your table structure or data. Posting DDL (Create
table statements etc...) http://www.aspfaq.com/etiquette.asp?id=5006 and
example data as insert statements http://vyaskn.tripod.com/code.htm#inserts
would help.
To periodically run your archive task check out SQLAgentService in books
online and how to create/run jobs or at
http://msdn.microsoft.com/library/d...br />
6x0l.asp
John
"nikhil" wrote:

> hello world,
> we r developing a software for our company.one table is for client support
> and feedback.in tht table more than one pages of datas has to be inserted
per
> client.is this possible?if not is it possible to shift the datas in tht ta
ble
> to other table automatically when tht table is full.if so pls send the
> queries for tht.
>

how much datas we can store in a table

hello world,
we r developing a software for our company.one table is for client support
and feedback.in tht table more than one pages of datas has to be inserted per
client.is this possible?if not is it possible to shift the datas in tht table
to other table automatically when tht table is full.if so pls send the
queries for tht.
Hi
There are limits to things like number of columns in a table and size of
database see:
http://msdn.microsoft.com/library/de...ar_ts_8dbn.asp
The number of rows your table contains is limited by your hardware
constraints.
It is not clear exactly what you require, if you wish to archive/delete old
data, then you will need a means of identifying that data, but you don't give
any information regarding your table structure or data. Posting DDL (Create
table statements etc...) http://www.aspfaq.com/etiquette.asp?id=5006 and
example data as insert statements http://vyaskn.tripod.com/code.htm#inserts
would help.
To periodically run your archive task check out SQLAgentService in books
online and how to create/run jobs or at
http://msdn.microsoft.com/library/de...ar_cs_6x0l.asp
John
"nikhil" wrote:

> hello world,
> we r developing a software for our company.one table is for client support
> and feedback.in tht table more than one pages of datas has to be inserted per
> client.is this possible?if not is it possible to shift the datas in tht table
> to other table automatically when tht table is full.if so pls send the
> queries for tht.
>

how much datas we can store in a table

hello world,
we r developing a software for our company.one table is for client support
and feedback.in tht table more than one pages of datas has to be inserted per
client.is this possible?if not is it possible to shift the datas in tht table
to other table automatically when tht table is full.if so pls send the
queries for tht.Hi
There are limits to things like number of columns in a table and size of
database see:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
The number of rows your table contains is limited by your hardware
constraints.
It is not clear exactly what you require, if you wish to archive/delete old
data, then you will need a means of identifying that data, but you don't give
any information regarding your table structure or data. Posting DDL (Create
table statements etc...) http://www.aspfaq.com/etiquette.asp?id=5006 and
example data as insert statements http://vyaskn.tripod.com/code.htm#inserts
would help.
To periodically run your archive task check out SQLAgentService in books
online and how to create/run jobs or at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_cs_6x0l.asp
John
"nikhil" wrote:
> hello world,
> we r developing a software for our company.one table is for client support
> and feedback.in tht table more than one pages of datas has to be inserted per
> client.is this possible?if not is it possible to shift the datas in tht table
> to other table automatically when tht table is full.if so pls send the
> queries for tht.
>sql

How many rows...?

I'm developing an app that will allow a user to track clicks and sales by date/time. However, I was wondering with the potential for a TON of clicks, is it feasable to track individual clicks in a SQL Server 2000 or 2005 database? I'm talking potentially 50,000 products receiving thousands of clicks per day, coud the db handle that kind of traffic? Or should I stick with a running total of clicks per product, and forget about the ability to see a breakdown of clicks per day, etc?That data is going to get out of control rather fast. However you can keep a running total by day.|||How many rows can a typical table handle? 1 million? 500 million? 1 billion? More? That will help me figure out if I can track clicks daily, or if I have to track weekly or monthly.|||The only limitation of rows per table in SQL is the storage available, see 'Maximum Capacity Specifications' topic in SQL Books Online

How insert Arabic/urdu characters in SQL server

Hi

I am developing an application where i want to store the different language (i.e. chines,Arabic,urdu etc) character in database (SQL Server). so when i store arabic characters in SQL server , it stores the (???).

datatype of field is nvarchar.

is anybody know about the problem and solution.

Regards

Mubahsar Ghazi

The problem is called character conversion and you are getting it because you are using only NVarchar without doing column level collation for Arabic in your database. There are three collations for Arabic in SQL Server 2005. If you are using SQL Server 2000 you can still do column level collation, the links below deals with SQL Server 2005. Hope this helps.

144

binary.256

Binary

SQL_Latin1_General_1256_BIN

145

diction.256

Dictionary order, case-sensitive

SQL_Latin1_General_Cp1256_CS_AS_KI_WI

146

nocase.256

Dictionary order, case-insensitive

SQL_Latin1_General_Cp1256_CI_AS_KI_WI

http://msdn2.microsoft.com/en-us/library/ms144250(SQL.90).aspx

http://msdn2.microsoft.com/en-us/library/ms180175(SQL.90).aspx

|||

thanks for ur response

but i m still getting problems.....

i m pasting the whole code below.while executing it show the exceptionCast from string "?" to type 'Byte' is not valid.

.....................

Dim cAsString = HelpArea.Text ' HelpArea is text box where urdu/arabic characters can be writen

convertC = UniToVar(c) ' function written below

Cmd =

New SqlCommand("INSERT INTO tblCategoryDetail(FieldLang,FieldHelp)Values(' " & dpLanguage.SelectedItem.Text & " ', " & convertC(c) & ")", con)

lblMsg.Text = "Values have stored in database"

con.Open()

Cmd.ExecuteNonQuery()

CatchexAs Exception

lblMsg.Text = ex.Message

EndTry

con.Close()

Public

Function UniToVar(ByVal sTextAsString)AsObject

Try

Dim b()AsByte

b = Encoding.Unicode.GetBytes(sText)

Return b

Catch exAs Exception

lblMsg.Text = ex.Message

EndTry

EndFunction

|||

i have posted the whole function in previous message......and need the solution in very short time...... hoping early resopnse by ur side

regards

Mubashar Ghazi

|||

I want to query the database using SQL statements that contain Arabic letters... for example, this query won't return any results that start with the letter '?' even though if I try any english letters it works perfectly:

SELECT ArtistID, Name
FROM dbo.Artist
WHERE (Name LIKE '?' + '%')

I also tried switching:

SELECT ArtistID, Name
FROM dbo.Artist
WHERE (Name LIKE '%' + '?')

but it won't work.. any ideas ?

Thanks :)

|||

See if the posthttp://forums.asp.net/t/1167422.aspx can be helpful.