Kita bisa mempublishnya melalui GetJar. Langkah pertama tentu kita buat account dahulu di sini, masukkan data sesuai dengan form yang disediakan. Setelah selesai prosesi registrasi, kita bisa langsung upload produk kita. Produk yang diupload bisa disetting free ataupun berbayar dll. Selamat mencoba

the Size property has an invalid size of 0

Misal Stored Procedure pada database :

CREATE PROCEDURE [sp_coba]
@COBA_ID NVARCHAR(160) OUTPUT
AS
BEGIN
SET @COBA_ID=’11′;
END

Contoh penggunaan pada VB .Net :

Using sqlCMD as new SqlCommand(“sp_coba”,[sqlconnection]) whit {.CommandType = CommandType.StoredProcedure}

sqlCMD.Parameters.Add(“@coba_id”, SqlDbType.NVarChar, 160)
sqlCMD.Parameters(“@coba_id”).Direction = ParameterDirection.Output
sqlCMD.ExecuteNonQuery()
sParamOut = sqlCMD.Parameters(“@coba_id”).Value

End Using

parameter output disimpan pada variable sParamOut.

Store procedure yang digunakan adalah “sp_executesql”. Untuk menjalakan sama seperti store procedure lainnya membutuhkan parameter dgn format sederhana:

exec sp_executesql [perintah sql]

Atau juga perintah sql tersebut bisa ditaruh di variable:

declare @ssql nvarchar(max)

set @ssql=N’select * from ttable’

exec sp_executesql @ssql

Masalah yang bisa muncul adalah ketika ingin menambahkan kriteria untuk filtering. Misalnya akan menambahkan filter berupa string, sedangkan query sendiri berupa string. Hal ini bisa diakali dengan 2 cara :

1. Dengan setting “quoted_identifier” OFF (untuk mengenalkan “double quote”) atau ON (tidak menggunakan “double quote”)

set quoted_identifier OFF

Declare @ssql nvarchar(max)

set @ssql=’select * from ttable where tcolumn=”filter”‘

exec sp_executesql @ssql

isi dari @ssql adalah

select * from ttable where tcolumn=”filter”

karena quote identifier disetting off, maka perintah diatas tidak akan error, tetapi jika diganti

set quoted_identifier OFF

maka perintah tersebut akan error.

2. Menambahkan “single quote” sebanyak 2x sebagai pengganti “double quote” (yang mengapit string value)

Declare @ssql nvarchar(max)

set @ssql=’select * from ttable where tcolumn=”filter”’

exec sp_executesql @ssql

String value “filter” diapit oleh “single quote” sebanyak 2x (bukan double quote), isi dari variable @ssql adalah

select * from ttable where tcolumn=’filter’

Take control of your projects, source code, web pages and other files with ProjectDiff. Use it to compare, understand and combine different project versions and file versions.

ProjectDiff is an advanced project comparison and synchronization, folder comparison and synchronization, file comparison and merging utility for windows.

Take control of your projects, source code, web pages and other files with ProjectDiff. Use it to compare, understand and combine different project versions and file versions.

General Features

• Highlights differences with different colors
• Easy navigation by differences
• Prints and print previews comparison reports
• Generates comparison reports in HTML
• Drag and drop files and folders support
• Swap panes, Toggle splitter orientation (horizontal or vertical)
• Customize fonts and colors
• Windows shell extension support
  

Compare and Synchronize Projects

• Supports most popular projects:
  • Microsoft Visual Studio Solution/Project:
    *.sln | *.csproj | *.vcproj | *.vbproj | *.vjsproj
  • Microsoft Visual C++ Workspace/Project:
    *.dsw | *.dsp | *.mak
  • Microsoft eMbedded Visual C++ Workspace/Project:
    *.vcw | *.vcp
  • Microsoft Visual Basic Project:
    *.vbp | *.vbg | *.mak
  • Microsoft Visual J++ Project:
    *.vjp
  • Borland Delphi Project:
    *.dpr | *.bpg | *.dpk
  • Borland C++Builder Project:
    *.bpr | *.bpg | *.bpk
