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
 SQL Server 2000 Forums
 Transact-SQL (2000)
 function

Author  Topic 

ermese
Starting Member

5 Posts

Posted - 2004-11-03 : 03:23:08
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)

Kristen
Test

22859 Posts

Posted - 2004-11-03 : 03:30:44
quadruplicate post http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=42065
actually, more correctly duplicate of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=42068
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2004-11-03 : 03:38:34
quote:
Originally posted by Kristen

quadruplicate post http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=42065
actually, more correctly duplicate of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=42068



and he posted again in General, so will make it pentuplicate?

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

- Advertisement -