(Simon Sabin) Performing bulk inserts into a table when the table has an identity column has long bee a difficult challenge for client programming.
Other News
Top 10 List for SQL Server – Need Your Input
Featured Article(s) Find out the last updated date of SP, UDF, Views, Triggers in SQL Server 2005 (Vadivel Mohanakrishnan) This article explains the way to list the last updated datetime of Stored procs, user defined functions, views and triggers in SQL Server 2005. Watch SSWUGtv The following are available now: [Watch] – SelectViews SQL Server Show – Microsoft interviews, features […]
Pulling truly random rows from a table
(Greg Sabino Mullane) In a previous article, I shared some ways of getting a random row from a table. I focused mainly on the “random column” method, but I’d like to revisit the “range of values” method in more detail, and show why it is a better choice. In short, the random column method (basically
Integrating IBM WebSphere Portlet Factory V6.0.1 with IBM WebSphere Portal Document Manager
(Abhishek Singh and Georgiana Ivy Avram) IBM WebSphere Portlet Factory V 6.0.1 provides builders that facilitate creating, retrieving, updating, and deleting content in IBM WebSphere Portal Document Manager. This article describes these new builders and demonstrates their use through a sample applic
Using PHP 4s DOM XML Functions to Create XML Files from SQL Data
(Tony Marston) This tutorial is intended for developers who wish to extract data from a database and insert it into XML files so that it can be processed in some way, usually by transforming it into HTML using an XSL file.
Using PropertyGrid in .NET
(zaletskiy yura) PropertyGrid is a standard component in Windows forms, that is in both 1.0 and 2.0 versions of the .NET Framework. This component allows the developer to display properties for nearly all types of objects without writing any additional code.
Oracle BI EE 10.1.3.3/2 – Report Bursting using Delivers – Phase1 Using Pipelined Functions
(Venkatakrishnan J) One of the very good features of BI EE is its ability to burst and send the reports to multiple users simultaneously. Lets look at how to go about achieving bursting and also at the same time look at some additional examples of how to send out the reports to multiple users whose
TableDiff.exe utility in SQL Server 2005
We have talked about the command line utilities in SQL Server 2005 and have covered some of them like SQLCMD in some detail before. In this post, we will go over the tablediff.exe utility. This utility is typically used to troubleshoot data mis-matches in two tables in a replication scenario where t
DB2 Stored Procedure Exceptions
(Martin Hubel) A customer asked me to develop a function to check whether a character string was in fact numeric with the further stipulation that it be done in SQL. He reported that the documentation seemed to be lacking.
Can RSS & XML Help Us Build the Data Web?
(Ric Hardacre) The Web is full of data: statistics, surveys, and reports can be found on almost any topic you care to search for. It’s this very fact that makes the Web the first stop in anyone’s research. Want to know the average number of petals on a daisy? Thirty-four. The number of species of wh