Viewing 3 posts - 1 through 4 (of 4 total)
I think this line from SQL Server HELP provides answer. It was a suprise to me. It seems that nvarchar(20) is a different type than nvarchar(26). Interesting at the least....
Ready comprehension is often a knee-jerk response and the most dangerous form of understanding. It blinks an opaque screen over your ability to learn. The judgemental precedents of law function that way, littering your path with dead ends. Be warned. Understand nothing. All comprehension is temporary.
Frank Herbert
September 13, 2004 at 8:14 am
Try to use dynamic sql for this. For example create such a stored procedure
CREATE PROCEDURE rp_Table
@TableName nvarchar(100)
AS
DECLARE @sql nvarchar(4000)
SET @sql = 'SELECT * FROM ' + @TableName
-- print @sql
EXEC sp_executesql ...
Ready comprehension is often a knee-jerk response and the most dangerous form of understanding. It blinks an opaque screen over your ability to learn. The judgemental precedents of law function that way, littering your path with dead ends. Be warned. Understand nothing. All comprehension is temporary.
Frank Herbert
April 27, 2004 at 7:26 am
It is not possible to use Reporting Services with MSDE.
Ready comprehension is often a knee-jerk response and the most dangerous form of understanding. It blinks an opaque screen over your ability to learn. The judgemental precedents of law function that way, littering your path with dead ends. Be warned. Understand nothing. All comprehension is temporary.
Frank Herbert
February 20, 2004 at 12:16 am
Viewing 3 posts - 1 through 4 (of 4 total)