-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: Raghu_78
Message 3 in Discussion
Adding
to this,
When using * , sql server looks for field
defintions as well. Instead by specifying the field names sql server will
directly access those ones.
-Raghu
-----Original Message-----
From: sachingpatel
[mailto:[EMAIL PROTECTED]
Sent: Thursday, May 20, 2004 3:43
PM
To: [EMAIL PROTECTED]
Subject: Re: Function in SQL
Server
New Message on BDOTNET
Function
in SQL Server
Reply
Reply to Sender Recommend
Message 2 in
Discussion
From: sachingpatel
Answers :
1. I
think you cannot call a function from c#, Make stored proc
and then call from there.
you can use the function name in select query
and then use select query in sqlcommand
object..
2.
Writing the column names is always faster than *, even if u
select all the columns.
SQL Server fetches the data for only
those columns specified in select column
list.
Hope this will clear your
doubts.
Sachin
Patel
View other groups in this
category.
DISCLAIMER:
This message (including attachment if any) is confidential and may be privileged.
Before opening attachments please check them for viruses and defects. MindTree
Consulting Private Limited (MindTree) will not be responsible for any viruses or
defects or any forwarded attachments emanating either from within MindTree or outside.
If you have received this message by mistake please notify the sender by return
e-mail and delete this message from your system. Any unauthorized use or dissemination
of this message in whole or in part is strictly prohibited. Please note that e-mails
are susceptible to change and MindTree shall not be liable for any improper, untimely
or incomplete transmission.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDOTNET/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
