I want to save real datatype!!!

what is difference between them?

Could you help me in both?

thanks

Yes you are right

collate cannot work on string

thanks

Hello ChrisM@home

let me explain my question again.

I want to do paging with Row_Number on several Join Table.

My temp table fill by executing UserMidlist Procedure

I use code below

DECLARE @RowsPerPage INT...

Hello

I think I use it in from statement

FROM exhibitor.dbo.maintable INNER JOIN #temp1

isn't it?

SELECT TOP 10

@string = ISNULL('<tr> <td><a class="class_a" href="'+

ISNULL(exhibitor.dbo.prpReadTypeID(exhibitor.dbo.maintable.Mid,exhibitor.dbo.maintable.ID,1,90 ),'HTTP://namayeshgah.com')

...

sorry because of my dirty code.

Yes you are right, it work independently.

but when I use it as "@SQLstring" in procedure "sp_executesql", I have this error "Must declare the...

Hello GilaMonster

thanks for your answer

Right know I want to use my temp table in sp_executesql

EXEC sp_executesql @SQLstring, N'@string nvarchar(max) output', @string=@ExeCommand output

it is my code that generate my...

Yes they are same

sql server 2008 R2

Thanks alot for your help

we solve our problem , it seem related to another server that I wanted to connect.

yes

but my servername is ticketing too , may be it causes this error! ?

I try to attach the picture of my error

BUT I'm sure about my user and password :ermm:

Thanks alot it works! 🙂