cfx excel format cell problem for date format

I am still kicking alive… have been very busy with work and family to post here haiz..
Found great solution to my long term problem using cfx excel. Tried to format the date display so many times or make the format cell working till like failed! here’s the good solution at this url!
Solution:
1) Make sure the [...]

Read Full Post »

SQL Date Format Using Convert

My brains cannot store the list of convert numbers so here’s the url!
http://www.sql-server-helper.com/tips/date-formats.aspx

Read Full Post »

Still debugging trigger deadlock

Since earlier post, the deadlocks still occur… Now trying to resolve it step by step…
1. Opened my trigger script and see… It has for insert,update,delete and invoke stored procedure.
2. Trying to get all the triggers to compare.. I know I should not do this way but just checking
http://bytes.com/groups/ms-sql/609420-how-view-all-triggers
3. Tried running the connectionA and connectionB script [...]

Read Full Post »

SQL Trigger Deadlock

Trying to figure out together with a colleague on how to resolve sql trigger deadlock…
1. read up the articles to understand deadlocks
2.  turn on the DBCC traceon for 1204 and 3605
3. open the error log at Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG and ERRORLOG.n
4. trying to figure out what’s sqldiag utility tool is and how to use [...]

Read Full Post »

SQL Trigger

I know how to create a basic stored procedure but do not know what’s Trigger? Will need time to read up.
Url: http://www.sqlteam.com/article/an-introduction-to-triggers-part-i
More Urls:
http://msdn.microsoft.com/en-us/magazine/cc164047.aspx
http://www.devarticles.com/c/a/SQL-Server/Using-Triggers-In-MS-SQL-Server/
http://msdn.microsoft.com/en-us/library/aa299742(SQL.80).aspx

Read Full Post »