Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
real_pearl
Posting Yak Master
106 Posts |
 Posted - 2004-06-02 : 10:01:54
|
| Can I assign value to an ntext type variable within a procedure.e.g.,create proc usp_testasdeclare @data ntextselect @data = "select id, name from TABLE" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-02 : 12:58:23
|
| Yes you can, but what you are trying to do is dynamic sql. Please explain what you need.Tara |
 |
|
|
|
|
|
ntext type variable