SQL SERVER – UDF vs. Stored Procedures and Having vs. WHERE « SQL Server Journey with SQL Authority

Feeds:: Posts; Comments

« SQL SERVER – 2005 – Sample Example of RANKING Functions – ROW_NUMBER, RANK, DENSE_RANK, NTILE

SQL SERVER – T-SQL Script to Add Clustered Primary Key »

SQL SERVER – UDF vs. Stored Procedures and Having vs. WHERE

October 10, 2007 by pinaldave

Read my First Article in SQL Server Magazine – Oct 2007

Reference : Pinal Dave (http://blog.SQLAuthority.com)

Posted in SQL, SQL Authority, SQL Function, SQL Query, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology | 5 Comments

5 Responses

on October 12, 2007 at 6:53 am | Reply Shawn

Congradulations Dave,

Getting pulished in SQL Server Magazine is quite an accomplishment. With all the work you do for the community, you deffinately deserve it!

- Shawn
on October 12, 2007 at 11:58 am | Reply Divang Shah

Dave,

I enjoy reading the article. Wonderfully written.

TC
Divang
on October 17, 2007 at 1:28 pm | Reply S Grass

Dave,

I will tell you what people will like most : articles about SQL Profiler. Think why? There is always long articles. Write simple and write to the point. DBA will love you.

Cheers,
S G
on September 12, 2008 at 9:50 pm | Reply Ted

Pinal,

Could you address the differences between UDFs and SPs with regard to DML statements like INSERT, DELETE, UPDATE, etc?

It appears that UDFs cannot perform these operations, while SPs can.

Is that true?

Thanks,
Ted
- on March 8, 2010 at 4:16 pm | Reply Madhivanan
  
  Yes it is true

Leave a Reply Cancel reply

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Not published)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Connecting to %s

free community tool
About Pinal Dave

Pinal Dave is a Microsoft Technology Evangelist (Database and BI). He has written over 2000 articles on the subject on his blog at http://blog.sqlauthority.com. Along with 8+ years of hands on experience he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET). He is co-author of three SQL Server books - SQL Server Programming, SQL Wait Stats and SQL Server Interview Questions and Answers. Prior to joining Microsoft he was awarded Microsoft MVP award for three continuous years for his contribution in community.

Follow @pinaldave Send +Pinal Dave an email at pinal@sqlauthority.com
Blog Stats
- 36,724,037 (36 Million+)
Email Subscription

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 15,917 other followers
Next Office Hours

Jan 3, 2012 1130 Indian Standard Time (0600 GMT)
Books I Authored

. Amazon|Flipkart|Kindle

. Amazon|Flipkart|Kindle

Amazon|Flipkart|Kindle
SQLAuthority Links

Subscribe to Newsletter
My Homepage
Windows Live Blog
--------------------
Top Downloads
PDF Downloads
Script Downloads

Script Bank
Favorite Scripts
All Scripts - 1
All Scripts - 2
All Scripts - 3

Top Articles
Best Articles
Favorite Articles - 1
Favorite Articles - 2
--------------------
> SQL Interview Q & A <
SQL Coding Standards
SQL FAQ Download
--------------------
Jobs @ SQLAuthority
About Nupur Dave

Nupur Dave loves technology simply because it makes life more convenient. She is devoted to technology because it touches our heart makes our daily lives easier. Among the many technological programs she uses and embraces Windows Live most because she can do lots of things with ease – from photo management to movies; business emails to personal social media connections.
Disclaimer

This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet/ BOL. My employer do not endorse any tools, applications, books, or concepts mentioned on the blog. I have documented my personal experience on this blog.
- Home
- All Articles
- SQL Interview Q & A
- Blog Stats
- Contact
- Tools
  - Expressor
  - Pluralsight
  - Embarcadero
  - Manage Engine
  - Idera
  - Red Gate
  - SafePeak
- SQL Books
- >>Search<<
Categories
- About Me (145)
- Best Practices (143)
- Business Intelligence (36)
- CodeProject (10)
- Data Warehousing (49)
- Database (321)
- DBA (137)
- DMV (13)
- Joes 2 Pros (47)
- MVP (147)
- PASS (14)
- Readers Contribution (114)
- Readers Question (126)
- SharePoint (7)
- Software Development (69)
- SQL Add-On (99)
- SQL Azure (15)
- SQL Backup and Restore (79)
- SQL BOL (11)
- SQL Coding Standards (21)
- SQL Constraint and Keys (57)
- SQL Cursor (28)
- SQL Data Storage (59)
- SQL DateTime (47)
- SQL DMV (23)
- SQL Documentation (299)
- SQL Download (310)
- SQL Error Messages (161)
- SQL Function (161)
- SQL Humor (29)
- SQL in Sixty Seconds (1)
- SQL Index (155)
- SQL Interview Questions and Answers (139)
- SQL Joins (77)
- SQL Milestone (25)
- SQL Optimization (152)
- SQL PASS (20)
- SQL Performance (340)
- SQL Puzzle (94)
- SQL Security (127)
- SQL Server DBCC (42)
- SQL Server Management Studio (44)
- SQL Service Pack (13)
- SQL Stored Procedure (116)
- SQL String (26)
- SQL System Table (61)
- SQL Trigger (24)
- SQL User Group (57)
- SQL Utility (153)
- SQL View (26)
- SQL Wait Stats (41)
- SQL Wait Types (42)
- SQL White Papers (67)
- SQL XML (12)
- SQLAuthority (632)
  - SQL Training (19)
  - SQLAuthority Author Visit (141)
  - SQLAuthority Book Review (39)
  - SQLAuthority News (577)
  - SQLAuthority Website Review (42)
- SQLServer (227)
- Tech (1587)
  - Pinal Dave (1574)
  - SQL Scripts (860)
- Technology (2032)
  - PostADay (453)
  - SQL (2032)
  - SQL Authority (2032)
  - SQL Query (2031)
  - SQL Server (2032)
  - SQL Tips and Tricks (2032)
  - T SQL (2032)
- Video (5)
Top 3 Commenters

  2251- Madhivanan
  474 - Imran Mohammed
  301 - Ramdas Jaya

Follow

Follow “SQL Server Journey with SQL Authority”

Powered by WordPress.com