Good point Jeff. If there are more than four rows 😀 an inline query gets a bad performance.

One question:

Did you figure out if a cross join performs better than an...

Hi

I'm no Powershell pro. But if you try to load CSV files into your database you should have a look at the SQL Server "bcp" command line utility or BULK...

Which kind of problem do you mean?

Jeff Moden (5/23/2009)

---

Florian Reischl (5/23/2009)

---

Jeff Moden (5/23/2009)

---

If I understand correctly, this is a stored proc that processes a single row? If it's used in conjunction with a GUI, that's...

Hi Barry

RBarryYoung (5/23/2009)

---

Could you explain that some more Florian? What kind of situation would you need to...

Jeff Moden (5/23/2009)

---

If I understand correctly, this is a stored proc that processes a single row? If it's used in conjunction with a GUI, that's probably ok. If...

You can use a inline query:

DECLARE @t TABLE (Id INT)

INSERT INTO @t

SELECT 10

UNION ALL...

Generally I agree with Steve, Bruce and Jack.

However a column "Name" seems to be no problem in my book. In SSMS2k8 it is no keyword anymore. Real problems are real...

Hi

You can create a dynamic SQL Statement:

DECLARE @sql NVARCHAR(4000)

DECLARE @newValue NVARCHAR(100)

SELECT

@sql = '',

@newValue = 'bah'

SELECT @sql = @sql + N'UPDATE ' + TABLE_NAME...

Hi Tim

If you are not sure if you are not sure about your SQL Server version you can execute this statement. It shows the detailed version information:

PRINT @@VERSION

If you use...

I heard several times people who stopped SQL Server service to get a copy. But I never heard somebody who killed the service from task manager to do this...

Something new for this threads topic:

Copying a database

:w00t:

davew01 (5/22/2009)

---

Good question. I called the club and the golf department manager indicated that he just exits the GHIN Handicap problem using the normal exit procedure using the File...

I'm not sure how they take the database copy but usually I would suggest to take a backup of the database to restore on your system.

I'm not sure which kind of security you are looking for. If you try to avoid that somebody accidentally manipulates any data you should try "Read-Only" property of your database.