Agus Wijiyanto

The style value can be one of the following values:

How many tables in database have column name like ‘doc_date’? It was quite an interesting question and I thought if there are scripts which can do this would be great. I quickly wrote down following script which will go return all the tables containing specific column along with their schema name.

Search GETDATE in All stored procedure and function SELECT DISTINCT o.name AS Object_Name, o.type_desc, LEFT (m.definition, 500 ) AS def FROM sys.sql_modules m INNER JOIN sys.objects o ON m.object_id = o.object_id WHERE m.definition LIKE '%GETDATE%' ESCAPE '\'

This SQL Server tutorial explains how to use the EXCEPT operator in SQL Server (Transact-SQL) with syntax and examples. Description The SQL Server (Transact-SQL) EXCEPT operator is used to return all rows in the first SELECT statement that are not returned by the second SELECT statement. Each SELECT statement will define a dataset. The EXCEPT operator will retrieve all records from the first dataset and then remove from the results all records from the second dataset.

NULLIF Returns a null value if the two specified expressions are equal. Syntax : NULLIF ( expression , expression ) Arguments : expression :Is any valid scalar expression. ISNULL Replaces NULL with the specified replacement value. Syntax : ISNULL ( check_expression , replacement_value ) Arguments : check_expression : Is the expression to be checked for NULL. check_expression can be of any type.

Kumpulan Kode Error eFaktur, Penyebab dan Solusi ETAX-10001 : Error Database Terjadi Kesalahan, tidak dapat membentuk header lampiran Penyebab : Posting SPT di database selain ETaxInvoice Solusi : ETAX-10001 : Error Database Penyebab : [1] File di dalam folder db ada yang corrupt atau hilang (misal : corrupt karena mengcopy data base saat aplikasi menyala) [2] Di dalam folder db tidak terdapat folder ETaxInvoice atau terdapat folder selain folder ETaxInvoice yang bukan tercreate dari proses tambah database [3] Versi aplikasi tidak sama dengan versi db [4] PC server PKP mati / Database belum distart sebagai server (dalam hal menggunakan konfigurasi network db)  

Download ZEOS 7.1.4 STABLE from  sourceforge.net In Windows : ZEOSDBO-7.1.4-stable.zip Copy to C:\lazarus and extract.

Introduction In this article, we are going to talk about using the nvarchar data type. We will explore how SQL Server stores this data type on the disk and how it is processed in the RAM. We will also examine how the size of nvarchar may affect performance.

PROCEDURE [System].[Flow.Execute]

Table Subcode Group

Flow Document

Keys Primary and Foreign Keys   Relationships One-to-Many and Many-to-Many Relationships

Stored Procedure Reset IdentitySeed Table,

A proper index can improve the performance and a bad index can hamper the performance. Here is the script from my script bank, which I use to identify missing indexes on any database. Tuning performance with Sql Server Profiler