Tec Lab

How to get OLD / NEW Values in SQL Server Triggers

CREATE TRIGGER trig_updateEmployeeName ON HS_PR_EMPLOYEE FOR UPDATE AS DECLARE @oldName VARCHAR(100) DECLARE...
ADO Recordset Filter using date criteria causing an error

http://www.tek-tips.com/viewthread.cfm?qid=1259781&page=1
restart the IIS server from Bat File

@echo off REM - File: iisrestart.bat REM - Description: Restart's IIS (Web) REM - Author: Thusith de silva from HBS REM - ADD ...
ORACLE IS_MEMBER function like in SQL SERVER

CREATE OR REPLACE FUNCTION IS_MEMBER( USER_ID Varchar ) RETURN NUMBER IS dResult NUMBER; sLoginUser Varchar(200); ...
(no title)

http://www.codeproject.com/Articles/188226/Introduction-to-ASP-NET-MVC-3
Setup for Performance Testing: Clear cache, buffers (MSSQL) [sql] [testing] [performance] [mssql]

For Microsoft SQL (MSSQL). Use this to clear the cache and buffers to ensure comparison are accurate. dbcc freeproccache go dbcc dropcleanbu...
How to change UUID of VirtualBox vdi

http://www.randallkent.com/virtual-box/change-uuid-of-virtualbox-vdi
What is MVC Model View Controller

This video explains the concept of MVC software architecture pattern, stands for Model View Controller.
How to export the data to existing EXCEL file from the SQL Server table

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926 IF EXISTS (SELECT srv.name FROM sys.servers srv WHERE srv.se...
SQL SERVER 2005 builtin Encryption

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'SecretTable_SecretData_Key' GO CREATE CERTIFICATE SecretTable_SecretData_Key ...

Simple theme. Theme images by Jason Morrow. Powered by Blogger.

Wednesday, October 7, 2009

SQL Server Tips and Tricks

No comments:

Post a Comment