Can you use a semi-colon to terminate a batch?

Your code will keep the variable in scope with a semi-colon.

INT are searched as INTEGERS in SQL server. You will typically filter by range or exact value. Not a string comparison.

I am curious why you need to search...

SELECT *

FROM CAFEEMPLOYEE

WHERE CONVERT(CHAR(8),COLUMN) LIKE '1%'

When you run a package from SQL server it runs under the SQL Agent Service account. You need to create a credential and a proxy to execute the job.

more...

Hi,

When a bulk insert is done from a flat file or a xls file, how do u ensure the rows are added in the same order as they are in...

GilaMonster,

You are absolutely correct. I forgot to mention that "column2" has to be an actual column in the table for this work. You cannot do this with column...

Ramesh,

I do not know if you have resolved this issue, but the reason we want you to check your compatibility level is because the new SQL 2005 features are not...

You cant put a function in a group by unless you set a column value = to it.

example:

SELECT mer_from_dttm fd,

column2 = DBO.FreqFortnightlyFunction('24-MAY-2006 2:40:00', '24-MAY-2006 2:40:00')

from...

I have used your script to successfully restore a database, with recovery. I am not sure why it is not working for you.

I would perform the backup in SSMS...

Agreed.

if you dont specify a length for varchar, it will default to 30.

Need a set statement

set @sql =

Dave has it the problem head on.

You cannot directly concatenate an integer into a string because SQL will try to convert the string into an integer. To...

Tim,

You need to specifiy the location of the .bak file.

e.g from disk = 'c:\ds1.bak'

Let me know if this works.

Your other option is to perform a backup of the database and restore on the production server. Detaching/Attaching is usually faster and just as reliable. Keep in mind...