I have a question.

Why are temp tables...

I need to ask...

Why in god sake are you returning a html control from the database?

Defining the type before or after the variable is just language flavor.

I never agreed "licensing for computing power" since its sounds some smart *** marketing guy saying "Hey, if you can afford a big server you can afford to pay more...

Thanks Samuel,

It can be achieved from many ways and for dynamic arrays we can use any kind of split function and strings.

But I miss the simplicy arrays can give for...

I miss arrays a lot in SQL. Like this:

create procedure ImissArrayParam(@array Array(Integer))

as

begin

select * from myTable where myId in @array

end

GO

GSquared (2/8/2012)

Assuming the database is on a server the person trying to steal your code has access to, all they have to do to steal your code is start a...

This is a good example of "dont rely on casting" when modeling.

(and implicit casting is still worst).

Since it appears to be only some type of academic exercise (students tables are...

You can encript yours SPs.

But I never used it in real world, I dont know if its easy to break.

From BOL:

"

...

ENCRYPTION

Indicates that SQL Server will convert the original text...

SQL Injection and Performance are 2 items from a wide list why I hate dynamic sql.

Some app use, at least, parameterized dynamic sql and it blocks most problems with SQL...

Gail,

After you post I changed my avat accordly.

All answers ill do the trick.

The solution from myself is just a trick to put both insert and update statements in the same procedure.

Jonhitech solutions is best for OO applications...

You are right, no verbatim literal strings to VB.net...sorry

But you can use:

Dim s as String _

= "string1" _

& "string2" _

& "string3"

😛

The partition design is different.

For the example above keep the first table definition.

So create a different table for each transaction type, all pointing tho the main transaction table.

The transaction table...

I dislike using dynamic SQL but for .net I sugest using @

String sqlcode = @" /*this

ill keep

the break lines

no need to fancy concatenations */

select *

from

mytable

where

myfavoritesqlresource = 'SSC';

";

😎