This article is for developers of Oracle applications who want to convert their applications to Microsoft SQL Server applications. The tools, processes, and techniques required for a successful conversion are described. Also highlighted are the essential design points that allow you to create high-p
Tag: sql server
Spring 2001 SQL Connections
SQL Connections is SQL Server Magazine Live and features over 40 non-stop SQL Server 2000 & SQL Server 7.0 sessions at the beautiful Hyatt Grand Cypress Resort. Come hear Microsoft's Ryan Trout, Swynk.com's Steve Wynkoop, and many other SQL Server experts reveal the latest SQL Server secr
Microsoft to Host Log-Shipping WebCast
Microsoft' s Reinaldo Kibel, a SQL Server support engineer, will be hosting a Support WebCast about SQL Server 2000's log-shipping functionality February 15 at 10 A.M. (Pacific time). The WebCast will cover SQL Server 2000 enhancements to this high-availability feature.
The SELECT statement
By Tony Rogerson. This tutorial looks at components of the SELECT statement and tries to put across as much information on use, the way it works, best practices etc., based upon working experience of the author as possible.
Handling Errors in Stored Procedures
The following article introduces the basics of handling errors in stored procedures. If you are not familiar with the difference between fatal and non-fatal errors, the system function @@ERROR, or how to add a custom error with the system stored procedure sp_addmessage, you should find it interestin
SQL Server 2000 is the FIRST application to be Windows 2000 Datacenter Certified
SQL Server 2000 is the first application to be Windows 2000 Datacenter Server certified. Certification was completed by VeriTest, an independent testing and compliance laboratory that is a service of Lionbridge Technologies, Inc. The certification of SQL Server 2000 demonstrates Microsoft's comm
SQL for Threaded Discussion Forums
From SQL Team.com, One of questions we get on a regular basis involves threaded discussion forums. Everyone wants to know an easy way to do this. Everyone is also trying to do recursive SQL or self joins to make this work. That's hard. Here's an easy way to do this.
Whistler Beta 2 to Go Public
According to a report in CRN, Microsoft will ship Whistler Beta 2 in February, and a public beta of the OS "in 60 to 90 days." The report, which remains unconfirmed by Microsoft, refers to Whistler as "Windows 2000 version 2" and it's follow-up, known as Blackcomb, as "Window
Using COALESCE to Build Comma-Delimited String
This article, by Garth at SQL Team, talks about building a comma-separated value string for use in HTML SELECT tags. It's also handy anytime you need to turn multiple records into a CSV field. It's a little longer and has some HTML but a good read.
Embarcadero Technologies Announces that GDPro is Microsoft VBA Certified
Embarcadero Technologies, Inc. (NASDAQ: EMBT), provider of application and database lifecycle management solutions, announced that GDPro, the visual UML development tool for eBusiness applications, has received Microsoft’s Visual Basic for Applications* (VBA) logo certification. In conjunction with