Gazareth (4/11/2012)

---

Could Logon triggers be used?

Get them to write to an auditing table and then query that for the information you require?

As Lowell says though, after the initial login event...

The logon event only occurs once;there no lo...

caramelkaps (4/10/2012)

---

currently im not trying to insert into Oracle.In oracle for insertion I have the column as Timestamp(9).

Currently Im just trying to select from Sql server via Oracle. and I...

caramelkaps (4/10/2012)

---

Thanks...the example u provided works in oracle.

But when i try to exceute this query to get values from sql server table it fails and gives an error date...

i use SSMS tools to always use a template that looks like this:

SET XACT_ABORT ON

BEGIN TRAN

--do stuff like the insert

--check your row counts

--highlight and execute one of the two...

milliseconds requires systimestamp, and ss is seconds no matter how many times you repeat it in a string...it's a format mask. you mean to use something like FF2, FF3, FF6...

i'm guessing it's a truncation issue with a field cast to varchar.

if your driver is older, it might not support xml or varchar(max), and is casting the string you said...

are you using the Oracle TO_DATE() function to convert the data?

what is your string format for the conversion?

edit

jsut read you need to use TO_TIMESTAMP() in oracle to get fractions of...

hbtkp (4/10/2012)

---

i am getting result like

item1 item2 item3

1 pen 34

1 pen...

well, after correcting the extra parenthesis in your example, i'm not seeing the specific issue why it might overflow;

possibly the table has a huge number of rows?

the field "filed" is...

That is one of the other factors for this: a different solution is required to do...

thinking along the same lines as calvo...i think the issue is outside of SQL server:

could the password have expired for the local/domain user that is used to run the SQL...

it's not that difficult to do, but you need a Tally Table to do it.

try this and you'll see it's generating the values as requested, but you'll wnat to test...

Last used information is not really stored anywhere; but you can infer the lastused, since the last time the SQL Server Service was Restarted, based on sys stats for index...

something like this seems to work, using the Case Statement logic Jaren mentioned:

with mySampleData (id,addr1,addr2,addr3)

AS

(

SELECT'1','123',NULL,'Main St.' UNION ALL

SELECT'2',NULL,NULL,NULL UNION ALL

SELECT'3',NULL,'345','Elm St.' UNION ALL

SELECT'4','678','Apt 4','Winding Rd.' UNION ALL

SELECT'5','910','Rodeo Dr.',NULL UNION...