I'm new to database programming. I'm currently reading Pro ADO.NET 2.0 from Apress. The book has been great so far, but when he get's to his first example, he supplies a script file to set up a simple data source. So, i have this .sql file that i don't know what to do with. when I double click it, it just opens in notepad. Yes, i'm a doofus. please help me!
I'm running a local instance of sql server 2005 standard.
The system already has a default instance of MSDE2000 installed. I would liket to upgrade this to a default instance of SQL server 2000. Is this possible without uninstalling the MSDE? The SQL installation asks me for an instance name and disables the default instance (since it already exists in MSDE)??
I'm using update trigger for inserting a record in a table(say table2) when the value of certain column(Column2) is changed in table1. My code executes UPDATE query on table1 everytime when any column is updated.
My SP is something like
UPDATE table1 SET Column1 = @Column1, Column2 = @Column2
WHERE ID = @ID
I have checked the following condition in Trigger
INSERT INTO table2...........
So even if Column1 is updated the INSERT query in trigger will be fired.
So the record is inserted into table2 everytime the update query is executed on table1, irrespective of which column has changed.
As far as I can see in you UPDATE statement, both Column1 and Column2 are updated, so Column2 is always updated. Even if you put back the same value in Column2, as far as SQL is concerned, it is updated.
"I say no to drugs, but they don't listen."
- Marilyn Manson
I am connecting to my SQL server from my windows application localy using either SQLConnection or ODBCConnection and they are working fine but when i try to connect to the server from another PC in the Lan i cannot connect through SQLConnection from my application.
but what have i tried is to connect using odbcConnection and ODBCComand and it connected normally.
What Do i need to setup in the client computer So it Can connect from the Windows Application Normally By using SQL Connection and SQLCommands?
Do I need to setup:
1- A new ODBC System DSN with a SQL Server Driver!!
2- SQL Service Manager (How Do I Get It)
3- Define a new DB user for Clients (I am using it with ODBC Already)
4- Connection string in my application (I am using "Data Source=jedfin-nb0077;Initial Catalog=inventory;User ID=sharifin")
5-In the FORM in QUERY ("SELECT Count(*) FROM [jedfin-nb0077].inventory.sharifin.inventory_item")
I'm trying to create a view from the Visual Studio Server Explorer. One table I want to include belongs to a different database. When creating a view it only allows you to pick tables and views from within the database your working in. How can I pick a table from a different database for my view?