hi there,
I'm using MS Sql Server and I want to use identity constraint in it
I know how to use it in following manner
create table mytable
(
c1 int primary key identity(1,1);
)
the above code works fine but what if i want the identity column to have values as EMP001, EMP002,... instead of 1,2....
Thanks in advance,
Guru
I have VS2010, and I've opened up a web site. How can I now use MS Deploy to deploy to a zip file, which can be installed in a remote IIS site?
I've searched through all the menu options, but can't seem to find out where to get started.
Thanks in advance
Hello All,
I want to connect to MS SQl server 2005 using hibernate in java. i am unable to find the jars and the hibernate.cfg.xml file for the same. can someone help me with the same
Thanks in Advance
Regards,
Rima
I know there are third-party tools available but why must I go to another vendor for something as trivial as auto-formatting my SQL statements?
What prevents MS to provide a SQL formatting tool in SQL Server Management Studio? What's the catch?
And btw, is there a FREE tool available that would plug into SSMS?
How to convert doc to pdf using java api. where document contains various formats such as tables in ms word. when converting to pdf using iText. where actual document looks different to converted pdf. please provide any api not an exe installed for converting . must be an open source
Anyone know where I can get a copy of ESQL/C 2.10 which will work with INFORMIX-SQL 2.10.06E running on MS-DOS 5.0 or 6.22?.. I would also need to find Microsoft C compiler Version 6.
I have developed two MS Word macros and assigned each an icon. I have also added a custom toolbar, named after the project, and added the two macro icons to that toolbar. Now, how do I package the whole thing (macros, icons, and custom toolbar) to send it to my customer?
Is there any message forum/board software (open source or commercial) that allows one to post a question from MS Outlook? I read Kubi Software Inc had this feature. However, a google search for their website seems like the company is no more.
Thanks,
We've started looking at getting MS certifications at my job, trying to get a more even level of skill and knowledge in our teams.
So I'm left wondering if there is any "roadmap" or guide from Microsoft that you can look at/follow to know what certifications are applicable to your organization, what the contain, cost, etc. ?
I have a paper submission in about 12 hours. I have written references in a separate .bib file in bibtex format. Now please tell how to merge the references with my paper written in MS word in the simplest/ easiest possible manner. I am looking for some automatic tool that does this.
I have never used bibtex before. In fact I came to know about bibtex few hours ago only.
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
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
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 have a paper submission in about 12 hours. I have written references in a separate .bib file in bibtex format. Now please tell how to merge the references with my paper written in MS word in the simplest/ easiest possible manner. I am looking for some automatic tool that does this.
I have never used bibtex before. In fact I came to know about bibtex few hours ago only.
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.
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?
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.
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.
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 :(
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?
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?