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 2005 Forums
 Transact-SQL (2005)
 problem with function for check student number

Author  Topic 

veronika.np
Starting Member

29 Posts

Posted - 2011-07-19 : 12:59:35
hi friends,
i have a table and in my table i have a student number column.
i have a function for checking digit in student number.
i write function but i don`t khnow how can i pass student number to function?do i user from loop for move between row?

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2011-07-19 : 13:18:34
You don't need to loop. You could do something like this:

select
studentNumber,
dbo.CheckStudentNumber(studentNumber)
from
YourStudentTable
Go to Top of Page
   

- Advertisement -