Thanks for your solution Lowell.

Thanks for the thread. May be my message was not clear enough. I am looking for a pure database SQL INSERT statement to insert records with image file...

I checked in the MSDN web site again but still don't have a clue. I believe I must use TEXTPTR function somehow! It would be helpful if anyone...

Many thanks Mark, you right that the compatibility level of my SQL database is up to SQL Server 2000.

I cannot run a profiler because I am not the DBA, I am a Database Developer. How can I find out whether the tables has been partitioned? I...

I should add extra information about my question. It happens for those tables with large number of records, let say more than 1 millions. The values are matching...

Well, I found a work around myself. First import the tables with data and then using SELECT INTO statement to copy data from SQL created tables into Oracle tables....

I used to use SQL Server 2000 and I could step through a stored procedure for debugging. Is this because of SQL Server Express doesn't include this feature for...

Thanks Jeff for your response and intention of trying to help. It is not a serious matter, I am just trying to learn SQL Server 2005 in my own...

It is just a suggestion and I can understand noeld's concern. In the past, I have completed at least 4 times of this kind of mass update with more...

Run the following query will give you a similar result as in Oracle DESC command:

SELECT c.colid 'Column Order',

...

You can achieve this task by using UltraEdit. What you need is to create a Macro and run it.

My Macro code looks like the following:

InsertMode

ColumnModeOff

HexOff

Loop 50

TrimTrailingSpaces

Find ")^PAS^PSET NOCOUNT ON"

Replace...

I know it is a bit late to join the disuccsion. I would do it that way? Any comment is welcome.

declare @var as varchar(100)

set @var = '12312ASD435ASDah4ddASD123123'

IF (PATINDEX('%[^0-9A-Za-z]%',...

Here is the link about SDET, if this is what the SDET the original post referring to!!!

http://www.spec.org/sdm91/sdet/

AC

Many thanks, it is working. Have a nice weekend!