you'll get much more out of this doing it yourself. there is more than one error in your code. Don't be afraid of making changes to it.

Like almost all forums,...

i think Carolyn's right; for reference, this is the exact syntax i use to connect to an access database; if the last command, sp_tables_ex works, you are set up correctly,...

there's your error. change your table variable to a temp table instead.

looks like the lines...

the REPLACE command is what you want:

SELECt Replace(columnname,' ','') As Columname from YourTable

it might be hard to see, but the command is singlequote-space-singlequote for WHAT to replace, and is two...

Tom i don't think noncode is a valid descriptor; i think you need to use plain or text.

i saved this from a post previously so i had the valid tags...

pradeep's suggestion for a trigger to uppercase the input would work, and you could force only the upper case values to be inserted with a slightly different constraint:

Create table Patient...

lakshminarasimhanv (6/20/2009)

---

hi Thanks for your repl

Can you please tell me how to modify the script to delete records from master and check if any dependent child will be afftected....

that would be the easy part; since the temp table #Hierarchy has the tables in the right order, change the last SELECT statement to this:

SELECT

CASE WHEN FKLevel=0...

you must explicitly identify the column names, especial when identity_insert is on:

SET IDENTITY_INSERT MyTable ON

insert into MyTable(ColumnId,ColumnDate) values(3508,'06/07/2009')

zubamark (6/19/2009)

---

Hi,

I tried to execute in SQL Server 2005 Query Analyzer the following...

something like this should get you started:

SELECT

@Category As TheSelectedCategory,

CASE

WHEN ILCategory IN (3,4) AND SCCategory =1

THEN...

here's a script that creates the delete/truncate commands for all tables in the correct foreign key hierarchy order....

the issue I've always found is that often you have lookup tables, like...

Ok - but the problem is, sometimes the parent_id could change from another system. That's where I'm getting lost here. I'm trying to avoid using the parent_id as an identity....

you wouldn't open a trace file directly with notepad.

here's what i do:

i create a view for any trace i create, so I can easily access it.

here's a code example:

--review all...

Dugi's got you on the right track. use ISNULL to put in a default value, or raise an error before it gets to the trigger in the first place.

as...

ps (6/19/2009)

---

you can write a query to delete all tables in a schema.

Also wouldn't it be good to drop the database if you do not want tables to be there?

Question...