We have a 2012 Server running SQL 2012, recently the domain membership of the server was changed and now we cant login to studio manager i assume because the new domain admin account has no permissions.
I dont have the SA password or even know if SQL authentication was selected during install.
How can i add the new domain admin account as a sysadmin i assume to allow access.
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.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.