Database

logical sum in ms sql2005

9-Mar-08 9:59

The logical table deleted contains the data for the row(s) you are deleting. Write an INSERT INTO query that takes the rows in this table and inserts them into your history table.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Re: trigger after delete

haytham_mohammad9-Mar-08 10:03

haytham_mohammad

9-Mar-08 10:03

thank you very much for this help

haitham

Seishin#9-Mar-08 3:30

Seishin#

9-Mar-08 3:30

Hi!
is it possible to get a logical sum on two integers in sql??

thanks for any help

life is study!!!

Re: logical sum in ms sql2005

Seishin#9-Mar-08 3:39

Seishin#

9-Mar-08 3:39

never mind that..
fyi, you just do it like in c and others Big Grin | :-D

life is study!!!

DSN

simworld9-Mar-08 3:07

simworld

9-Mar-08 3:07

How to connect Crystal Report with DSN using C# Code?

CrystalReportViewer1.ReportSource=Server.MapPath("CrystalReport1.rpt");
CrystalReportViewer1.LogOnInfo[0].ConnectionInfo.UserID="sa";
CrystalReportViewer1.LogOnInfo[0].ConnectionInfo.Password="abc";
CrystalReportViewer1.LogOnInfo[0].ConnectionInfo.ServerName=".";
CrystalReportViewer1.LogOnInfo[0].ConnectionInfo.DatabaseName="db";

Instead of Database Name, I want to use DSN(XYZ);
What will be the syntax?
CrystalReportViewer1.LogOnInfo[0].ConnectionInfo.DSN="XYZ";
above Code will not run.

How to port mysql database to SQL Server database

Eng Mohammed Osman9-Mar-08 0:20

Eng Mohammed Osman

9-Mar-08 0:20

Hi All,

I need to port Mysql database records to SQL sever database.
How can I do this ?

Mohammed Said Emam Osman
Software Engineer

Re: How to port mysql database to SQL Server database

pmarfleet9-Mar-08 0:27

9-Mar-08 0:27

There are several ways you could do this, including:

1. Export each of your MySQL tables to text files, then use the SQL Server BCP utility to load them into your SQL Server database.
2. Write an SSIS package to perform the migration

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

regarding mdf files

mrcsn8-Mar-08 17:10

mrcsn

8-Mar-08 17:10

hi ,

im not getting how to open mdf,ldf database files ..

can any one tell me how to retrieve the database from these files ..

thanks ...

Christian Graus8-Mar-08 22:37

Christian Graus

8-Mar-08 22:37

Here[^].

The obvious way to retrieve the data is to use Access. That's what created them. If you mean how to get to the data in code, then there's tons of info on the web. We couldn't possibly help more, as you don't say what language you're using, if that's what you mean.

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

ChandraRam10-Mar-08 0:57

ChandraRam

10-Mar-08 0:57

I think you mean .mdb files - those are created by Access.

ChandraRam10-Mar-08 0:58

ChandraRam

10-Mar-08 0:58

mrsuman wrote:
im not getting how to open mdf,ldf database files ..

These are the SQL Server database (mdf) and log (ldf) files. You can view the objects using SQL Server Management Studio.

mrcsn10-Mar-08 1:38

mrcsn

10-Mar-08 1:38

Hi ,
thanks for your reply, i am having one mdf and ldf files , i

want to restore the database from these two files . i tried to open with

access , but im getting error .

if u have any idea please let me explain ..

Error While Improting from Excel

ChandraRam10-Mar-08 1:44

ChandraRam

10-Mar-08 1:44

mrsuman wrote:
thanks for your reply, i am having one mdf and ldf files , i want to restore the database from these two files . i tried to open with access , but im getting error .

Looks like you haven't read my reply... these are SQL Server databases, not Access files

Chetan Patel7-Mar-08 22:02

Chetan Patel

7-Mar-08 22:02

i am importing data from Excel to Sql Server Table but I got
follwing error.
Heterogeneous queries require the ANSI_NULLS AND ANSI_WARNINGS

my code

Insert Into JewelryUploadTemp
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D:\share\JewelryUploadSampleMar2008.xls','select * from [chetan$]')

in stored procedure

I am waiting for help...

Best Regards,
Chetan Patel

Re: Error While Improting from Excel

pmarfleet7-Mar-08 22:39

Re: Error While Improting from Excel

7-Mar-08 22:39

Did you not try searching Google[^] to find out what the error message means?

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

new2pgrmg8-Mar-08 3:18

new2pgrmg

8-Mar-08 3:18

Hi,
Are you using a SP.

Try this;

Generally the error is due to needing to set the properties
when you create the stored procedure. Try recreating your
stored procedure using:
SET ANSI_NULLS ON
GO
SET ANSI_WARNINGS ON

GoodLuck

Sql Group by

dsaikrishna7-Mar-08 21:42

dsaikrishna

7-Mar-08 21:42

Dear all,

Here i m facing a problem with some group by date here i m getting two rows of a single date for values fetching. if any one wants i can give the code for ur easy answer giving.

thank you

sai krishna

Re: Sql Group by

Chetan Patel7-Mar-08 22:05

Chetan Patel

7-Mar-08 22:05

When you are using date as group by field then it create new group for each and every record with different time.

ex/

01/10/2007 10:10:00 PM
01/10/2007 12:10:00 PM

so use Convert Function for Convert Date in dd/mm/yyyy fromat for correct answer

Best Regards,
Chetan Patel

Re: Sql Group by

dsaikrishna7-Mar-08 22:13

dsaikrishna

7-Mar-08 22:13

thanks i got it

sai krishna

changing data types [modified]

Saira Tanwir7-Mar-08 21:25

Saira Tanwir

7-Mar-08 21:25

hi fellows,

i want to change the data type of a table1(column1) that exists as a foreign key in table2(column2).
i want to change the data type of column1(table1) but sql server gives the error that column2(table2) is dependent on column1(table1) so the data type cannot be changed.

waht query should i use to ensure that when data type is changed of column1, then the data types of all the referencing columns in different tables should be changed?

reply soon plz!!

modified on Saturday, March 8, 2008 3:34 AM

pmarfleet7-Mar-08 22:49

7-Mar-08 22:49

Suspend referential integrity between the 2 tables, then make your changes.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Saira Tanwir7-Mar-08 23:22

Saira Tanwir

7-Mar-08 23:22

how do i suspend refrential integrity constraint?

pmarfleet7-Mar-08 23:37

7-Mar-08 23:37

Bring your table up in Design mode. From the 'Table Designer' menu select 'Relationships'. Set the 'Enforce Foreign Key Constraint' option to 'No'.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush