摘要:
1.软件试用注册码已过期,可以在注册表中删除注册信息后重新试用,方法:开始->运行>regedit Ctrl+F 输入关键字2. 修改Mysql安装文件中的my.ini 文件中的一个节点为[mysqld]max_allowed_packet = 512M# The TCP/IP Port the ... 阅读全文
摘要:
Have you ever faced a situation where you wanted to modify your existing table and was bugged with following error popup.Error were encountered during the save process. Some database objects were not saved.This is because by default saving changes to the table that requires table re-creation is disa 阅读全文
摘要:
Check out the [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel] located registry REG_DWORD "TypeGuessRows". That's the key to not letting Excel use only the first 8 rows to guess the columns data type. Set this value to 0 to scan all rows. This might hurt performance.I chan 阅读全文
摘要:
Generally one question is faced by very developer what is asp.net page life cycle every body know very well like sequence of asp.net page event likepage_initPage_loadPage_renderPage_unloadit is fine for standalone pages but if a page have master page then what the page life cycle? confuse!!!Below is 阅读全文
摘要:
The UPSERT command inserts rows that don’t exist and updates the rows that do exist. The Word UPSERT is a fusion of the words UPDATE and INSERT. UPSERT was officially introduced in the SQL:2003 standard.IF FOUND THEN UPDATEELSE INSERT;In SQL Server 2008, Microsoft introduces the UPSERT functiona... 阅读全文
摘要:
UPSERT functionality refers to either updating table rows based on some search condition, or inserting new rows if the search condition is not satisfied. This is intuitively seen from the word UPSERT - a combination of UPDATE (needed rows are present) or INSERT (needed rows are not present).The most 阅读全文
摘要:
SELECT TABLE_NAME AS TableName , COLUMN_NAME As ColumnName, CHARACTER_MAXIMUM_LENGTH As MaxCharacters FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name IN (SELECT name FROM sys.Tables Where name like '%Translation') AND ... 阅读全文