If you are able to reproduce this error in Query Analyser, the message text will be more helpful (the meaningless variable placeholders will be replaced by the actual constraint and...

The alternative to

where field like '%word' is

where RIGHT(field,4) = 'word'

LEFT(field,4) gets the first four characters of field, not the final four.

Regards

Phil

Is this the sort of thing?

declare @col varchar(10), @SQLText varchar(255)

select @col = col

from t1

where id = 2

set @SQLText = 'select ' + @col + ' from f1'

exec (@SQLText)

It's possible to use xp_cmdshell to run commands outside of SQL Server - so this may be of help. I'm not quite sure what you mean by automating a...

So can you reproduce the error - I'm guessing not? But if you can, try stepping through the stored proc in debug mode and see whether that gets you...

Hi Karen

Not sure if this can be achieved directly through a view.

Here's an example of how you can get file info into SQL Server though:

declare @SQLText char(21), @app char(1)

set @app...

Check this out:

declare @str varchar(255), @enc varchar(255), @i int

set @str = 'have a banana'

set @enc = ''

set @i = 1

while @i <= len(@str)

begin

if @i / 4.0 -...

If you right-click/properties on a picture in an Access report (design mode), you can change the 'Picture Type' to 'linked' (default is 'embedded'). So the pictures can be stored...

Here's a quote from BOL: "Built-in nondeterministic functions are not allowed in the body of user-defined functions." Getdate() is, of course, non-deterministic, as it "may return different values when...

Your update query does not contain a WHERE clause. So what you are saying is

"If there are any records returned by the SELECT ... query, execute the following update...

Popular question! Check out this link:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=145515

Excuse my English ignorance, but is 12 the country code for Mexico? If so, wouldn't you want to store these numbers as + 12 ... ? If so,...

declare @str varchar(20)

set @str = 'a b c d'

select @str as orig_string, replace(@str, ' ', '') as no_spaces

Regards

Phil

No. Each table can (by definition) have only one clustered index - and whether that is on the table's primary key field or on some other field is down...

The maximum worksheet size in Excel is 65,536 rows by 256 columns, so it sounds like you have hit that limit. However, you can of course have multiple worksheets...