You cannot use that syntax: the object to query cannot be a parameter.

You could use dynamic sql:

DECLARE @sql nvarchar(max)

SET @sql = 'SELECT * FROM ['+ @dbname +'].Table1'

EXEC sp_executesql @sql

Anyway you...

Please stop uploading unrelated content.

Don't download. Post reported.

Just pray that your employer doesn't come across this thread.

Good luck.

BTW, I will remember your name and never help you in these forums, because I don't think that this is...

If the cost of the query is on the delete step, there isn't much you can do.

You could drop and re-create...

SQL Server works great with Java. You just have to pick the right JDBC driver.

I have used JTDS and MSJDBC and they both perform well. Unfortunately they don't behave identically,...

You should get rid of the NOLOCK hint, both from the view and the query.

NOLOCK could return inconsitent results (eg. when a page spilt is involved).

You can use it safely...

With row by row, you...

You sigh, but Paul's reply made me laugh!:hehe:

Well, this works when you wouldn't be earning more...

Gianluca Sartori (10/2/2009)

---

Ti suggerirei di comprare un buon libro e di fare un bel po' di pratica sul campo.

Non c'è niente che possa sostituire la pratica. L'importante è capire cosa...

Ti suggerirei di comprare un buon libro e di fare un bel po' di pratica sul campo.

Non c'è niente che possa sostituire la pratica. L'importante è capire cosa succede a...

You could use the command line switches of SSMS/SQLWB

Ssms.exe|SQLWB.exe [-S servername] [-d databasename] [-U login] [-P password] [-E] [-nosplash] [file_name[,file_name]]

-S [servername] server name to connect to

-d [databasename] nome of the...

Still can't find anything wrong.

I suggest you try a SELECT first, so you can identify what's wrong.

SELECT stypc.*, spd.*,

newFlag = CASE WHEN spd.page_detail_id = 202

...

You could use something similar to this:

DECLARE @rwcnt int

DECLARE @BATCHSIZE int

SET @rwcnt = -1

SET @BATCHSIZE = 100

WHILE @rwcnt <> 0

BEGIN

SET ROWCOUNT @BATCHSIZE

UPDATE VeryLargeTable

SET varbinaryColumn = NULL

WHERE documenttypeid IN (4,...

I don't understand your problem. It's working on my test data.

DECLARE @Survey_Thank_You_Page_Config TABLE (

acct_id int,

survey_stub uniqueidentifier,

allow_invitation_forward_flag bit

)

DECLARE @Survey_Page_Detail TABLE (

acct_id int,

survey_stub uniqueidentifier,

page_detail_value int,

page_detail_id int

)

INSERT INTO @Survey_Thank_You_Page_Config (acct_id, survey_stub) SELECT

1, '57F2E213-BC6B-48CA-B025-1597688A8F96'...