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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-05-24 : 10:27:36
|
| Ricardo Coulthurst writes "Hi, I writting from Uruguay (South America) I have see you page at http://seamas.4t.com/SP.htm , but I keep having trouble. I'm using a SQL 2000 with a simple Bank Table like this: BankId smallint BankName character(50) I have this stored procedure working fine CREATE PROCEDURE BcoNom2 AS Begin set Select * from BcoCod Static Return 0 End GOI can do Forward only and I need it "Static", but I can't find a simple example How must I define it like "Static"Thanls in advance Ricardo Coulthurstsoporte@InetWork.com.uy" |
|
|
cbeganesh
Posting Yak Master
105 Posts |
Posted - 2004-05-24 : 14:37:04
|
| i did not understand what you mean by static, can you explain |
 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-05-24 : 14:52:42
|
| are you using ADO and trying to open a recordset? Static vs Forward Only vs Dynamic and all that has nothing to do with a stored procedure definition -- it's how you choose to open a recordset each time you run the stored procedure.- Jeff |
|
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2004-05-25 : 03:20:33
|
| He might be talking about a cursor (as in DECLARE CURSOR etc.) What language do they speak in Uraguay...portugese?Você está falando sobre cursores? Eu penso que você está confundindo dois conceitos diferentes aqui - se você estiver falando sobre os recordsets, esses necessita ser feito na extremidade dianteira e não tem nenhum impacto na maneira que o SP é escritoOS |
|
|
|
|
|
|
Static: How can I define it