Use this tag for questions specific to the 6.5 version of Microsoft's SQL Server.
Questions tagged [sql-server-6.5]
3 questions
5
votes
2 answers
Select TOP 1 in SQL Server 6.5
I beg you don't ask me why am I using SQL Server 6.5
There is no SELECT TOP command in SQL Server 6.5, and guess what, I need it :)
I need to perform something like
Select top 1 * from persons
where name ='Mike'
order by id desc
I've tried…
100r
- 1,099
- 1
- 12
- 24
1
vote
1 answer
SQL Server 6.5 deadlocks with Spanish letters ú and ü
We're running SQL 6.5 though ADO and we have the oddest problem.
This sentence will start generating deadlocks
insert clinical_notes ( NOTE_ID, CLIENT, MBR_ID, EPISODE, NOTE_DATE_TIME,
NOTE_TEXT, DEI, CARE_MGR, RELATED_EVT_ID, SERIES, EAP_CASE,…
Aaron
- 85
- 1
- 4
0
votes
1 answer
High Order ASCII chars in MS SQL 6.5 INSERT using ADO
I've searched all about and can't find an answer to this.
I have an SQL statement similar to
insert myTable VALUES ( 'Value1', 'Value2', 'Value 3²More', 'Value 4√Even More' )
where the square char (between the 3 and the More) is 0xFD and the square…
Aaron
- 85
- 1
- 4