Another quick server management studio quick tip. We had just set up a test server for our project, but everytime I used SQL server management studio, and ran a query, it would run it on Master database and not on our database. Just for convenience, you can set up the default DB as so:
1. In [...]
Entries from February 2008
February 5, 2008
Setting your default database in SQL Server Management Studio
February 1, 2008
Displaying user’s computer’s date and time NOT server datetime
This sounded straightforward at first, I had to display the user’s date and time on an online web report. And from searching online, seems it can only be done in Javascript. Here is the code:
var months = new MonthArray(‘Jan’,‘Feb’,‘Mar’,‘Apr’,‘May’,‘Jun’,‘Jul’,‘Aug’,‘Sep’,‘Oct’,‘Nov’,‘Dec’);
var vUsersDate = new Date();
var day = vUsersDate.getDate();
var mon = vUsersDate.getMonth() + 1;
var year = vUsersDate.getYear();
var hour = vUsersDate.getHours();
var [...]
