Help!about stored procedure 
Author Message
 Help!about stored procedure


as
 select address from test

It can't work.



Thu, 05 Dec 2002 03:00:00 GMT
 Help!about stored procedure


Hope this helps.


Quote:

> CREATE PROCEDURE test

> as
>  select address from test

> It can't work.



Thu, 05 Dec 2002 03:00:00 GMT
 Help!about stored procedure
I have tried it.But it can't work too.It said that Incorrect syntax near'%'


Thu, 05 Dec 2002 03:00:00 GMT
 Help!about stored procedure
Tom, I ran the following script under SQL 7:

CREATE TABLE Table1
(pystreet VARCHAR(20),
 address VARCHAR(20))
GO
INSERT INTO Table1 VALUES('StreetBame 1','Address 1')
INSERT INTO Table1 VALUES('StreetName 2','Address 2')
GO

AS
 SELECT address from Table1

GO
EXECUTE Procedure1 'S'
GO

Results:

address
--------------------
Address 1
Address 2


removed.  However, that does not explain the syntax error your are
experiencing.  If your are still having difficulty, please post the revised
proc.


Quote:
> I have tried it.But it can't work too.It said that Incorrect syntax
near'%'



Fri, 06 Dec 2002 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Help with stored procedure calling another stored procedure.

2. newbie help with stored procedure

3. Help on stored procedure

4. HELP: Executing Stored Procedures via Named Pipes

5. Help, Calling Stored Procedures From a Different Database

6. Need help with Stored Procedures and VB

7. need help on stored procedure which can return a text colume

8. Help with Stored Procedures

9. Help with stored procedure!!

10. Need help about stored procedures

11. Help with Stored Procedure

12. Help with Stored Procedure Discovery


 
Powered by phpBB® Forum Software