I believe you could simply do something like IF NOT UPDATE(col_one) RETURN --if one of the rows was updated then use something like... SELECT * FROM inserted i, deleted d WHERE i.id = d.id AND IsNull(i.col_one, 'blah') != IsNull(d.col_one, 'blah') I'm not certain what you are doing with rows that change but if you can't […]
2003-06-11
We had exactly that problem. My way round was to create an index field and a "done" field in the table, and use a variable @index. When the trigger fires, get it to select @index as the MIN index field where "done" is 'N', use a WHILE @index is not null, and at the end […]
2003-06-11
quote: I'm confused, or more likely misreading the problem. Won't "IF Update(column_name)" be either true for all rows affected in a set-based update, or false for all rows? I think you are misreading it. The Inserted table and Deleted table contains ALL rows affected by the update. When you use IF update(column_name) it does return […]
2003-06-10
Your best bet would be to execute your VB Application or VBScript via xp_cmdshell. You could then use SQL Agent to schedule the executions of the xp_cmdshell script
2003-06-10
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-06-04
Does the Index Tuning wixard effect performance whilst you are running it? or should I wait until out of hours to run it ?
2003-06-03
2 reads
You have to run Profiler for the period of time as you like to trace which tables, views and SPs have been used and compare the results to your database. Use Index Wizard on your trace results to see the recommanedation which indexes sould be added and removed.
2003-06-02
2 reads
Hi AD, what about sp_depends <objectname>, though it does not work on indexes. See also BOL for sp_depends! Cheers, Frank
2003-06-02
1 reads
2003-05-28
1 reads
Here is another alternative: select cast((convert(char(13),getdate(),120) + ':00:00.000') as datetime) Gregory Larsen, DBA If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
2003-05-27
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers