tt-programmer.blogspot.com
Tips And Tricks Programmer: November 2009
http://tt-programmer.blogspot.com/2009_11_01_archive.html
Tips And Tricks Programmer. Wednesday, November 25, 2009. Data Dictionary Using Query SQL. When we want to summarize all the tables on database from SQL we need the query to make it simple and fast. here the query :. Select distinct b.name, a.name, c.name, a.max length,c.precision, c.scale. From sys.columns a left join sys.objects b. On aobject id = b.object id. Left join sys.types c. On csystem type id = a.system type id. And cuser type id = a.user type id. Having A Nice Try…. Monday, November 16, 2009.
tt-programmer.blogspot.com
Tips And Tricks Programmer: December 2009
http://tt-programmer.blogspot.com/2009_12_01_archive.html
Tips And Tricks Programmer. Sunday, December 13, 2009. Generate System Column ID based on Format Required in SQL. If we want to make a generate id column in table which format is 'TR-091214-001' where,. Tr is define transaction. 091213 is define yymmdd. 001 is define increment number of transaction each day. We can make a simple logic and validation for that. Here the steps :. Step 1 create table. Tr id varchar(30) not null,. Step 2 generate id. Declare @gen id varchar(30). Set @gen id = (.
tt-programmer.blogspot.com
Tips And Tricks Programmer: Row Number Function in SQL 2005
http://tt-programmer.blogspot.com/2009/11/row-number-function-in-sql-2005.html
Tips And Tricks Programmer. Monday, November 16, 2009. Row Number Function in SQL 2005. A new function in sql server 2005. It's function returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition. ROW NUMBER OVER ( [] ). Create table Testing ( Kd varchar(10) not null, Name varchar(10) ). Insert into Testing values('K01','Siji'). Insert into Testing values('K02','Loro'). Insert into Testing values('K03','Telu'). Monday, November 16, 2009.
tt-programmer.blogspot.com
Tips And Tricks Programmer: Find Text In SQL Server
http://tt-programmer.blogspot.com/2009/07/find-text-in-sql-server.html
Tips And Tricks Programmer. Friday, July 3, 2009. Find Text In SQL Server. Sometimes we want to check where the certain text could appear on the store procedure or trigger. We made. Here is the query provide to maximize the searching :. Set @text = 'Wihemdra'. Select name from sys.objects. Where object id in. Select id from syscomments. Where text like '%' @text '%'. Friday, July 03, 2009. Subscribe to: Post Comments (Atom). Life Is A Mystery. Find Text In SQL Server. There was an error in this gadget.
aryommsi.blog.binusian.org
Knowledge Management di IBM @ aryommsi
http://aryommsi.blog.binusian.org/2010/01/05/knowledge-management-di-ibm
You Know Me, Therefore I Am. Knowledge Management di IBM. Posted on January 5th, 2010. Preview dari sebuah presentasi yang akan dibuat (atau sudah dibuat? Di konferensi KM APQC. Saya menyukai argumen yang diberikan dan bagaimana “permasalahan” nya dibuat, terutama diawal presentasi……. dan menurut saya konsep dari. Selalu menarik untuk disimak! Perhatikan screenshot di akhir PPT, disitu diperlihatkan bahwa e-learning tidak hanya memiliki video, teks, dan banyak hal lainnya yang terikat, yang menjadikannya.
aryommsi.blog.binusian.org
The Bumble Bee Story @ aryommsi
http://aryommsi.blog.binusian.org/2009/07/07/the-bumble-bee-story
You Know Me, Therefore I Am. The Bumble Bee Story. Posted on July 7th, 2009. Beberapa minggu yang lalu setelah selesai nonton Transformers 2, entah kenapa membuat saya ingin tau lebih banyak mengenai Bumblebee, yang merupakan salah satu karakter robot dalam film itu. Banyak hasil yang saya dapat setelah googling, Wikipedia. Berikut rangkuman hasil cerita yang saya dapat:. Untuk terbang seperti layaknya lebah pada umumnya. Tetapi ada celah di pembuktian ilmiah tersebut, Bumble Bee pun melakukan penerbanga...
aryommsi.blog.binusian.org
aryommsi
http://aryommsi.blog.binusian.org/page/2
You Know Me, Therefore I Am. Knowledge Management di IBM. Posted on January 5th, 2010. Preview dari sebuah presentasi yang akan dibuat (atau sudah dibuat? Di konferensi KM APQC. Saya menyukai argumen yang diberikan dan bagaimana “permasalahan” nya dibuat, terutama diawal presentasi……. dan menurut saya konsep dari. Selalu menarik untuk disimak! Perhatikan screenshot di akhir PPT, disitu diperlihatkan bahwa e-learning tidak hanya memiliki video, teks, dan banyak hal lainnya yang terikat, yang menjadikannya.
aryommsi.blog.binusian.org
Corporate cultures not conducive to knowledge sharing @ aryommsi
http://aryommsi.blog.binusian.org/2010/01/06/corporate-cultures-not-conducive-to-knowledge-sharing
You Know Me, Therefore I Am. Corporate cultures not conducive to knowledge sharing. Posted on January 6th, 2010. List of cultural traits that identify an organization where the corporate culture is not conducive to knowledge sharing and therefore creativity and innovation. 1 A strictly hierarchical top-down structure:. The you should not share knowledge outside your department without your manager’s approval syndrome. 2 Focus on short-term objectives:. 5 Lack of trust:. 9 Too much Pride:. The we fear tha...
tt-programmer.blogspot.com
Tips And Tricks Programmer: Generate System Column ID based on Format Required in SQL
http://tt-programmer.blogspot.com/2009/12/generate-system-column-id-based-on.html
Tips And Tricks Programmer. Sunday, December 13, 2009. Generate System Column ID based on Format Required in SQL. If we want to make a generate id column in table which format is 'TR-091214-001' where,. Tr is define transaction. 091213 is define yymmdd. 001 is define increment number of transaction each day. We can make a simple logic and validation for that. Here the steps :. Step 1 create table. Tr id varchar(30) not null,. Step 2 generate id. Declare @gen id varchar(30). Set @gen id = (.
hnindito.wordpress.com
Database Corruption | Hnindito's Weblog
https://hnindito.wordpress.com/2010/01/09/database-corruption
Just another WordPress.com weblog. Januari 9, 2010. Apa yang menyebabkan Block Corruption? Anda dapat memperbaiki suatu block media yang corrupt menggunakan recover block atau menghapus object database yang berisi block corrupt, atau kedua-duanya. Jika media corruption berarti berkaitan dengan hardware yang cacat, Masalah tidak akan sepenuhnya terpecahkan sampai hardware dikoreksi kesalahannya. Gejala Block Corruption : ORA-01578. Dihasilkan ketika suatu Block data corrupted ditemukan. DBVERIFY adalah su...