Database

ALTER TABLE table
ALTER COLUMN col DROP DEFAULT

CREATE TABLE MyTabale
(
    Id INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
    FirstValue INT,
    SecondValue INT,
    ThirdValue INT
);

INSERT INTO MyTable VALUES(@FirstValue, @SecondValue, @ThirdValue);<br />
SELECT SCOPE_IDENTITY();

SqlCommand insert = new sqlcommand(@"INSERT ...");<br />
insert.ExecuteNonQuery();<br />
<br />
SqlCommand scope = new sqlcommand(@"select ....");<br />
int identity = (int)scope.ExecuteScalar();

Sqlcommand insertAndscope = new sqlcommand(@"Insert ...; Select...");<br />
int identity = (int)insertAndscope.ExecuteScalar();

Ian Uy wrote:

Can I concatenate the INSERT COMMAND and the SELECT COMMAND into a single SQLCommand object?

Ian Uy wrote:

What I'm afraid is that, if the command is divided into two, there is a lag time between the two commands - and in a multi-user enviroment, there will be a problem.

Ajeet mittal wrote:

1. how many types of indexes in sql server.
also if we delete the table having one cluster indexes and 2 non cluster indexes.then what happen.can any one tell me about that.how can we delete the table and if table is deleted then what is happening about cluster and non clustered indexes.is it deleted automatically.

Ajeet mittal wrote:

2. i need to left outer join with where clause with 2nd table.what is the output of the query. it will return all rows of 1st table or it will return only selected rows