Ninja's_RGR'us (5/11/2011)

---

ilker.cikrikcili (5/11/2011)

---

sql server forces me to use nvarchar of which max size is 4000:

I have the same problem, I need a 8000 long...

sql server forces me to use nvarchar of which max size is 4000:

I have the same problem, I need a 8000 long data type....

Opps, I realised that it's not because of varchar(max) but DECLARE @sql NVARCHAR(1000);

I created another topic since this problem is not related to current topic.

http://www.sqlservercentral.com/Forums/Topic1106826-391-1.aspx

Dear all,

This query was working all right until today:

DECLARE @sql NVARCHAR(1000);

SET @sql = 'SELECT ''' + STUFF((

...

Thanks for advice, I'll keep in mind. But for the time being, we have single schema in DB.

Yes, you are right.

I haven't read the article yet but will do it.

Your query is clear for me, I've even converted it to query the actual tables in...

Yes! That's it!!

Thank you very much 🙂

Hi Guys,

Any update on this? 🙂

Regards

ilker

Lynn Pettis (4/18/2011)

---

You are going to need to use dynamic sql to generate the query you need to run using system tables to identify the column names for the table...

Hmm, yes, I can't use column names in the query no matter I'm doing it with function calls or not.

As I've written in my previous post, I won't know...

Hi parthi-1705,

Yes, that's exactly what I needed but when I run your query I couldn't get columnNames:data pairs.

Let me do further tests, I'll let you know.

Thank you very much

Because I won't know column names at run time. Even I won't know table name. Table name will passed as a parameter to my...