Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: wildthing68
- Order by date
-
output from a variable table
You will need to use a stored procedure that posts into a temporary table (#table) then do a select on that. eg) CREATE STORED PROCEDURE sp1 AS BEGIN CREATE TABLE #temp (f1 VARCHAR(10)) <create a cursor over your table> <if f1 has changed then insert into temp page break (if not first) and...- wildthing68
- Post #2
- Forum: Sybase: Adaptive (SQL) Server
-
Column List In Update Trigger
I want to create an audit trail system in my db but only on certain tables and columns. I know I can do: IF UPDATE(col1) . . IF UPDATE(col2) . etc, etc what I whant to do is pull in the list of updated columns from the triggering command so I can use a table to control the auditted columns...- wildthing68
- Thread
- Replies: 0
- Forum: Sybase: Adaptive (SQL) Server
