quote:

---

is there any advantage to use

select @SchoolNum = '190'

instead of

set @SchoolNum = '190'

---

They're equivalent. ...

That sound like a job for a CASE expression.

--Jonathan

I don't understand. How do you know if a NULL value is to represent keeping the existing value or changing the existing value to NULL? Aren't you asking one...

I STRONGLY suggest you not hardcode the lists of SchoolNums into a stored procedure. If you cannot make this information an attribute of another existing (Schools?) table, then create...

sp_executesql supports parameters:

DECLARE @MyId int, @Questions sysname, @myName varchar(20), @sql nvarchar(300)

SELECT @Questions = 'Questions', @myName = 'Sql Server'

SET @sql = N'SELECT @TheId = QuestID FROM '...

quote:

---

create PROCEDURE test_sp

@SchoolNum int=NULL --sorry I like integer instead nvarchar(3). I think it is more efficient.

AS

if (@SchoolNum is null)

Begin

select @SchoolNum...

Easy enough with SQL-DMO...

Sub DropCreateIndexes(Server As String, DB As String)

Dim objServer As New SQLDMO.SQLServer

Dim objDatabase As New SQLDMO.Database

Dim...

Try bcp.

--Jonathan

quote:

---

Am I missing something obvious, or is that a poorly documented feature?

---

Not very obvious, but...

CREATE PROCEDURE InstrumentStudentAssign_sp

@SchoolNum nvarchar(3) = N'190'

AS

But if this is an integer, why have you declared it nvarchar(3)?

--Jonathan

If you're determined to use a SAN, then get their sizing utility from the SAN vendor.

Unless the databases are not subject to concurrent access, put OLTP and DSS databases on...

Isn't this just a classic case of using first normal form with a many-to many relation?

Create a States table with a primary key (tinyint IDENTITY?) and description for each state....

If you've got a string, then you'll need a hack:

http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm

If the data is not in a string, don't make a string for this purpose. Using it as...

quote:

---

I was wondering if splitting a RAID5 array (6x18Gb 10k) into 2 channels is good or bad or doesn't matter.

---