• Comparison methods:
  • Last modified date/time
  • File size
  • File attributes
  • Versions
  • CRC
  • Compare as binary (byte-by-byte)
  • Compare as text
• Quick merge mode (F9)
• Fully customizable file extension filters
• Starting file comparison with a simple double-click
• Synchronizing commands: copying, changing timestamps, changing attributes, etc
• Automatic re-synchronization after file operating
• Sorting folders by name, time, size, or last modification time without losing synchronization
• Selection filters
• Excluding of individual files and folders from comparison view

Compare and Synchronize Folders

• Comparison methods:
  • File last modified date/time
  • File size
  • File attributes
  • File version
  • CRC
  • Compare contents as binary (byte-by-byte)
  • Compare contents as text
• Quick merge mode (F9)
• Fully customizable file extension filters
• Starting file comparison with a simple double-click
• Synchronizing commands: copying, moving, deleting, renaming, changing timestamps, changing attributes, creating new folder, etc
• Automatic re-synchronization after file operating
• Sorting folders by name, time, size, or last modification time without losing synchronization
• Selection filters
• Excluding of individual files and folders from comparison view

Compare and Merge Text Files

• Comparison rules:
  • Ignore differences in whitespace
  • Ignore differences in whitespace amount
  • Ignore differences in tab expansion
  • Ignore differences in leading whitespace
  • Ignore differences in trailing whitespace
  • Ignore differences in blank lines
  • Ignore differences in comments
  • Ignore differences in character case
  • Ignore differences in line ending characters
  • Ignore lines matching specified regular expression
• Quick merge mode (F9)
• Char-by-char comparison, highlights differences within lines
• Navigation by differences within lines
• Selects line different section in current line
• Merging differences and line differences
• Editing within the interface
• Automatically detects changes and recompares
• Fully functional text editor
  • Highlights syntax
  • MBCS and Unicode support
  • Drag and drop text editing
  • Unlimited undo
  • Block indent/unindent
  • Search and replace (with regular expression support)
  • Word wrapping
  • Bookmarks
• Watching for changes outside ProjectDiff and reload the file if required

Compare and Merge Binary Files

• Byte-by-Byte comparison
• Merging differences
• Fully functional hex editor
  • Highlights different type bytes
  • Unlimited undo
  • Drag and drop editing
  • Bookmark

sumber : http://www.projectdiff.com/

Link Download : Link Trial Link Jamu

CREATE FILE encountered operating system error 5(failed to retrieve text for this error. Reason: 15105) while attempting to open or create the physical file ‘E:\xxx\db_xxx.mdf’. (Microsoft SQL Server, Error: 5123)

Kasus:

Terjadi error ketika attach database dengan user “sa” dan “windows authentication”.

Analisis:

Icon file database terlihat seperti terkunci. Hal ini kemungkinan file tersebut masih dilock oleh system. Setelah melakukan beberapa kali eksperimen, ternyata proses deattach dengan user aktif “windows authentication” (user aktif komputer) selalu mengalami kegagalan, meski dari pesan sukses, ternyata icon mengindikasikan proses tersebut gagal. Dan diperkuat lagi, ketika melakukan dengan attach dengan user berbeda terjadi error (seperti judul post ini). Awalnya gw curiga karena perbedaan owner database, karena owner database akan berubah sesuai dengan user aktif pada saat attach database tersebut (kecuali, settingan owner dirubah manual).

FIX:

1. Attach database yang error tersebut dengan user aktif  “windows authentication” (user aktif komputer).

2. Click kanan pada database yang bermasalah, pilih Task > Take Offline

3. Setelah sukses, lakukan deattach (Click kanan pada database yang bermasalah, pilih Task > Deattach)

4. Periksa file database, pastikan icon database tersebut bukan icon kunci.

5. Coba attach kembali database tersebut, jika masih error, coba remove terlebih dahulu file log dari database tersebut dan attach kembali.

Jika user aktif adalah “sa”, bisa dilakukan deattach langsung, tanpa perlu “Take Offline” terlebih dahulu. Waktu eksperimen si selalu sukses.