Tec Lab

Technical help Lab for developers

Monday, May 10, 2010

The ADO recordset Filter Property

http://www.devguru.com/technologies/ado/quickref/recordset_filter.html

Posted by Unknown at 9:44 PM 1 comment:

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Great Recursive SQL SELECT

Check this out

Select HIE_NAME,HIE_CODE,HIE_COST_CENTRE FROM HS_HR_HIERARCHY
CONNECT BY
PRIOR HIE_CODE = HIE_RELATIONSHIP START WITH HIE_CODE = '013'

http://www-128.ibm.com/developerworks/db2/library/techarticle/0307steinbach/
0307steinbach.html

Posted by Unknown at 8:58 PM No comments:

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Newer Posts Older Posts Home

Subscribe to: Posts (Atom)

Pages

Home
SQL-SERVER

Search This Blog

Blog Archive

August 25 - September 1 (1)
July 21 - July 28 (1)
December 23 - December 30 (1)
November 4 - November 11 (3)
August 5 - August 12 (1)
July 8 - July 15 (1)
April 29 - May 6 (1)
November 20 - November 27 (1)
June 12 - June 19 (1)
January 9 - January 16 (1)
October 17 - October 24 (1)
October 3 - October 10 (2)
September 26 - October 3 (2)
July 11 - July 18 (1)
May 9 - May 16 (2)
May 2 - May 9 (1)
March 7 - March 14 (1)
February 21 - February 28 (1)
December 13 - December 20 (1)
December 6 - December 13 (3)
November 15 - November 22 (9)
November 8 - November 15 (2)
October 25 - November 1 (2)
October 4 - October 11 (3)
September 20 - September 27 (2)
August 9 - August 16 (1)
August 2 - August 9 (5)
July 26 - August 2 (1)
July 19 - July 26 (1)

About Me

Unknown

View my complete profile

Followers

Popular Posts

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.