I just can not resist sharing this video which my wife took while I was reading the book I co-authored. After long debate with my wife I have decided to put this video on youtube for public viewing. I initially thought, it is good to just have this in personal collection but my wife Nupur insisted on putting it live.
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.
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
Reference: Pinal Dave (https://blog.sqlauthority.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.