If interviewer is System Admin, then he might think to reject the candidate. 😉

It has some errors.

- It is RAISERROR not RAISEERROR.

- Function can be passed as argument.

Use below code for it

DECLARE @Error VARCHAR(150)

SET @Error = ERROR_MESSAGE()

RAISERROR (@Error,16,1)

Use RAISERROR statment inside CATCH block.

Replace semi-comma(;) with comma(,) in below line (third line of SELECT statement).

Try to write whole query in single line (one last hope).

SET @Query = 'Update [SQLSERVER\SQLINSTANCE].[Databasename].dbo.[Tablename] SET ...

Same thing will be application to

Where [Upload job] = ' + CAST(@UploadJob AS NVARCHAR) + '

chnage above to

Where [Upload job] = ''' + CAST(@UploadJob AS NVARCHAR)...

Modify this line to add single quote (')

SET [Last run] = ' + CAST(@LastRun2 AS...

GilaMonster (3/4/2009)

---

If the request is indeed for the last day of the following month, rather use this. Manipulating datetime using Dateadd and datediff is notably faster than converting pieces to...

Dugi (3/4/2009)

---

Sorry man, now is correct little mistake during the test of your script! So sorry! But ok the declaration is not correct for this forum ( SQL Server 2000/2005)!...

Yes, it gives the third part database connection but not with development support. It looks that I have to work manually for Sybase 🙂 .

Dugi (3/4/2009)[hr

Declaration of your variable here is wrong we are not in SQL Server 2008, please check the forum we are SQL Server 2000! So your code here will not...

Use this

DECLARE

@LastRun2 datetime,

...

Try this

DECLARE @DT DATE

SET @DT = '2008-03-04'

SELECT DATEADD(D, -1, (CAST(YEAR(DATEADD(M,2,@DT)) AS VARCHAR)+'-'+ CAST(MONTH(DATEADD(M,2,@DT)) AS VARCHAR) + '-01'))

This will return the last date of next month.

Then there is no way to do so using T-SQL. You can use managment studio to modify your SPs. Create Script for all SP in single file and use management...

This is very silly question. Interviewer must be crazy.

But you can say here. for mamagement studio it is mmc.exe for 2000, SqlWb.exe for 2005 and Ssms.exe in 2008.