You do not need to use substring if you are grabbing the first 4 chars.

You query should look like this:

update table

set number = replace (number,6666,left(number,4))

I thought you wanted to replace the 666 with the first 3 digits??? You have your query backwards!! In your query you are replacing the first 4...

DECLARE @test-2 TABLE(

STRING VARCHAR(9)

)

INSERT INTO @test-2

SELECT '123456789' UNION ALL

SELECT '123456669'

UPDATE @test-2

SET STRING = REPLACE(STRING,'666',LEFT(STRING,3))

WHERE STRING LIKE '%666%'

SELECT *

FROM @test-2

select convert(varchar,getdate(),101)

Except, Where not exists, and Not In all use the same execution plan. The difference here is going to be syntax.

Here is an blog about some...

I guess its not just me!! 😉

I am not entirely sure I follow what you are after. This article will provide you some help tips on how to post your problem correctly, so members are...

This is quoted from the BOL entry about EXCEPT

EXCEPT

Returns any distinct values from the query to the left of the EXCEPT operand that are not also returned from the right...

add the -n swich to remove numbering.

1) In the 'like' comparison - changed '!%' to '%!%%'

2) In the CHARINDEX - changed CHARINDEX([field16],'%') to CHARINDEX('%', [field16])

3) You had an extra parenthesis ')' in the last Case statement...

You will have to use either OSQL or SQLCMD, ISQL is not the correct command liine utility.

SQLCMD -i "C:\TEST.SQL" -S SERVERNAME -d DATABASENAME -U USERNAME -P PASSWORD...

GSquared,

These IIF look a little more nested than you displayed, but my ACCESS is pretty rusty. I thought the query should look something like this.

select

case when [DBA_cs_project].[creator_id] Like...

I have done a little research and it seems that if any constant is put into count the SQL server database engine will automatically interpret this as count(*). The...

Collin has a very good point here. The only sure fire way to determine if a backup is "good" is to restore; however, you can also add some additional...

Do you have to do it remotely or can you setup a .bat file on the SQL Express server to execute sqlcmd to backup the database? You can then...