Posts by Fenrir()

Maybe something along these lines rather?

SELECT (CASE WHEN COALESCE((EventSummary.[Event Information] - EventSummary.[Event Status]),0) = 0 THEN 'ACTIVE' ELSE (EventSummary.[Event Information] - EventSummary.[Event Status]) END) AS [Event Summary]

I think i misunderstood your question. It will be a very bad idea to have a seperate table for each user. Rather make a general Table and link the user ID to that table. That way you can have multiple users information in one table just like your user table.

It's been annoying me ever since i started using SQL.

Check out this link :

http://www.west-wind.com/weblog/posts/2008/Jan/25/An-easier-Table-Design-View-in-Sql-Server-Management-Studio

doesn't seem to be any way to customize the default table designer.

Why would they need to update their account everyday? It would be best to use a seperate table yes. Maybe use a UNIQUE Constraint on fields like Email and Username if you aren't doing that already.

if (Convert.ToInt(this.LblANDa.Text) == 1)
{
//your code
}

Just type a9 no quotes

SqlConnection cn = new SqlConnecton();
cn.ConnectionString = "Data Source=WELL\\SQLEXPRESS;Initial Catalog=master;Integrated Security=True";
string s;
s = textbox1.Text;   ?
string q = "ALTER TABLE abc add '"+textbox1.Text+"' Varchar(20)";
//string q = "ALTER TABLE abc add a8 Varchar(20)";
SqlCommand cmd = new SqlCommand(q, cn);
cn.Open();
cmd.ExcecuteNonQuery();
cn.Close();

Not sure why you were using the reader