Search results for query: *

I want to insert an html file into a text field in my sql table. What is the syntax in doing this? I was trying "insert into blob_test...", but i cannot finish the statement. the file name is blob.html, and I need the entire source code from the html doc inserted into my table. The...

I have four new dell power edges each with dual xeon 1.8gz processors and 2gb of ram. I have set up the first three servers with a raid 5 data stripe, and the fourth I did a raid 10. I did some benchmarking, and I do not seem to notice any performance difference between the four servers...

how does one truncate a table variable inside a function? truncate table doesnt work. do I just set the var to '' and re-declare it? thanks!!

I have a foxpro .dll that I use via extended stored procedure to scrub addresses in a number of tables. I need to convert this dll to sql so as to improve performance. My first stab was to create a "Multi statement table function". I had hoped that I could select each row from my db...

I have a select statement that grabs 36 columns from my 40 column table in order to build a cursor on them so that I may compare each field to another table in order to prevent duplicate data from being inserted. Although slow, this process works fine when I only want to check one file at a...

Is there a way to only back up the data objects (schema) in a database, not the data itself? via BACKUP DATABASE? I have been generating the sql code for my views, tables, etc, but was wondering if there was an easier way to save all that info into source safe. Thanks!!

Why can I not pass the results of a dynamic string query straight into a variable? I have this query to find the max uid for a givern job run. I paramaterized the server name so that the table can be moved between servers for disaster recovery: declare @destsvr varchar(30), @file varchar(30)...

Please help settle a rather heated argument. Which would take up less space in a database table, a Null value, or an Empty String (ie. ' ')?

I have a 38 column table that I am trying to write a sproc that will insert a text file into it. I have been doing this via dts, but want to do it in tsql. The text data looks like this...