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 |
|
hirani_prashant
Yak Posting Veteran
93 Posts |
 Posted - 2008-06-02 : 05:10:04
|
| Hi, Mine Below Query is not Printing Anything though there is a matching record in table "gpcb_proj_paras"Can any one help me??declare @catg as char(1)set @catg = '''A'''declare @qry as nvarchar(3000)declare @paras as varchar(200)Set @paras = (Select convert(nvarchar(200), app_paras) from gpcb_proj_paras t where t.act = @catg) print @paras-- RegardsPrashant Hirani |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-02 : 05:11:50
|
| Do you have more than 1 records satisfying the query condition? |
 |
|
|
PeterNeo
Constraint Violating Yak Guru
357 Posts |
Posted - 2008-06-02 : 05:13:18
|
| change set @catg = '''A'''to set @catg = 'A', if you have more than one value returning, last one will be printed |
|
|
|
|
|
|
Print Statement not working...