Programming SQL

Rename objects inside stored procedures and views
Imagine a database with a bad naming convention you wish to clean up - having some columns with the same names as the table and the identifier columns named as ID_<table name>. Writing a script to rename tables, columns and constraints using sp_rename is not a big issue having a data dictionary. However changing... 24 Jul 2008 11:53

Multithreaded SQLXmlBulkLoad Handle Leak...
Using: .Net (happens to be VB but same with C#) 2.0 SQLXML4 SQL Server 2005 I've got a multithreaded .Net application that uses the SQLXmlBulkLoad call and I'm not convinced the COM object is being released properly. The code is also called often and I'm not sure if I should be creating the object each ... 25 Jul 2008 04:17

Creating Advanced Search
Hi there, I am creating a stored procedure that will search my products database. The user will enter the search term and select whether they want ALL words or ANY words. Based on this selection I use either FREETEXTTABLE or CONTAINSTABLE. As I am using SQL2000 I do not have access to a Thesaurus, but I wou... 25 Jul 2008 05:19

INSERT
Hi Guys I have the data like this Declare @var nvarchar(max) Declare @type nvarchar(max) Declare @Fields nvarchar(max) DECLARE @samplingID INT SET @ID = 5 SET @VAR = '5~1~2' SET @TYPE = 'D~U~U' SET @FIELDS = 'Customer_name~address~city#Customer_name~address~city#Customer_name~address~c... 24 Jul 2008 14:58

How to write SQL function?
Hi, I have the follwoing in many views, I think it would be wise to create a function (scalar??) so that I can reuse it in the future. SELECT ... CASE WHEN dbo.tblEvents.EventDate BETWEEN '20061001' AND '20070930' THEN 'FY 07' WHEN dbo.tblEvents.EventDate BETWEEN '20071001' AND ... 24 Jul 2008 09:48

SQl 2005/Visual Basic 2008
Please excuse my ignorance, as I'm not overly with the inner workings of SQL, nor do I know programming very well. I've been given the task of taking all of the data from a table on our sql 2005 server, exporting it, and importing it into a SQl 2005 express client. This needs to be very straight forward, and ... 29 Jul 2008 15:46

Conceptually - how would you do this with datetime values in 2
Aaron - Thanks for your thoughts. I was vaguely aware that 2008 will offer separate date and time types. May experiment with 2008 Express when available. The interval may not need to be date dependent, but I was trying to plan something generic enough to allow a club to push say, 8 minutes between tee ... 23 Jul 2008 20:31

Bulkload with XML Format File Not Generating An Error for bad flat
Can we have an example couple of rows from your dataset? eg some of your normal rows, some of your "short rows"? "RCloninger(a)gmail.com" wrote: I am bulkloading client data using an xml format file. The client sends a flat file and each record is supposed to be fixed length (for the example below, 35 c... 25 Jul 2008 14:33

Bulkload with XML Format File Not Generating An Error for bad flat file
(RCloninger(a)gmail.com) writes: I am bulkloading client data using an xml format file. The client sends a flat file and each record is supposed to be fixed length (for the example below, 35 characters), ending with a carriage return line feed. However, occasionally they have a record that is short (say, 2... 23 Jul 2008 19:30

Roll Up IP-Location Database
I have an IP-Location database with columns FirstIP bigint LastIP bigint Country char(2) Region varchar(128) City varchar(128) FirstIP is always +1 more than LastIP of the previous row. LastIP is always -1 less than FirstIP of the next row. Here is some sample data: 50331648 50331903 ... 25 Jul 2008 10:26