Database

--create a table with three columns
CREATE TABLE dbo.tblMyTable
	(
	Col1 int NOT NULL,
	Col2 varchar(50) NULL,
	Col3 int NULL
	)  ON [PRIMARY]


/******Add a column in 2nd position*****/
/*Now create a temporary table that is just the same,
  only insert a column between Col1 and Col2*/
CREATE TABLE dbo.Tmp_tblMyTable
	(
	Col1 int NOT NULL,
	InsertedCol int NULL,
	Col2 varchar(50) NULL,
	Col3 int NULL
	)  ON [PRIMARY]

--Take all the data from the old table, and put it in the new one
INSERT INTO dbo.Tmp_tblMyTable (Col1, Col2, Col3)
		SELECT Col1, Col2, Col3 FROM dbo.tblMyTable 

DROP TABLE dbo.tblMyTable --drop the old table

EXECUTE sp_rename 'dbo.Tmp_tblMyTable', 'tblMyTable' --rename new one

/*Add the primary key CONSTRAINT into the new table 
  (be sure to add any other indexes and triggers)*/
ALTER TABLE dbo.tblMyTable ADD CONSTRAINT
	PK_tblMyTable PRIMARY KEY CLUSTERED 
	(
	Col1
	) ON [PRIMARY]

rfebin2001 wrote:

But i want to pass the error to the DAL Factory Class and we throw as a errror

rfebin2001 wrote:

that is the SQL exception error plus our company's validation engine error

rfebin2001 wrote:

while we insert as a sql command as a string, and use executenonquery method will executed

this scenario how will get the last affected row from a table

NICE TO MEET wrote:

Without using any extra query, or SP how will get the last affected row in that table

cmd.CommandText = "INSERT MyTable(Column1, Column2) VALUES ('ABC', 'DEF'); SELECT @@IDENTITY;";
int primaryKey = (int)cmd.ExecuteScalar();

<br />
select * from table <br />
where col1 IN('val1' , 'val2') and col2 IN ('val3' , 'val4')<br />

SELECT * 
FROM Table1 AS t1
LEFT OUTER JOIN Table2 AS t2 
ON t1.PrimaryKey = t2.PrimaryKey AND t1.Column1 = t2.Column1 AND t1.Column2 = t2.Column2....
WHERE t2.PrimaryKey IS NULL