SnowTweet
Xe Dap Oi !INSTEAD OF DELETE triggers can be defined on a view or table to replace the standard action of the DELETE statement. Usually, the INSTEAD OF DELETE trigger is defined on a view to modify data in one or more base tables.
www.KLEphoto.com
Browsing Posts tagged sql
SELECT ROUTINE_NAME, ROUTINE_DEFINITION,* FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE ‘%scope_identity()%’
AND ROUTINE_TYPE=’PROCEDURE’
This document describes how to create a Linked Server reference in SQL Server which points at a MySQL database, and how to query through the Linked Server connection. 1. Download the MySQL ODBC driver from dev.mysql.com 2. Install MySQL ODBC driver on Server where SQL Server resides – Double Click Windows Installer file and follow [...]
When you try to install Microsoft SQL Server 2000 on a computer that has certificates,installation can fail and you may receive the following error message: [Microsoft][ODBC SQL Server Driver][Shared Memory]SSL Security error [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (SECDoClientHandshake()). SQL Server configuration failed. -or- When you add certificates to a server that already has SQL Server [...]
When you perform any data modification operations (INSERT, UPDATE, or DELETE statements) table fragmentation can occur. When changes are made to the data that affect the index, index fragmentation can occur and the information in the index can get scattered in the database. Fragmented data can cause SQL Server to perform unnecessary data reads, so [...]
To shrink the file size I use the following script: Use DBName Go exec sp_dboption DBName, ‘trunc. log on chkpt.’, true checkpoint DBCC SHRINKFILE (N’DBNameFileName, 0); exec sp_dboption DBName, ‘trunc. log on chkpt.’, false
