Hi, Currently, my database logical view as follow 1. ERP database server on 192.168.1.2 2. WMS database server on 192.168.1.3 3. TMS database server...
tq sir
Hi, My current system as follow 1. Windows 2003 Server Enterprise Edition 32 bit 2. SQL Server 2005 Enterprise Edition 32 bit 3. Strengthen by RAID 5...
Processor: Intel® Xeon® processor 5000 sequence Memory: 12GB
Currently my infra, OS and database as follow 1. RAID 5 2. Windows Server 2003 Enterprise Edition 3. SQL Server 2005 Enterprise Edition 64 bit At...
Let's say, my xml data as follow, <data> <cout><short>kl</short></cout> <cout><short>jb</short></cout> <cout><short>sg</short></cout> </data> I...
hi sir, i found the solution [:D]
/*1st, me create as follow*/ create type Date from dateTime create type Time from dateTime /*2nd, me create as follow*/ create rule DateOnlyRule as...
tq very much sir ...[:D]
--My table as follow, CREATE TABLE DERPosi_201001 ( [TID] int not null, [SeatN] [numeric](15, 0) NOT NULL, [Posi] [varchar](30) NOT NULL, [recGrp]...
From my SQL statement, declare @tEmployee table ( TrnxID int primary key identity(1,1), Nme varchar(100), RowID rowversion ) insert into...
Did anyone using trigger will burden the performance? Is that true or only mith?
Let's say, My table structure and data sample as follow, ************************************************** declare @tPosiHdr TABLE ( TID int not...
I've following table and data tblSEL Date_Taken | Time | Main_ID | Value ----------------------------------------------- 5/11/2008...
Still got error, Server: Msg 170, Level 15, State 1, Line 6 Line 6: Incorrect syntax near 'TABLE3'. there's no TABLES3
from DCC t1 join (Select Count(1) LOGON_TYPE_COUNT ,Callsign From LOGON_TYPE Group by LOGON_TYPE )t2on t1.Callsign = t2.CallsignTABLE3 t3on...
This query give an error. Can u help me to debug the error?
Hi, I've these following table. This table containing million of rows. The sample of table and data shown as follow:- DCC DCC_ID| Description| CCC...
Separate names with a comma.
