I installed SQL Server 2005 Express edition on my system. I am using Windows 7 (64 Bit) OS. While installing it said compatibility issues. Though, it got installed and showed successfully installed. But, only the configuration tools were installed. Also, how to create a database or how can I use it. Thanks Vinaychalluru ...
I have a c# winform application that uses SQL 2005 Express. The application is typically deployed on home computers and laptops. The user can purchase more content for their database from my web server. When they do this, I want to let the user update their database by running an SQL script stored on my web server; however, I want t...
Hello all, I just finished installing the SQL Server 2005 Developer Edition on Windows 7. Here is the question, when I first load SQL Server Management Studio, what is the server name I have to use? Server Type: Database Engine Server Name: Authentication: Windows Authentication Username: Linda-HP\Linda So what server name should I u...
Hi experts, I am trying automatically increment the alpha numeric field (say for productid in product table). But I am getting an error (see below). Could somebody please look into this error or any other approach to achieve this task? My table details: create table tblProduct ( id varchar(15) ) create procedure spInsertInProduct AS...
i am Developing a Pharmacy Management Project and Every Medicine has it's own bar code so i want to read this barcode when i insert this medicine in the DB or to generate bar code if the medicine does not has a bar code and to read it will the Sales man sale it , so i want to know how to read and how to generate a bar code using a bar co...
Hello! Here is my situation: 1) User A must monitor the results of an sql query Q. 2) User B can modify data that may change the results of Q 3) running Q on the entire database is slow What I would like have is: whenever user B modifies the data: with a create, update or delete, then generate the delta to the results of Q. i.e. retur...
How to select value from a table if it value is not null,and select a default value if not?.I.E: select coalesce(username,'its null') from tb_user where int_id_user = 0 I try to run this query but its not working,i expect to get 'its null' since int_id_user is 0,but it returns NULL. ...
Here's a very easy question for someone :) Trying to update an SQL column with the following: UPDATE [NameOfTable] SET [HtmlContent] = 'a href="/sell-your-boat/"' WHERE HtmlID = 123456 But am getting the following error message: Incorrect syntax near '/'. I know it's because I need to escape the / character but hitting my ...