Database

SELECT 
cu.COLUMN_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE cu 
WHERE EXISTS 
( 
	SELECT tc.* FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc
	WHERE tc.TABLE_NAME = 'table_name' AND 
	tc.CONSTRAINT_TYPE = 'PRIMARY KEY' AND
	tc.CONSTRAINT_NAME = cu.CONSTRAINT_NAME 
)ORDER BY cu.ordinal_position

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