Why not just encode your stored procedures ?

Example ;

create procedure sp_Sample @param1 int

with ENCRYPTION

as

I am not sure just how "secure" your security needs are here.

Admittedly, the encryption...

Hi.

It would go something like this.

Step 1

First, add your new column.

Alter table TableName add NewCol int default(0) not null

I think that you must have a not nullable column....

I would be interested in hearing any argument(s) as...

Yikes ! In my previous post, some of my Sql shorthand notation ended up a smiley emoticons ! :w00t:

I did end up solving isue #1. FYI, in Oracle Sql the...

you could also use sp_executesql.

like this ;

declare @sql nvarchar(2000),

@vars nvarchar(500)

set @sql = N'SELECT * FROM @DBNAME.@SCHEMA.@TABLE'

set @vars = N'@DBNAME...

The way that I've done this successfully in the past was to use the expressions to replace the Excel Filename property with the filename from some variable.

My observation has...

The way that I've done this successfully in the past was to use the expressions to replace the Excel Filename property with the filename from some variable.

My observation has...

LOL. There is some comfort in knowing that I'm not the only one gets upset about this particular genre of queries.

It brings up a more serious question. Is it the...

Sandy,

I was actually able to get this to work in SQL2005 as follows ;

Created a spreadsheet with data like yours, with 2 columns, StdCode and BoardLine1 (field names in 1rst...