Hi I have a wierd problem in that I opened up my DB this morning and went into Design view of one of my Views. I can see the tables, fields etc but no code for the SELECT query. None of my other queries have this problem. I've tried moving the boundaries about to see if it's just obscured but to no avail on this specific View. Unfortunately I don't have the code saved anywhere else and need to get to the code asap. Please advise how I can view the code again for my View. I'm using SQL Server 2012 (Express).
Do your self a favor and ditch the Designer. Instead open VIEWs, Stored Procedures, etc. in the query window, by simply right clicking the VIEW in Object Explorer and selecting "Script View as" | "Alter
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.