Comments by dineshvishe

dineshvishe 3-Jun-13 1:37am View

I am doing For MSSQL Sending mail.Getting error .Any Solution.

dineshvishe 21-Jan-13 12:28pm View

Test database is there which having 10 users.if i want add same database. how to resource planning for it?

dineshvishe 19-Sep-12 23:23pm View

It is not working.Please gfuide me...

dineshvishe 14-Sep-12 0:36am View

alteast i want changes rows..

dineshvishe 14-Sep-12 0:30am View

Deleted

SELECT T1.*
FROM
(
SELECT *, CAST(BINARY_CHECKSUM(*) AS BIGINT) AS BCHECKSUM
FROM tablea
--WHERE ID IN(.,.,..) -- To be used in subsequent iteration
)AS T1
LEFT OUTER JOIN
(
SELECT i, CAST(BINARY_CHECKSUM(*) AS BIGINT) AS BCHECKSUM
FROM tablec
--WHERE ID IN(.,.,..) -- To be used in subsequent iteration
)AS T2
ON T1.i= T2.i
WHERE T1.BCHECKSUM <> T2.BCHECKSUM

try this but no changes...

dineshvishe 14-Sep-12 0:29am View

Deleted

CREATE TABLE [dbo].[tablea](
[i] [int] NULL
) ON [PRIMARY]

data-11,11,11,11,11

CREATE TABLE [dbo].[tablec](
[i] [int] NULL
) ON [PRIMARY]

data-11,11,11,11,12

SELECT T1.*
FROM
(
SELECT *, CAST(BINARY_CHECKSUM(*) AS BIGINT) AS BCHECKSUM
FROM tablea
--WHERE ID IN(.,.,..) -- To be used in subsequent iteration
)AS T1
LEFT OUTER JOIN
(
SELECT i, CAST(BINARY_CHECKSUM(*) AS BIGINT) AS BCHECKSUM
FROM tablec
--WHERE ID IN(.,.,..) -- To be used in subsequent iteration
)AS T2
ON T1.BCHECKSUM= T2.BCHECKSUM
WHERE T1.BCHECKSUM <> T2.BCHECKSUM

Last Bit is changes but it not showing anything .Please check and reply.

dineshvishe 30-Apr-12 1:22am View

select SELECT convert(nchar(50),date_value,103) as date_value1 from emp

dineshvishe 30-Apr-12 1:20am View

select DATEADD(DD, -2, GETDATE()),112) from can what mean this query ????

Comments by dineshvishe (Top 8 by date)