[dba-SQLServer] trigger help

Jim Lawrence accessd at shaw.ca
Sun Jan 15 12:28:40 CST 2006


Susan:

It is sometimes confusing using the SP language where there is no 'end of
section/code'. The snippet either runs out of lines to process and
terminates or new 'structure' is started. Very confusing for us VB guys that
are use to a clean start and finish structure.

Jim 

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Susan
Harkins
Sent: January 15, 2006 7:24 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] trigger help

Well, once I deleted the END statement from the template it ran fine. 

Guys, what don't I know here? It doesn't seem right to me that an END
statement would've caused this problem. 

Susan H. 

I had a situation where I needed to create a table using fieldnames based on
other data, then run a query based on the new table.  However, because the
table wasn't permanent I couldn't create the query.  What I did was create a
normal table (tblTableName), base the query on that (SELECT * FROM
tblTableName).  Once the query was saved I could delete the table.  Since
the query was only run when the temporary table was created it worked.  Mind
you, the tables I created were not internal temp ones as I needed to access
them outside of the sproc that created them.  The sproc deleted the previous
copy of the table before creating the new one based on new data.


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list