hey all, does any one know an effective way to "Error Handle" an 'unexpected End Of File' in BCP using Tsql ? it doesn't seem to return a error code and I'm not familiar with a way to catch the SQL state return code. I prefer not using Bulk Insert in this case. anybody ?...more >>

I got a huge table which store horse information, the table look like this: Date Horse Weight Distance Point 20030529 B 115 1800 99 20030601 A 130 1600 95 20030601 B 121 1200 100 20030605 A 115 1200 100 20030609 B 111 1600 101 2...more >>

I got a huge table which store horse information, the table look like this: Date Horse Weight Distance Point 20030529 B 115 1800 99 20030601 A 130 1600 95 20030601 B 121 1200 100 20030605 A 115 1200 100 20030609 B 111 1600 101 2...more >>

Hi, ranking is determined by a formula that accounts for the frequency of the word in the document/row compared with the frequency of the word occuring in all documents/rows weighted against the total number of unique non-noise words in your catalog. Does this means that if I have fulltext ...more >>

Hello; I have a problem with an Oracle 8 D.B. over WIN2000 server (SP4); i can't start the service: OracleTNSlistener80, the message that I reveive is: The sistem don't return any error code. It may be a Windows internar error or an Oracle error. ¿Can anybody help me ? Many thansk ege@...more >>

Hi All, I have one table Customers in Northwind database. While performing FreeText search I want to give weightage ON Columns for a searched phrase. CompanyName weight (1) ContactName weight (.7) ContactTitle weight (.5) ...more >>

I have a table that I populate with users homedrive information everyday the fields I put in it are USERID, FULLNAME, MBSIZE, LOCATION, THEDATE id2,John Smith, 1400, \\file01\homedir\id2,7/5/2003 id3,John Doe, 1200, \\file01\homedir\id2,7/5/2003 .... I am currently just showing the data wher...more >>

Hi, Does anyone know how to retrieve binary image data from BLOB column of SQL database table and show it on the web page. I know "img src=" tag can be directed to an image file(.gif, jpeg). But how to program this tag for streamed data, such as retrieved BLOB streamed data through ADO i...more >>

How can i check if the record i want to select is already locked by another user? There is a way to know the resource id associated with the record in a table and compare that with those shown by the sp_lock? thanks -- Posted via http://dbforums.com...more >>

Hi again;) I have a table with columns ID, A and B. There is a trigger for update and insert, which modifies column B when A is changed (i use IF UPDATE(A)). When I import from a table in Access (containg only columns ID and A), after whole operation column B remain unchanged. Anybody know...more >>

I update a very large set of records. This is not critical operation and it takes a lot of time. Also transaction log grows very hudge. Is it possible to switch off transactions for this operation (or for any other stored procedure)? Nothing will heppen when some records will not be updated....more >>

How can i check if the record i want to select is already locked by another user? There is a way to know the resource id associated with the record in a table and compare that with those shown by the sp_lock? thanks -- Direct access to this group with http://web2news.com http://web2news.com...more >>

hi, In my database my date field having date and time info. But for selecting records i am passing only date value (No time). I am using following comparision cast(convert(varchar,DateField,101) as datetime) >= cast (Convert(varchar,''' + @FromDate + ''' ,101) as datetime) Any other b...more >>

Hi, I'm using ADO.NET to execute a stored proc. The stored proc contains a dynamic sql which will build the INSERT or UPDATE statement for execution at the end of the stored proc. I've a line that does some dummy inserts into a table before executing that dynamic sql, like exec ('INSERT...more >>

Hello, I have this table ID startDate endDate ------------------------------- 1 04/01/2003 07/30/2003 2 08/01/2003 09/30/2003 3 02/11/2004 04/15/2004 How can I get the ID when I give in my SELECT a DATE to find out if this DATE is between startDate and endDate? ...more >>