Wednesday, December 3, 2014

nvarchar(max) error

>SET @fullquery = 'SELECT * FROM OPENQUERY(SLTNPGDB, ''' + @query + ''')'


My guess is that it fails when OPENQUERY is executed.


Why the huge input parameter?








Kalman Toth Database & OLAP Architect SQL Server 2014 Database Design

New Book / Kindle: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2014











No comments:

Post a Comment