Naive question on UDFs

Hi,
Is it a requirement of SQL server, that UDFs return values?
kdReturn is a non optional keyword so you have to give back something, but you
are forced to use it anyway :-)
So returning 0 and not using would be fine.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"kd" <kd@.discussions.microsoft.com> schrieb im Newsbeitrag
news:DC0C8797-CFEE-4B64-807E-EA22CF731A37@.microsoft.com...
> Hi,
> Is it a requirement of SQL server, that UDFs return values?
> kd|||kd
Are you talking about that you cannot pefrorm UPDATE/DELETE/INSERT to
underlaying tables?
"kd" <kd@.discussions.microsoft.com> wrote in message
news:DC0C8797-CFEE-4B64-807E-EA22CF731A37@.microsoft.com...
> Hi,
> Is it a requirement of SQL server, that UDFs return values?
> kd|||Since a UDF cannot perform Inserts Updates or Deletes, it would be pointles
s
to call a function that did a bunch of processing internally, that had no
external effect, and did not return anything to the caller. What would be
the point?
Having said that, I don;t think that SQL Server mandates that you actually
return anything...
"kd" wrote:

> Hi,
> Is it a requirement of SQL server, that UDFs return values?
> kd

Naive Question on Export Data

Hi All,
When data is exported, to another database, the primary keys are not
available in the exported tables. Is there a way to export the data in the
tables along with all the properties of the table, I mean creating a ditto
copy of the original table along with data.
Thanks
kd
If you want a replica of the database, I suggest you use backup and restore.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"kd" <kd@.discussions.microsoft.com> wrote in message
news:948F9BFC-7F18-4BFA-9572-F516066E539F@.microsoft.com...
> Hi All,
> When data is exported, to another database, the primary keys are not
> available in the exported tables. Is there a way to export the data in the
> tables along with all the properties of the table, I mean creating a ditto
> copy of the original table along with data.
> Thanks
> kd
>