tag:blogger.com,1999:blog-65426936453521280442024-02-08T04:00:02.109-08:00C#, ASP.NET and SilverlightSalman Farsi Blog about C#, ASP.NET and Silverlight TutorialUnknownnoreply@blogger.comBlogger2125tag:blogger.com,1999:blog-6542693645352128044.post-75782159735474358472010-02-26T17:18:00.000-08:002010-02-26T17:26:28.636-08:00Some Common Interview Questions of SQL Server 2005.Whenever I go for interview for Software engineer job I face this question for SQL Server 2005, so my advice for those who want to get success in interview must have answers for the following questions.<br /><br />What are indexes and what types are they?<br />What is the difference between Stored Procedures and Functions?<br />What is the core difference in Clustered and Non-Clustered Indexes?<br />What is the difference between Unique Key and Primary Key?<br />What is Normalization?<br />What are the Joins and its types?<br />Differentiate between INNER JOIN and OUTER JOIN?<br />What is Cross JOIN?<br /><br />I'll give post answers for this question later.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6542693645352128044.post-29492366137463260232009-10-30T00:21:00.000-07:002009-10-30T00:27:47.429-07:00Simple Timezone Table for SQL Server 2005/2008Today I need a simple timezone table for SQL Server 2008, I do searching for different resources but didn't find any. So I compile it, developer normally frustrating when then have to search and didn't find a proper resource. So, I'm available it all those they are in hurry and want to use it.<br /><br />Following is the script and insert values for the table.<br /><br /><br />create table timezonedetail (<br />TimezoneID int identity(1,1) primary key,<br />TimezoneValue int,<br />GMT varchar(64) Not Null,<br />Location varchar(256) Not Null<br />)<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('0','GMT-12:00','International Date Line West')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('1','GMT-11:00','Midway Island, Samoa')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('2','GMT-10:00','Hawaii')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('3','GMT-09:00','Alaska')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('4','GMT-08:00','Pacific Time (US & Canada); Tijuana')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('10','GMT-07:00','Mountain Time (US & Canada)')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('13','GMT-07:00','Chihuahua, La Paz, Mazatlan')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('15','GMT-07:00','Arizona')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('20','GMT-06:00','Central Time (US & Canada)')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('25','GMT-06:00','Saskatchewan')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('30','GMT-06:00','Guadalajara, Mexico City, Monterrey')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('33','GMT-06:00','Central America')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('35','GMT-05:00','Eastern Time (US & Canada)')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('40','GMT-05:00','Indiana (East)')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('45','GMT-05:00','Bogota, Lima, Quito')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('50','GMT-04:00','Atlantic Time (Canada)')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('55','GMT-04:00','Caracas, La Paz')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('56','GMT-04:00','Santiago')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('60','GMT-03:30','Newfoundland')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('65','GMT-03:00','Brasilia')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('70','GMT-03:00','Buenos Aires, Georgetown')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('73','GMT-03:00','Greenland')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('75','GMT-02:00','Mid-Atlantic')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('80','GMT-01:00','Azores')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('83','GMT-01:00','Cape Verde Is.')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('85','GMT','Greenwich Mean Time : Dublin, Edinburgh, Lisbon, London')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('90','GMT','Casablanca, Monrovia')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('95','GMT+01:00','Belgrade, Bratislava, Budapest, Ljubljana, Prague')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('100','GMT+01:00','Sarajevo, Skopje, Warsaw, Zagreb')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('105','GMT+01:00','Brussels, Copenhagen, Madrid, Paris')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('110','GMT+01:00','Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('113','GMT+01:00','West Central Africa')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('115','GMT+02:00','Bucharest')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('120','GMT+02:00','Cairo')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('125','GMT+02:00','Helsinki, Kyiv, Riga, Sofia, Tallinn, Vilnius')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('130','GMT+02:00','Athens, Beirut, Istanbul, Minsk')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('135','GMT+02:00','Jerusalem')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('140','GMT+02:00','Harare, Pretoria')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('145','GMT+03:00','Moscow, St. Petersburg, Volgograd')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('150','GMT+03:00','Kuwait, Riyadh')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('155','GMT+03:00','Nairobi')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('158','GMT+03:00','Baghdad')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('160','GMT+03:30','Tehran')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('165','GMT+04:00','Abu Dhabi, Muscat')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('170','GMT+04:00','Baku, Tbilisi, Yerevan')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('175','GMT+04:30','Kabul')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('180','GMT+05:00','Ekaterinburg')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('185','GMT+05:00','Islamabad, Karachi, Tashkent')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('190','GMT+05:30','Chennai, Kolkata, Mumbai, New Delhi')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('193','GMT+05:45','Kathmandu')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('195','GMT+06:00','Astana, Dhaka')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('200','GMT+06:00','Sri Jayawardenepura')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('201','GMT+06:00','Almaty, Novosibirsk')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('203','GMT+06:30','Rangoon')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('205','GMT+07:00','Bangkok, Hanoi, Jakarta')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('207','GMT+07:00','Krasnoyarsk')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('210','GMT+08:00','Beijing, Chongqing, Hong Kong, Urumqi')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('215','GMT+08:00','Kuala Lumpur, Singapore')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('220','GMT+08:00','Taipei')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('225','GMT+08:00','Perth')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('227','GMT+08:00','Irkutsk, Ulaan Bataar')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('230','GMT+09:00','Seoul')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('235','GMT+09:00','Osaka, Sapporo, Tokyo')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('240','GMT+09:00','Yakutsk')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('245','GMT+09:30','Darwin')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('250','GMT+09:30','Adelaide')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('225','GMT+10:00','Canberra, Melbourne, Sydney')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('260','GMT+10:00','Brisbane')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('265','GMT+10:00','Hobart')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('270','GMT+10:00','Vladivostok')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('275','GMT+10:00','Guam, Port Moresby')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('280','GMT+11:00','Magadan, Solomon Is., New Caledonia')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('285','GMT+12:00','Fiji, Kamchatka, Marshall Is.')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('290','GMT+12:00','Auckland, Wellington')<br />INSERT INTO timezonedetail (TimezoneValue, GMT, Location) values ('300','GMT+13:00','Nuku''alofa')Unknownnoreply@blogger.com0