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:16:15
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:20:11
uhmm... you forgot the question?

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

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2004-11-03 : 03:47:00
1. you can do without the D-SQL
2. you did not execute the @sql
3. check BOL for function

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

- Advertisement -