declare @strSQL1 varchar(8000)

declare @strSQL2 varchar(8000)

select @strSQL1 = 'select * '

select @strSQL2 = ' FROM authors'

EXEC (@strSQl1 + @strSQL2)

You should AVOID doing dynamic sql at all costs.  But above is something...

I have two helper functions I use.

Then you can do a

 SELECT ITEM

 FROM fnc_10_comma_delimited_int('1,3,5,6' , ',' )

(or use the string version for strings)

You get the point I think.  below are the...

I'm kinda pulling this from the memory banks, but here goes.

SQL Server 4.2 and 6.5 were based on Sybase code (I think).

Sql Server 7.0 was the first all Microsoft version.

I...

Looks like that option can dis-clude a CPU from SQL Server altogether. 

It looks "instance" helpful.  Like, you can say your production instance uses cpu 1 2 and 4 and...

You might consider, if you have the Excel XP library at your disposal, exporting the excel to XML, and then importing it from there.

I'm not sure if this is a...

Ok.  (btw, my name is Sloan)

What I did for this was have a form with a "Search" button.

This would populate (for ease, lets say a list box), with the Nameof...

This example works against the pubs db().

This will allow you to update 1:N (1 or many many) records.

This is sql server 2000 ONLY (or later naturally)

Procedure 1:

if exists (select *...

I think you're struggling thru the pains of "connected" or "disconnected".

6-7 years ago, most apps were "connected" over the local network.  So when you were editing a record, you had...

Even if most times you need "*", you should still write them out.

Why?

The table schema can change at a later time. 

like

june 2002, you table has the following columns

uid, lastname,...

1) I don't have any stored procedures - I do all my data manipulation through ADO recordsets.  I should instead create stored procedures, and call them from my code.

You can...

A couple of things.

Start thinking in terms of "buckets".  When you had a totally VB and Access product.. and if you're access db was on a network drive, any time...

this is kinda an experience thing.

also, notice that access uses (i think) -1 and 0 (true and false)... and sql server bit uses 0 and 1 (false and true).

Since that...

My only food for thought is if you control the sql server environment.

My old company started out doing non case sensitivity. Fine for about 1 year. We had...

Here is an example:

table1 has some data. and a primary_key (t1.primary_key)

table2 has a foreign key to the t1.primary key (t2.primary_key_fk)

Then, your business logic is that you do something like

"select...

I use "dirty reads" for reports. Display purposes, as already suggested.

If you understand what they are, then you can use them effectively. But as a general rule, I...