Database Discussion Boards

Le centriste22-Feb-06 6:40

22-Feb-06 6:40

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

Re: UPDATE trigger problem

Adarsh Shah22-Feb-06 17:39

Adarsh Shah

22-Feb-06 17:39

Yes but how can I compare the previous and current values for Column2 in the trigger to know that it has changed.

Thanks for the reply Marilyn.

Regards,
Shah Adarsh.

Re: UPDATE trigger problem

Adarsh Shah22-Feb-06 21:59

Adarsh Shah

22-Feb-06 21:59

I got the answer Smile | :)

. deleted table contains the old record and the inserted table contains the newer one for update operation trigger.

Regards,
Shah Adarsh

Problem Connecting to MS SQL Server 2000 Over TCP/IP

cbhkenshin22-Feb-06 1:50

cbhkenshin

22-Feb-06 1:50

Hi:

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")

Please Help and Thanks in Advance.

Trim a sqlparameter in store procedure

Praveen_S21-Feb-06 18:49

Praveen_S

21-Feb-06 18:49

I have written a store procedure to insert a record which contains a parameter that contains loginname which is of type string. i want to trim this parameter in store procedure.

can any one help me in how to do this.

thnx.

Re: Trim a sqlparameter in store procedure

Jon Sagara21-Feb-06 18:51

Jon Sagara

21-Feb-06 18:51

LTRIM()[^]
RTRIM()[^]

SET @YourParam = LTRIM(RTRIM(@YourParam))

Jon Sagara
Look at him. He runs like a Welshman. Doesn't he run like a Welshman? Doesn't he? I think he runs like a Welshman.
Sagara.org | Blog | My Articles

Re: Trim a sqlparameter in store procedure (Solved)

Praveen_S21-Feb-06 19:02

Praveen_S

21-Feb-06 19:02

Thanks for the suggestions, Jon

I tried it and my problem got solved.

Praveen.

Getting Data From Two Databases

dptalt21-Feb-06 8:36

dptalt

21-Feb-06 8:36

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?

Thanks for any help on the matter.

Re: Getting Data From Two Databases

Mike Ellison21-Feb-06 9:14

Mike Ellison

21-Feb-06 9:14

Hi there. You can fully qualify each table with the syntax database.schema.table. For example, to fully qualify the Categories table in the Northwind database, you can use Northwind.dbo.Categories.

Re: Getting Data From Two Databases

dptalt21-Feb-06 9:24

dptalt

21-Feb-06 9:24

How do you do that within the Server Explorer? Thanks.

Re: Getting Data From Two Databases

Mike Ellison21-Feb-06 10:33

Mike Ellison

21-Feb-06 10:33

Does it work to make sure "Show SQL Pane" is turned on, then type in the fully qualified name in the sql itself?

Need help do connecting sql server together in local area network!

ah Chung21-Feb-06 3:23

ah Chung

21-Feb-06 3:23

Anyone can teach me how to connect two or more pc sql server together in a local area network? Confused | :confused:

chung

Re: Need help do connecting sql server together in local area network!

japel21-Feb-06 13:17

japel

21-Feb-06 13:17

Please put a little more effort into your question and I will try to answer...

What type of connection?
What is the expected use?
Is the a fault tolerance question?

Most important, what have you tried???

When people make you see red, be thankful your not colour blind.

Re: Need help do connecting sql server together in local area network!

ah Chung22-Feb-06 3:29

ah Chung

22-Feb-06 3:29

Sorry, i m still new in sql server.And i also new to this forum.

i want to connect few pc sql server together so my system can run at few pc and share same database.

i have tried to do new sql server registration but it fail to connect other pc sql server. i use window authentication and then the other pc i try to connect together also use windows authentication.

chung

Re: Need help do connecting sql server together in local area network!

japel22-Feb-06 8:51

japel

22-Feb-06 8:51

I hope I undrstand what you are trying to do, you have several PC's that you want to connect to an SQL server.
You want to connect to them at an application layer not through code in a project.

Is that correct???

If you just want to connect to an SQL server at the application layer...

Create a DSN entry on "Data Source ODBC" and use the "sa" user to test connectivity.

Create a System DSN follow the wizard and then press "Test Connection" see if this works.

Check it is not XP SP2 or a firewall configuration that is stopping you, check the web there are several sites that can walk you through this.

http://support.microsoft.com/kb/841251/[^]

See how you go.

When people make you see red, be thankful your not colour blind.

How to storage the records of DataSet to MSSQL table?

jingya_feng21-Feb-06 3:07

jingya_feng

21-Feb-06 3:07

Hi,
The records of the DataSet were loaded from Web Service. I wanna save the records to MS SQL Server table. How can I do? I get a idea: Save the data to xml documents by WriteXml() method, and load the data from xml into SQL Server table. If I do like this , how can I load the xml's records into table? Thanks!

Re: How to storage the records of DataSet to MSSQL table?

Alomgir Miah22-Feb-06 7:34

Alomgir Miah

22-Feb-06 7:34

Are you looking for this

