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 |
|
renu
Starting Member
47 Posts |
 Posted - 2008-11-04 : 01:19:29
|
| hi, i have a sp which i execute in my local db that time the length of the query is like 20, but when the same query when i execute in another db that time the length of the query is like 21?How it happens? |
|
|
PeterNeo
Constraint Violating Yak Guru
357 Posts |
Posted - 2008-11-04 : 01:42:46
|
What do you mean by "length of the query"?Column length or anything else."There is only one difference between a dream and an aim. A dream requires soundless sleep to see, whereas an aim requires sleepless efforts to achieve..!!" |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-04 : 01:51:40
|
| can you post the query? or at least bit where you feel length is varying? |
|
|
|
renu
Starting Member
47 Posts |
Posted - 2008-11-04 : 04:29:00
|
| HI ALL, that query comes in a sp. now it was solved , we added ltrim ((rtrim)) it works fine.thanks |
|
|
|
|
|
|
extra space