Alberto.Omini (6/18/2008)

---

I try to insert all record from a table in a database

to a equal table in another database

Insert into [DB1].TABLE1

(FLD1,FLD2,FLD3)

(

select

FLD1,FLD2,FLD3

from [DB2].TABLE2

)

TABLE1 and TABLE2 are equal !!!!

someone can help...

Sorry, you can pass table variables as parameters only in SS2008. You could use temp tables though (or a communication table).

A simple example is:

CREATE TABLE commtable

(

...

deastr (6/18/2008)

---

I need a procedure accepting series of ID's and retrieve data according to those ID numbers. Like this:

CREATE PROCEDURE tmp

(

@var nvarchar(MAX)

)

AS

select * from Table where ID IN(@var)

I thought of...

assuming the file is on...

paksyeet (6/18/2008)

---

Hi,

i have here a schedule backup which runs daily but it keeps appending the backup to one file only..

now, my problem is, it is(the backup file) getting bigger...

Soni (6/13/2008)

---

Hi,

I'm a newbie when it comes to SQL Server 2005. I was asked this question once about the impact of filegroups on performance. Please point me to some links...

sqldba (6/13/2008)

---

Hi Experts,

I have been given a task to do a test.

To put a load in the SQL server (large or purposely deadlocking query on non-indexed tables) to simulate...

You cannot restrict the permissions of the dbo. If you need to hide the table either create it in a different database or change the database owner, and add permissions...

Wayne Atherton (6/3/2008)

---

Hi guys/girls,

I have a UNC path that I need to pull back the last value of a backslash e.g.

\\value1\value2\value3

I need to store value3 in a variable. I...

Just make sure you do not use EXECUTE AS...

If you want to write a single update statement for the original table that you will later query witht he stetement you mention, you can use somehting like:

UPDATE test

SET...

SQL Server's optimizer is smart enough not to materialize the view.

Regards,

Andras

Hmm, I did not have much time 🙂

I'm glad you have found the solution.

Regards,

Andras

UPDATE tablename

SET TGI_CLUSTER_CODE = CASE WHEN CLUSTER_CODE IN ( '1M', '2M', '3M', '4M',

...

No setting (in either 2005 or 2008) 🙂 You will have to write t-sql for this.

Regards,

Andras