on 12-05-2011 9:06 PM
Hi. When in Edit Derived Table, if I paste a query larger than about 65KB, the end of the query will be cut off. Then I must create multiple Derived Tables. Has anyone else experienced this? Do you find the limit to be about 65KB?
Thanks,
Mike
Hi ,
There is limitation to SQL query size for derived table . we can't use more than 64k .. better you can create the view in database using your long query ,instead of the derived table.
Thanks
Ponnarasu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.