Search results
Did you not find what you were looking for? Try the Advanced Search for more precise search options.
8 items matching your criteria.
- How to discover which action fires a specific trigger in SQL Server [1%] by gmaguiar, 2009-02-06 11:11
- It's not uncommon the need to discover which action fires a specific trigger (in other words which actions that trigger is related).
- How to check the status for a specific trigger in SQL Server [1%] by gmaguiar, 2009-02-06 11:11
- Sometimes it's necessary to check if the status of a specific trigger is enabled or disabled to know if some actions will be or not be performed. This task ...
- How to Import Blobs To SQL Server (2005 and Later) [1%] by gmaguiar, 2009-02-06 09:22
- This tip describes how to import blobs into SQL Server 2005 and Later using TSQL. In past versions, there is a command line tool to provide this feature called ...
- Typical solutions to avoid using "NOT IN" on SQL Server [1%] by gmaguiar, 2009-01-31 13:08
- It's very common to use the operator NOT IN to retrive rows in table (or SQL statement) that are not in another table or other SQL Statement. This operator ...
- How To Update Data In One Table Related To Another Table On SQL Server [1%] by gmaguiar, 2009-01-29 18:53
- This tip describes how to update data in one table with data related to another table. It's not uncommon to perform this since the RDBMS link all the tables ...
- How To Retrieve All Tables and Number of Rows on SQL SERVER [1%] by gmaguiar, 2009-01-29 17:52
- This tip describes how to retrive all the tables names and the number of records of them
- How To Retrieve Rows Randomically in SQL Server [1%] by gmaguiar, 2009-01-29 17:54
- How To Kill All Users In Specific Database On SQL Server [1%] by gmaguiar, 2009-03-20 14:40
- This tip describe how to kill all the users in specific database on SQL Server. Is very common to need to kill all the users to perform maintenance tasks like ...