if you want to add a not null column to a table with rows, you need to set a default value to the new column.

adding a new column without a default value would put a null in the column for each...

just replace the * with the column names...

select * from table1, table2

this combines both tables

im working on a asp.net project, sorta like a web portal, which will need a user database.

i have a very good understanding of sql. i just want some examples or tips on writing a good user...