SQL Programming Joes 2 Pros: Programming & Development for Microsoft SQL Server 2008 (SQL Exam 70-433) Volume 4

joes2pros4 SQL Programming Joes 2 Pros: Programming & Development for Microsoft SQL Server 2008 (SQL Exam 70 433) Volume 4Available at

USA: Amazon

India: Flipkart

eBook: Kindle

Rest of the world:
books ‘at’ SQLAuthority.com


The SQL developer needs to be able to create processes for the working database by using one of the many programming objects (like functions, stored procedures, constrains, or triggers). By creating objects that talk with SQL you simply the way other programs (like applications or web pages) can interconnect. These eternal programs only need to call on the names of your programming objects by name rather than needing to submit large pieces of advance code. With SQL Programming Development (Volume 4 of 5) in the SQL Server Joes 2 Pros development series, you learn how programming objects work in SQL Server.

Table of Content

Chapter 1 Constraints
Chapter 2 After Triggers
Chapter 3 Other Triggers
Chapter 4 Views
Chapter 5 Updating and Maintaining Views
Chapter 6 Stored Procedures
Chapter 7 Stored Procedure Techniques
Chapter 8 User-Defined Functions
Chapter 9 SQL Error Messages
Chapter 10 Error Handling
chapter 11 Change Tracking
Chapter 12 Change Data Capture
Chapter 13 Performance Tips by Pinal Dave
Chapter 14 Next Steps for Aspiring SQL Pros

[Amazon] | [Flipkart] | [Kindle]

16 thoughts on “SQL Programming Joes 2 Pros: Programming & Development for Microsoft SQL Server 2008 (SQL Exam 70-433) Volume 4

  1. Hi Pinal,

    Your blogs and articles have been extremely useful so far. Can you pls help me with my query below.

    I have upsized from access to sql server 2008. I am accessing my access forms/application from client pc which is in domain and sql server is in workgroup.

    So today, users just runs access forms from client machine and views / edits data. That is fine. But I don’t want that all users should be able to edit the data.

    How can i implement security in access so that only 1 user can change data and than rest everyone ( user may grow ) just can view the data in access forms but cannot change it ? I think, i have access 2003.

    Users will not access data anytime through SQL Server Management studio ( backend ). They will always access data through Access Forms ( front end )

    2) I see tablename_local tables in access after upsizing to sql server. Can I remove this local tables in access.

    Any help will be appreciated.


    • You can use the following:

      GETDATE() is used to generate current date time value, you can use your date field instead of it.


  2. hello pinal sir,
    i want make base in sql ,can you please tell me about what should i do,just suggest me about a book by which i can go ahead……………


Leave a Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s