I was looking for solution which gives me the details of the table and column which contains respective data,

Just go through the code

SET NOCOUNT ON;

DECLARE @indexRow INT,

@rowCount int,...

Thanks for your Reply...

i found other way, please check it

DECLARE @sqlquery VARCHAR(1000)

SELECT @sqlquery= N'IF EXISTS (SELECT ' + CHAR(39) + 'AC_Cancellation_Master' + CHAR(39) + '...

this is the normal query

through this we will come to know whiether the records exists or not in the table

if EXISTS(SELECT Sr_No FROM #Temp_Table_Col WHERE Sr_No = @iIndexCol)

BEGIN

SELECT Sr_No...

the following code illustrate you in breif actual i want the table name, respective column data from over all Tables of the Database

DECLARE @iIndexRow INT ,@RowsCount_Row int ,

Server: Msg 170, Level 15, State 1, Line 34

Line 34: Incorrect syntax near 'SP_EXECUTESQL'.

Try this

Use Northwind

SELECT * FROM [Product Sales for 1997]

WHERE ProductName LIKE '%_im%'

result set

CategoryName ProductName ...

Thanks subbusa2050

it works and implemented in my project.

Regards

HI,

Avoid Cursor , Using While loop

Just go through it

----- Solution ----- 1

If Identity Column Does not exist in the table

...

Try with this add underscore in your search

Name like '_ohn%'

Patel Mohamad