Here is a table patients in MS access database, There is 20 records, I want to select first 0 10 records and after 11-20 records for pagination. How to solve this problem
I'm a consultant, helping a provider of small medical practice management software move to the web. We're looking for a host that has experience with HIPAA-compliance, and supports the MS Web stack (IIS / .net / SQL Server)
Can anyone here provide a recommendation of such a hosting company?
Thanks,
Andrew
I've been handed a rather large, old, and crusty Access 2000/2003 database to clean up. I'll need to rename a number of tables and fields, but need to do so in a way that doesn't break existing queries. (Fortunately, there are no macros, forms, or reports to worry about.)
I've heard there are some commercial tools to make this job easier, but only found one (http://www.rickworld.com/products.html).
Can anyone recommend this software, or any alternatives?
In my project, I want to build Windows mobile application into installation files automatically without human click on MS.
How can I achieve it? Please help me! Thanks!
I need to make DISTRIBUTED TRANSACTION between two MS SQL Server 2005,
it drops an error that NO ACTIVE TRANSACTION IS PRESENT or smth like this.
DTCTESTER programs drops an error that transaction could not be done.
btw 135 port is open on the firewall.
Maybe anyone knows what a problem, or have a suggestion?
What's a good SQL client for Mac OS X that works with MS SQL Server? I don't really need a GUI, but it's nice to have for the color coding and resultset grid.
Hello Guys!
I've two MS SQL tables: Category, Question. Each Question is assigned to exactly one Category. One Category may have many subcategories.
Category
Id : bigint (PK)
Name : nvarchar(255)
AcceptQuestions : bit
IdParent : bigint (FK)
Question
Id : bigint (PK)
Title : nvarchar(255)
...
IdCategory : bigint (FK)
How do I recursively count all Questions for a given Category (including questions in subcategories). I've tried it already based on several tutorials but still can't figure it out :(
I need to convert a number which gives decimals in factored format in to decimals,
i.e. 11.16 is 11.5 in decimal. This is because 16 is in base of 32 and 11.16 should be read as 11+16/32 = 11.5
I get 11.16 as a string and I need to change it to 11.5 as numeric in MS SQL(2005) database.
Any shorter way of doing this rather than splitting strings,converting to numerics,maths,convert to string, concatenate and then convert to numeric?
Are there any tools available for converting a desktop vista machine into a virtual machine to run with MS Virtual PC? I am buying a new workstation and would like to virtualize my old machine onto the new one. I know of the tools for Hyper-V, but i'll be running Win7 on the new machine, not Hyper-V server.
I have a MS SQL 2008 database in 3NF.
I must check if the db can support many concurent users.
Which is the best method ?
[Is there any free tool to do this ?]
Thank you very much.
We're using the MS Chart for .net, but encountering the "image not found" problem for which there doesn't seem to be a solution.
Are there any alternatives for generating simple charts?
Hi,
Can some one please guide me to understand which jar file i need to include in my application to be able to set up a jdbc connection with ms sql server.
thanks in advance.
I have a text file sitting on client machine and want to move it to the database server (MS SQL 2008) but I don't have any access to the server except MSSQL client. Can I transfer this file to the server using SQL client connection?
Hai frnd can give me some solution..
1.how to open ms word document without using com(word.application)
2.actually i want to edit existing document only changing content without affecting any properties?
Does MS have a sample enterprise application that demonstrates the use of different Enterprise library blocks (Logging, Dataaccess, Exception, Validation etc)?
I am looking for something that uses best practices in using and integrating all these blocks in a single application.
Not a technical question, but related to IT.
At the moment I work in the open plan office and the guy next to me is talking to himself
while programming. It annoys my collegue and me so much that we are putting the earphones on with music volume set to max.
Does anyone know good and polite solution to shut him up?
Hi,
I have a MS SQL query that is selecting a field and it is being chopped off for some reason it is cutting off text at 257 characters.
Is there some kind of default cut-off for retrieving results with MSSQL and PHP?
I'm honestly clueless as to why this is happening. ANY guidance would be greatly appreciated
I am developing a vb.net application in SQL server 2005 ,now i would like to import MS access database tables from a network into sql server 2005 database, using stored procedure or vb.net code without using SQL server 2005 Wizard . please find a sollution thanks a lot.
I've been asked to convert several hundred MS Word 2002 Templates (on the PC) to work on the Macintosh. I have to evaluate whether the Word Templates can be run in iWork Pages and Microsoft Word for the Mac. The biggest issues that I've found thus far are that I'm unable to convert the following -
Macros
WordBasic code
Visual Basic
Has anyone here ever done this before and can provide any suggestions?
I have a .sql file from a MySQL dump containing tables definitions and the data to be inserted in this tables. How can I convert this database represented in the dump file into a MS SQL server database?