Archives: August 2011
It’s time to get your server side trace on, with a little practical application!
Prerequisites: basic T-SQL, basic experience with SQL Profiler
- SQLServerPedia article: The Server-side…
Prerequisites: basic T-SQL (including JOINs and LIKE), basic knowledge of catalog views
Reading: SQL Server Books Online sys.sql_modules article.
Level 1 Assignments: Using sys.sql_modules, write a query… Read more
Prerequisites: basic T-SQL (including JOINs and LIKE), ability to search BOL
Reading: SQL Server Books Online sys.objects article.
Level 1 Assignments: Using sys.objects, write a query for… Read more
Bearing this in mind, I’m starting up an Applied SQL series of blogs, with the sole… Read more
Msg 195, Level 15, State 10, Line 2
‘SUM’ is not a recognized built-in function name.
Uhm, I’m sorry to contradict you SQL Server, but yes it is. Here’s the code that produced that error:
SELECT keyID Read more