hi there, i have a machine installed MS server 2008 and in that it has MS SQL express , how can i connect othe MS SQL express from another PC in the network what is the toll that i need to have appriciate a lot thanxxxx

Member Avatar
+0 forum 0

Hi there, How can I write a stored procedure to select a value from a table and return that value?? I have a table Employee, when I send the email as a parameter to the stored procedure, I should get the employee number (it should return the employee number) I am trying to execute the stored procedure in C# code. I wrote a code but not sure about this and it is wrong how can I fix it [ICODE] CREATE PROCEDURE dbo.getEmpID declare @empid int AS BEGIN /* SET NOCOUNT ON */ Select @empid From Employee Where Email=@empid END[/ICODE] appriciate …

Member Avatar
Member Avatar
+0 forum 8

Hello to all, I am always mad about this problem. If I type a name with two words in a textbox like "google corporation" it will be registered in the database ms access as "Google Corporation" now that is okay. What I want is, there should be no duplicate of names, but the problem is, when I enter "google corporation" it will be registered again in the database instead of displaying "No duplicate". This is my code: [CODE]Private Sub Command1_Click() Dim rst As New ADODB.Recordset Dim i As Integer Dim R_Count As Currency With rst .ActiveConnection = con .CursorLocation = …

Member Avatar
Member Avatar
+0 forum 5

I want to buy MS Office 2007 or 2010 Professional and I can find it on Ebay at an average price of $175 US. I am wondering if there is some reason I am not aware of to not buy any of these programs. What do I need to know to make an informed decision?

Member Avatar
Member Avatar
+0 forum 3

For our homework in our Computer science class, we were tasked to research by asking expert advice on database forums. We were first asked to download Census data to be analyzed using Microsoft Access. The data contained facts about 1% all people living in large US Cities at the time on the last US Census in the year 2000. The file gave the name of the city and the racial/ethnic ancestry of the person concerned. I was able to achieve the objectives of the first task by illustrating the ff terms: fields, records, key fields, primary keys, foreign keys, relationship, …

Member Avatar
+0 forum 0

I have recently made a database in MS Access that has a user-friendly GUI. Can someone please tell me how I can hide the Host Application [MS Access] so that when I run my database, the GUI gives the illusion that the database that I created is a stand alone program? Also, is there any difference in how to accomplish this in Access 2003 and Access 2007? Unfortunately, I have to use both versions on multiple terminals where the database is stored on a shared network drive.

Member Avatar
Member Avatar
+0 forum 1

So, I've been trying to get a page to update items in an MS SQL database forever now, trying different methods here and there having nothing working. I finally got one method to work using a datagrid thing, and it's fine for the test table I'm using. But when it comes to the main tables, I want all of the columns to be editable and there are a ton of items, and a bunch of columns, so it's just a lot to display on one page. I got it so that I just pull one item at a time into …

Member Avatar
+0 forum 0

Already image path is being is stored in database... I want to retrieve it and want to display images in asp pages(IF I CLICK A HYPERLINK OR BUTTON IMAGE SHOULD BE DISPLAYED) ... Plz help with sample code. Regards Jose

Member Avatar
-1 forum 0

I am developing a website in ASP.net 3.5 where there is a very big database. I have to show data on one single page dynamically changing from the database and that database will contain data of about 4000 pages having text and images. With formatting tags and lot of tags, its size become huge, So please suggest which database i should use, MS SQL or XML, I don't have any problem ob database size and web space. i have to choose the fastest one, Due to such a big database, XML data file will also becomes very big, i can't …

Member Avatar
Member Avatar
+0 forum 1

how can i save the path of the picture i've browsed. i'm using vb.net as my front-end and ms access as my back-end. thanks in advance :)

Member Avatar
Member Avatar
+0 forum 2

I have a database, which keeps track of peoples training dates, they have to complete the training yearly. I can run reports to see who is overdue, or comming due in 60 days. I would like to be able to run a report like this, however, I would like it to have a spot to click next to the users information, so I could email him/her, using the email address for that person, and in the email I would like to have text already typed in. I would like the text already typed in the email to use the date …

Member Avatar
+0 forum 0

I was wondering if it was possible to this: example [CODE] if exists(Select * From table) select item from table set returnValue = 1 Else set returnValue = 0 [/CODE] Or if there any other way of doing this this

Member Avatar
Member Avatar
+0 forum 3

I get the following message when executing a stored procedure. [COLOR="Red"]The query has exceeded the maximum number of result sets that can be displayed in the results grid. Only the first 100 result sets are displayed in the grid.[/COLOR] However , i cannot change the fact that the SP uses a cursor. Basically what happens is that the SP executes into a declared table, and then for each row it executes a new stored procedure bringing the number of result sets to about 20 000.... Any advice on where i can change this setting ? Regards,

Member Avatar
+0 forum 0

Hi guys, I have a question, but first I'll explain my scenario. So I've got this datagridview where I use it as a look up for a certain table in Ms Access and I want to update just 1 field in that table. My question now is that, [B]can I update a field in my Table in Ms Access using a datagridview? [/B] Regards, Alphard

Member Avatar
Member Avatar
+0 forum 1

i am using SSRS 2005. In my dataset there are some blank rows and in SSRS is showing blank rows. Is there a way that i just show rows with data and ignore blank rows. i set the visibility property but it is showing blank line. dataset: a b c blank d blank blank e i want output like: a b c d e Thanks

Member Avatar
Member Avatar
+0 forum 2

The End.