SQL Server Tips I Learned This week

1. You know it’s time to ask for help when SQL Server keeps telling you that more and more columns are either not part of a group clause or an aggregate function

2. There’s a stored procedure that is the equivalent of DESCRIBE in mysql for mssql called sp_columns and it gives you more information than you could ever need

Thank you for reading. Please let me know if there are any clarifications I can make or further questions I can answer either down in the comments, on LinkedIn, or hit me up on Mastodon.

Related Posts