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.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 function

Author  Topic 

ermese
Starting Member

5 Posts

Posted - 2004-11-03 : 03:21:40
I used function in programme.Because function return table
but below not runnig.
CREATE FUNCTION TestSatir
(
@SARJNO nvarchar(30),
@TestNo nvarchar(60)
)
RETURNS Table
As
DECLARE @SQL varchar(600)
SET @SQL =
'Select * From TestSatirSutun WHERE SARJNO='+@SARJNO+' and ISLKOD IN('+@TestNo+')'
RETURN(@sql)

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2004-11-03 : 03:40:29
this is fun..

nth post http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=42065

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -