Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parameterized in SQL Anywhere
Message
From
09/09/2010 13:54:44
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, United States
 
 
To
09/09/2010 13:40:58
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01480692
Message ID:
01480698
Views:
35
Is this a stored procedure? What you have should work.

>If I have the following in SQL Server:
>
>
>DECLARE @Numero Integer
>
>SET @Numero=11
>
>SELECT Client.FirstName FROM Client WHERE Client.Numero=@Numero
>
>
>I would be able to get a query based on a parameterized approach. Doing the same in SQL Anywhere makes it think that it would try to find a field name @Numero and would generate an error. Anyone would know the syntax to use?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform