Database

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

SELECT ColumnName FROM Table