How many chars in text field?

How many characters can you fit inside a text field with a length of 16.
How do you work this out?
Thanks
JF16 is only the size of the pointer which points to the actual data location.
Max size for the blob datatypes is approx 2GB.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Jof" <john.fletcher@.servicedelivery.org.uk> wrote in message
news:8809e3fb.0403190333.1db6e042@.posting.google.com...
> How many characters can you fit inside a text field with a length of 16.
> How do you work this out?
> Thanks
> JF|||To add to Tibor's response, the reported column size for text/ntext/image
data is the maximum number of bytes which are actually stored in the data
page. The 16-byte value is the default (pointer to separate text/image
page) but is configurable in SQL 2000 with the 'text in row' table option.
This allows you to control how much data cam be stored with the row itself
but the max data size is still 2GB.
Hope this helps.
Dan Guzman
SQL Server MVP
"Jof" <john.fletcher@.servicedelivery.org.uk> wrote in message
news:8809e3fb.0403190333.1db6e042@.posting.google.com...
> How many characters can you fit inside a text field with a length of 16.
> How do you work this out?
> Thanks
> JF

How is the Performance of the SQL with .Net?

Hi

I want to insert 1000s of records into SQL Server 2005 Database with some manipulation. So that i put into the For Loop and inserting record.

Inside the loop i am opening the connection and closing after use. The sample code is below

for(int i=0;i<1000;i++)
{

sqlCmd.CommandText = "ProcName";
sqlCmd.Connection = sqlCon;
sqlCmd.Connection.Open():
sqlCmd.ExecuteNonQuery();
sqlCmd.Connection.Close();

}

What my Question is.. How is the Performance of this Code..?? Will is take time to get the Connection and Close the Connection in every itration?

Or Shall I Open the Connection in Begining of the outside loop and close the connection at end of the Loop? will it increase the Performace?

Please clarify me these question.. Thanks in advance.

Hi,

Opening a connection and closing it takes a lot of extra resources, so use following.

1sqlCmd.CommandText ="ProcName";2sqlCmd.Connection = sqlCon;3sqlCmd.Connection.Open():45for(int i=0;i<1000;i++)6{7 sqlCmd.ExecuteNonQuery();8}910sqlCmd.Connection.Close();11

How I can get the rdl file from one application

Hi all,
I want to do a aspx page who host the report inside of a frame. I need get
the rdl definition from the server thru of the application.
Can I get the rdl thru web services?
I don't want to do the report manager.
Thanks
Manuel JorgeUse the GetReportDefinition of the web service:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_ak_2eew.asp
--
Adrian M.
MCP
"Manuel" <Manuel@.discussions.microsoft.com> wrote in message
news:ADE6F672-0E45-474E-BBDF-F5D51810C9D3@.microsoft.com...
> Hi all,
> I want to do a aspx page who host the report inside of a frame. I need get
> the rdl definition from the server thru of the application.
> Can I get the rdl thru web services?
> I don't want to do the report manager.
> Thanks
> Manuel Jorge
>