Some Shortcuts in SSMS Query Editor
List of Shortcuts which you can use while using SSMS Query editor.
1) Ctrl+Shift+Q -> Pops up the Query Builder
2)Highlight and Press Alt+ F1 Brings all the structural details for which an equivalent replacement is sp_help
3) sp_helptext 'SPName' for scripting out the code contents of a Procedure.
4) Ctrl+K, then Ctrl+C to comment lines
5) Ctrl+K, then Ctrl+U to uncomment lines
1) Ctrl+Shift+Q -> Pops up the Query Builder
2)
3) sp_helptext 'SPName' for scripting out the code contents of a Procedure.
4) Ctrl+K, then Ctrl+C to comment lines
5) Ctrl+K, then Ctrl+U to uncomment lines
Comments
post more times!!
Cheers!!
Check my last post... what you think to go to SQL Bits in UK next september?! Cheers!!
Pedro
I am Shyam from India. I contacted Pedro via blog comments for Msc Study in UK for Data Mining and Data Warehousing.
Pedro gave me the reply and he also mentioned your name that you have completed MSc in Data Warehouse and Data Mining from Greenwich University UK.
Subhash, I am planning to pursue Data Mining and Data Warehousing Msc dergree from UK. I have completed my BE and currently working with MNC in India as a Business Intelligence Resource. I have got 1 year of work experience in BI field (on Cognos 8.3 BI Tool, Informatica ETL Tool).
I have some queries regarding UK education.
-What are the job opportunities available for Data Mining or Business Intelligence Technology in UK?
-How is the quality of education in any UK university?
-Before taking MSc course, do we require any Data Mining Project Experience?
-Is part time MSc. Degree has any value in UK business market?
Subhash, it would be better if you can help me out with above queries. Your reply will really help me to take further important actions.
Warm Regrads,
Shyam Gohil.
-What are the job opportunities available for Data Mining or Business Intelligence Technology in UK?
Regarding Job opportunities. I did full time studies at UK. You require relevant experience and certification in BI, if you are looking for job at UK. To get a Work Visa is not that easy. Still I foresee lots of opportunities in UK, your expertise and self confidence in presenting your past experience how you brought bespoken results for your customers will put you into position you want.
-How is the quality of education in any UK university?
It depends on the University you choose.
Ones among top I have heard:
1. University of London
2. Oxford Brookes
4. Reading
5. Brunelle
-Before taking MSc course, do we require any Data Mining Project Experience?
Need not. Experiences will add to your eligibility and discount
-Is part time MSc. Degree has any value in UK business market?
It's valuable since you'll be into intense learning and exposure.
Thanks a lot for your reply.
I will also contact you, if I need any help.
Warm Regards,
Shyam Gohil.
How do i hide and unhide the column based on row toggle...
My report looks something like this
Category Product OrderId Amount
Bevrages Cooldrinks ORD123 120
So if i group on Category and display the Sum of amount, on hide of row product and OrderID will be blank. So in that case when it is + i want ti display Category and Amount and when it is - i want to display all columns