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 |
|
khusiie
Yak Posting Veteran
78 Posts |
 Posted - 2008-01-20 : 14:30:38
|
| can anone tell me is this correct way to write in sql using this set command?set rsRecord = objConn.Execute(SQL)response.write sqlstrNumber = rsRecord("number")strCNo = replace(strCNo," ",")can v write this in sql stored procedure? or there is another way to replace in sql and for str.. ?thanks. |
|
|
hey001us
Posting Yak Master
185 Posts |
Posted - 2008-01-20 : 16:03:39
|
| What you are trying to do? We can help you if understand your requirement.hey |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-20 : 20:06:29
|
| Can't be in standard sp since they are not t-sql code. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-01-21 : 03:19:14
|
| Write a stored procedure and then use the ADO command object in your client to execute the stored procedure . This will create a recordset which you can then iterate throughJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|
|
is this true?