The Modern Times

Calling COM From T-SQL Introduction If you need to store data or retrieve stored in SQL Server, no second thought is necessary and you will go for T-SQL. However, how can you integrate T-SQL with external applications? For example if you need to integrate SQL Server with Microsoft Exchange Server or MS Word, how are you going to accomplish this? There are seven extended stored procedures to call external applications like DLLs. Stored Procedure Description sp_OACreate Creates an instance of the OLE object on an instance of Microsoft SQL Server sp_OADestroy Destroys a created OLE object sp_OAGetErrorInfo Obtains OLE Automation error information sp_OAGetProperty Gets a property value of an OLE object. sp_OASetProperty Sets a property of an OLE object to a new value sp_OAMethod Calls a method of an OLE object sp_OAStop ...

1. Louisville, CO Courtesy: Brad Kemp/City of Louisville Top 100 rank: 1  Population: 18,400  Unemployment: 6.3% This sunny, lively mountain town is safe (crime rates are among the lowest in Colorado) and easy to navigate. Lots of good jobs in tech, telecom, aerospace, clean energy, and health care can be found right in Louisville, and more are on their way. And there's world-class mountain biking, hiking, and skiing in the nearby Rockies. Real estate prices have barely budged since 2005, yet a typical three-bedroom house here still runs less than a comparable one in nearby Boulder. Its schools consistently rank among the top three academically in the Denver area.  -Jessica Levine 2. Milton, MA                                                                     Courtesy: City of Milton Top 100 rank: 2 Population: 27,000   Unemployment: 6.6% Milton is just...

Suitcase [2 x 23 Kgs + 8 Kgs] I have created list of items to carry for students and professionals who are traveling for first time. I will be updating this list frequently for next few days. Its not complete yet, but it will give you an idea of what to buy and what not to buy when coming here for First time. US Travel - List of Items to Pack Dress/Clothes Jeans 3-4 India T-Shirts 10+ India Shirt - Casual 3-4 India Shirt - Formal 2 India Suit/Coat 1 India Coat and Suit are expensive in U.S. compared to India Shorts/ 3/4ths 5+ India Pants 2-3 India I don't like to wear pantsJ. I will go with Jeans Belts 2 India Leather is expensive in U.S. Formal Shoe 1 Pa...

Life Cycle of a Web RequestViewing a web page is a simple process for a visitor. Just type the URL in a web browser like Internet Explorer or click on a hyper link in any existing web page. The web browser will display the page instantly to you.But do you know that there are several computers involved in this process? Even though it is a very complex process, we can summarize the process as shown below:1. You type the web page address (URL) in a browser. For example, consider the current page http://www.aspspider.com/tutorials.aspx . This URL has 3 parts: The protocol - http: The server name - www.aspspider.com The file name - tutorials.aspx2. Browser communicates with a computer in internet called 'Domain Name Server' to find out the IP Address of the server (Eg: www.aspspider.com ). Browser establishes a connection to the web server at that IP Address. Server composes a 'Request' for the specified URL and sends the request to the web server to which it has ...

How quickly will taxpayers get refunds? Following technology improvements, the IRS will issue refunds to more taxpayers in as few as 10 days this year. But taxpayers should keep in mind that many variables can affect the speed of a tax refund. The IRS issues more than 90 percent of refunds within 21 days. Why can’t the IRS tell me the exact date I will get my refund? The IRS reminds taxpayers that refund time frames provided by the " Where's My Refund? " IRS2Go smartphone application (app) and tax providers are projected time frames and are subject to revision. Many different factors can affect the timing of the refund after the IRS receives the return for processing. Also, keep in mind that the date “Where’s My Refund“ provides is the estimated date the IRS will issue the refund, not the date the taxpayer will get the refund. It may take up to five additional days for the financial institution to post the refund to your account, or for mail delivery. ...

One fundamental aspect of 𝗣𝘆𝘁𝗵𝗼𝗻 is its set of 𝗸𝗲𝘆𝘄𝗼𝗿𝗱𝘀. These reserved words have predefined meanings and play crucial roles in the language's syntax and functionality. ➡ 𝗧𝗵𝗲 𝗨𝗻𝗱𝗲𝗿𝘀𝗰𝗼𝗿𝗲: (_) is a valid keyword in 𝗣𝘆𝘁𝗵𝗼𝗻, often used as a placeholder for a variable name when the value is not needed. 𝗛𝗼𝘄𝗲𝘃𝗲𝗿, it also has a special meaning in interactive 𝗣𝘆𝘁𝗵𝗼𝗻 sessions. When used as a variable name, _ stores the result of the last executed expression, allowing you to access it easily. ➡ 𝗡𝗼𝗻𝗹𝗼𝗰𝗮𝗹 𝗦𝗰𝗼𝗽𝗲 𝗥𝗲𝘀𝗼𝗹𝘂𝘁𝗶𝗼𝗻: The 𝗻𝗼𝗻𝗹𝗼𝗰𝗮𝗹 keyword, introduced in 𝗣𝘆𝘁𝗵𝗼𝗻 𝟯.𝟬, allows you to access and modify variables from an 𝗼𝘂𝘁𝗲𝗿 (𝗯𝘂𝘁 𝗻𝗼𝘁 𝗴𝗹𝗼𝗯𝗮𝗹) scope within a nested function. This keyword helps in solving common scoping issues and enables cleaner and more intuitive code organization. ➡ 𝗧𝗵𝗲 𝗩𝗲𝗿𝘀𝗮𝘁𝗶𝗹𝗶𝘁𝘆 𝗼𝗳 𝗲𝗹𝘀𝗲: Did you know that the 𝗲𝗹𝘀𝗲 keyword is not limited to if stateme...