You can buy my book from Amazon.com and Flipkart. We did receive few notes from user that it is listed as out-of-stock. There may be some glitch but the book has been always available as there is enough copies of the same. The book is SQL Programming Joes 2 Pros: Programming and Development for Microsoft SQL Server 2008.
US:
India:
If you are from other countries, you can still get it from Amazon where it delivers. The content of Book4 are as listed below:
- Contraints
- After Triggers
- Other Triggers
- Views
- Updating and Maintaining Views
- Stored Procedures
- Stored Procedure Techniques
- User-Defined Functions
- SQL Error Messages
- Error Handling
- Change Tracking
- Change Data Capture
- Performance Tips by Pinal Dave
- Next Steps for Aspiring SQL Pros
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
4 Comments. Leave new
Hi Sql Team,
I Need Your Help.
I Have One Table In Which I Have one Column Having name ‘Status’.
In Which I Have Stored ‘Match’ and ‘UnMatch’. Value.
I Want the Total Num. Of match and Unmatch Values.
SELECT [Status], COUNT(*)
FROM [dbo].[Table]
GROUP BY [Status]
Good Answer
I liked it, and agree with your wife.