Week 5 update:
It was another full house yesterday with 17 kids and 4 parents attending the course. #sqlfamily #microsoftnz
The first 20 minutes were spent in solving issues with questions like --
- 'I created a table but I cannot see it'
- 'I am getting a syntax error'
After this, when I did the recap of what happened last week, I was pleased to see most of the kids eagerly answering my questions regarding update and delete statements. They were keen to discuss some of the SQL functions I covered There was a bit of difficulty in understanding the substring function. But finally everyone understood this function.
One of them wrote a substring function by passing her name as the first argument instead of the field name and tried to return a substring of her name which was quite impressive.
Tuesday, August 07, 2018
Week 6 update: Yesterday the class was a bit different because it started off with a Database Fundamentals test. There were 20 questions ...
This morning I was trying to call a stored procedure and insert the results in a temp table using the following code -- create table #...
When I tried to access the report manager after a fresh installation of Sql Server Reporting Serivces 2016 using the url http://localhost/R...