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 |
|
b1jqcf96
Starting Member
1 Post |
 Posted - 2003-03-06 : 11:32:25
|
| Hi guys,I would like to know the syntax in tsql for doing something like this :CREATE PROCEDURE appSoleil.industriy_exists_for_clients @id AS tbl_admin_industries.id%TYPE; AS..I tryed it but doesnt seems to work.Thanks |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-03-06 : 11:41:54
|
| That's an Oracle syntax...you're in the land of SQL Server now. You need to know that datatype of your input parameter. Is there some reason you won't know it? If so, make it a varchar datatype and interogate with in the sproc.Brett8-) |
 |
|
|
|
|
|
DECLARE question