queries

• Nsh

  SSCommitted

  Points: 1639

  More actions

  March 23, 2006 at 10:28 am

  #171710

  Hi,

  How to do the following in sql server 2005:

  1. Is there any way of getting a row size from a data table in the database.

  for example I have a "Employee" table in the database called "Company" and many rows are populated into the table, and now I need the number of bytes a particular row has occupied in the table.

  2. Suppose I want to add new columns in the existing table, then is there any possibility of adding the column in the middle of the table and not at the end?

  ex. Employee table contains c1,c2 and c3 ( in the same order) now is it possible to add c4 in between c1 and c2?

  Thanks,

  Natalie.

• Markus Veretin

  SSCommitted

  Points: 1565

  More actions

  March 24, 2006 at 11:02 am

  #628699

  1.select isnull(datalength(col1),0)+ isnull(datalength(col2),0)+ isnull(datalength(col3),0) from <table_name>

  2. Go to EM right pane > right click on table name >design table > right click on col2 > insert col4  and save it.