Intresting Problem
Aug 7, 1998
Hello,
(sorry for my english)
I am using ADO.
I am having problem with AppendChunk and Image Field.
When ever I use AppendChunk to update an IMAGE field it stores double of the
size of value.
I mean when I use AppendChunk "ABC" on an image field it stores 6 (SIX )
bytes instead of 3 (THREE) bytes.
But when I use the same on TEXT field it work fine.
Please help me ... I want to store a .WAV file into image field
best regards
Iftikhar
View 1 Replies
Nov 2, 2000
Hi Everyone...
I cannot see the all the objects related in SQL SERVER Performance Monitor on one of our SQL SERVER..
The thing is before couple of days when i checked i was able to see all the object of sqlserver in performance monitor..
But for some reason I cant see it now..I am able to see only related to operation system..
Can anyone help me out.. to get back the sql server object in performance monitor..
Help is greatly appericated..
Thanks indeed
jessi..
View 2 Replies
View Related
Mar 15, 2008
I am writting a query to retrive some information about a person from the database, now intresting thing is that the query does'nt find the person who dont have a Last name in the database. i pass on the values which user have entered, the values are FirstName, LastName and EmployID, what ever information is given, its passed to the query and the person should be retrived if the person is logged in but problem is that the query works only if the person have a LastName in the database... this is my query.. please tell me what is wrong and what should i change.... its Urgent guys
SELECT distinct top 22 cfg_person.*,cfg_place.name,login_info.callablenumber,login_info_server.server
FROM cfg_person,cfg_login_info,cfg_agent_login,cfg_switch,login_info,cfg_place, login_info_server
where cfg_person.state='1'
and (cfg_switch.type = 5)
and cfg_person.is_agent=2
and cfg_person.first_name like 'Monique%'
and cfg_person.last_name like '%'
and cfg_person.employee_id like '%'
and cfg_person.dbid=cfg_login_info.person_dbid
and cfg_login_info.agent_login_dbid = cfg_agent_login.dbid
and cfg_agent_login.switch_dbid = cfg_switch.dbid
and login_info.person_dbid = cfg_person.dbid
and login_info.logged_voice=1
and cfg_place.dbid = login_info.place_dbid
and login_info.server_id = login_info_server.id
order by cfg_person.first_name
View 2 Replies
View Related