Using a function in CHECK constraint solves my problem. Thank you so much for the help and support.

No i cannot add UNIQUE CONSTRAINT on col3 of table2 becox i dont...

Thanks alot for your help.

ok .. but how can i stop the insertion in instead of trigger if condition is not matched.

can u plz explain ???

Yes you understood well my question.

I am already using a stored procedure to for insertions in my table, but the procedure is dynamically generated from the application(Desktop Application) ,...

Ohh thank you so much ,

It was just a little and silly mistake i was doing .

INSERT ..SELECT works fine in this case .

I am doing it row by row because i think its the only way to do this .

The query i have mentioned, if run directly in TSQL ..it returns 3...

I am doing it row by row because i think its the only way to do this .

The query i have mentioned, if run directly in TSQL ..it returns 3...

I m doing it row by row, because i think its the only way to do it

I want to insert each row in my table which is returned by...

Following procedure stores the value of each column in a parameter and then inserts in the table.

CREATE PROCEDURE DBO.FKEYS_FOR_KEYTBL

@FKNAME VARCHAR(100) = NULL,

@SCHNAME VARCHAR(5) = NULL,

@FKFLDNAME VARCHAR(20) =...

Nothing is contradicting Bhuvnesh.

I just want to store the results in a table and for that i thought stored procedure would work best .

I want the proc to read each...

Using parameters works fine in this case .

i have written a stored proc which stores the results of this query in parameters, and then inserts these values in a...

No i dont want to pass table ..

Below is the query :

SELECT obj.name AS FK_NAME,

sch.name AS [schema_name],

tab1.name AS

,

...