using System.Data.SqlClient;

public DataTable ReturnDataTbl(string XmlFile)
{
DataSet dset = new DataSet();

FileStream fstr = new FileStream(XmlFile, FileMode.Open, FileAccess.Read);
dset.readXml(fstr);

DataTable dtbl = dset.Tables[0];

fstr.Close();
dset.Dispose();

return dtbl;
}

Live Life King Size
Alomgir Miah

Replace SELECT result before datagrid.

japel21-Feb-06 1:20

japel

21-Feb-06 1:20

Hi I have the below sub the reads a single row table and populates the results in a data grid. Some of the fields have numerical values to represent settings.

E.G.

SecurityLevel
1

1 may be admin, so how to I replace the 1 with admin before I populate my datagrid?

Dim Command1 As SqlCommand = New SqlCommand("SELECT [Name], Type, SecurityLevel, Version, CreatedDateTime, Driver, CabinetType, NetworkAddress, LoginFlag, DomainName, AuthenticationType, WebServerAddress FROM dbtab")

Command1.CommandType = CommandType.Text
Command1.Connection = SQLConnection1
myDataSet = New DataSet("myDataSet")
SQLAdapter1.SelectCommand = Command1

SQLAdapter1.Fill(myDataSet, "Document")
DataGrid2.SetDataBinding(myDataSet, "Document")

About 4 of the Columns in the above select statment have values that I would like to replace bases on a lookup list.

OK BIG point I CAN NOT make an intermediate table Smile | :)

Any thoughts

When people make you see red, be thankful your not colour blind.

Re: Replace SELECT result before datagrid.

Michael Potter21-Feb-06 3:27

Michael Potter

21-Feb-06 3:27

Replace SecurityLevel in your Sql statement with a case statement structured as needed.

CASE 
    WHEN SecurityLevel = 1 THEN 'Administrator'
    WHEN SecurityLevel = 2 THEN 'Supervisior'
    ELSE 'User'
END As SecurityLevel,

Re: Replace SELECT result before datagrid.

Alomgir Miah22-Feb-06 7:38

Alomgir Miah

22-Feb-06 7:38

http://groups.google.com/group/microsoft.public.dotnet.framework.aspnet.webcontrols/browse_thread/thread/e3de64786d1684a2/be32e7aefcb96da6?lnk=st&q=DataGrid+display+custom+value&rnum=1&hl=en#be32e7aefcb96da6

Live Life King Size
Alomgir Miah

how to connect with Oracle with c#

nauty20-Feb-06 18:57

nauty

20-Feb-06 18:57

hi buddies
Can anyone help me to get connected with the Oracle 8i through c#. i am using asp.net1.1 and
1. not able to see the "OracleClient" namespace after the "system.Data ".How can i get it.
2. if I want to get connected through Oledb. how can i do that.
Thanks in advance.Please someone help me fast. its urgent.
bye

nauty

Re: how to connect with Oracle with c#

Colin Angus Mackay21-Feb-06 1:46

Colin Angus Mackay

21-Feb-06 1:46

nauty wrote:
1. not able to see the "OracleClient" namespace after the "system.Data ".How can i get it.

You need to add a refernece to System.Data.OracleClient to your assembly. (Right click on the project in the solution folder. Select Add Reference... and look in the .NET tab for it)

nauty wrote:
2. if I want to get connected through Oledb. how can i do that.

Use the classes in the System.Data.OleDb namespace.

ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?

Security: Scanning for SQL Server

devvvy20-Feb-06 17:24

devvvy

20-Feb-06 17:24

So, "osql -L" dumps a list of SQL in the same subnet. What if I want to hide this instance? Is moving it out of the subnet my only option?

Combining two SELECT statements

myNameIsRon20-Feb-06 13:00

myNameIsRon

20-Feb-06 13:00

Hi,
Is it possible to combine the two statements below into one?
I want the company name and suppleir's name to list together alphabetically, and not list at the bottom of the supplier's list of names.

"SELECT SupplierID, LastName + ', ' + FirstName AS NameOrCompany, IsLocal FROM Suppliers WHERE IsLocal=false ORDER BY LastName"

"SELECT SupplierID, Company AS NameOrCompany, IsLocal FROM Suppliers WHERE IsLocal=true ORDER BY Company"

Thanks,
Ron

-- modified at 19:01 Monday 20th February, 2006

Re: Combining two SELECT statements

Mike Ellison20-Feb-06 16:27

Mike Ellison

20-Feb-06 16:27

How about using a UNION statement for the two queries, then wrap them with an outer SELECT that performs the ordering?

SELECT SupplierID, NameOrCompany, IsLocal
  FROM
   (
    SELECT SupplierID
           , LastName + ', ' + FirstName AS NameOrCompany
           , IsLocal 
      FROM Suppliers 
     WHERE IsLocal=false
    UNION ALL
    SELECT SupplierID
           , Company AS NameOrCompany
           , IsLocal 
      FROM Suppliers 
     WHERE IsLocal=true
    ) x
 ORDER BY NameOrCompany

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.