I trying to save employee image in employee database. I have three field in database table empid, empname, empimage. Here is my database part.
Suppose I\'m using transactional replication to replicate articles from one server to another (both running SQL Server 2000). This is setup and working great.
I have 3 tables - Items, Props, Items_To_Props i need to return all items that match all properties that i send
I have table column filled with开发者_JAVA百科 float values e.g.: id-Values 1- 0.19230769230769232
work on Sql server 2000. i want to get the current server date and time then want to compare it with my table column EntryDate .How to?
work on SQL Server 2000. want to Automated Email Notifications using SQL Server Job Schedular.If i run the bellow cursor syntax in query analyzer than i get no error .But when i set this syntax on Sql
I\'m usingCF8 and SQL2000.I\'m sto开发者_运维技巧ring a bunch of HTML in a Text field in my SQL table.When I do a simple CFQUERY against that data, and CFDUMP it, it\'s truncated to 64000 characters.
Now, I am using Ms sql server 2000 and I want to store my data as the unicode for chinese fon开发者_运维问答t. But I don\'t know it can store this type or not? If not, could anybody guide me?
When using SetFirstResult(start) and SetMaxResults(count) methods to implement paging I\'ve noticed that the generated query only does a select top count * from some_table and it does not take the sta
I am rebuilding indexes using a script which reorganises or rebuilds indexes according to a predefined fill f开发者_如何转开发actor.
加载中,请稍侯......