Problem with LDF files ( database log file ) - Database Discussion Boards

Re: a mistake with the "Like" statement..help!..

keremburak13-Sep-07 6:12

keremburak

13-Sep-07 6:12

thanks buddy maybe sometimes you must look at it in a true point.I have done it.

Thnx.

Re: a mistake with the "Like" statement..help!..

Blue_Boy13-Sep-07 20:36

Blue_Boy

13-Sep-07 20:36

You are welcome...

I Love SQL

Re: a mistake with the "Like" statement..help!..

PIEBALDconsult10-Sep-07 5:08

PIEBALDconsult

10-Sep-07 5:08

zmskerem wrote:
"*'";

Try a percent sign (%).

Re: a mistake with the "Like" statement..help!..

Blue_Boy10-Sep-07 22:54

Blue_Boy

10-Sep-07 22:54

Database is Access, not SQL and condition % always return null value.
Instead of % is used *

I Love SQL

Re: a mistake with the "Like" statement..help!..

rohitsrivastava10-Sep-07 19:42

rohitsrivastava

10-Sep-07 19:42

hi friend
you are right there is mistake in sql please correct it

right
string strSQL = "select FilmName from films where FilmName like '" & cmbContent.Text & "%'" ;

wrong this is your
"select FilmName from films where FilmName like" + "'" + cmbContent.Text + "*'";

Re: a mistake with the "Like" statement..help!..

Blue_Boy10-Sep-07 22:55

Blue_Boy

10-Sep-07 22:55

rohitsrivastava wrote:
right
string strSQL = "select FilmName from films where FilmName like '" & cmbContent.Text & "%'" ;

false
_________________

rohitsrivastava wrote:
wrong this is your
"select FilmName from films where FilmName like" + "'" + cmbContent.Text + "*'";

true

I Love SQL

Re: a mistake with the "Like" statement..help!..

DerekFL12-Sep-07 8:19

DerekFL

12-Sep-07 8:19

Use "%" instead of "*"

Problem with LDF files ( database log file )

Developer6119-Sep-07 1:45

Developer611

9-Sep-07 1:45

Hi there .

I have a problem with SqlServer 2005 Log file .
I have an application and i want to attach my database to SqlServer , I did it by SqlConnection and ConnectionString ,in many times it gives me an error.

I know that when we use AttachDbFilename property in Connection for attach DB we don't need database log file, But most of times it gives me this error:

"Unable to open physical file 'filpath_log.LDF'. Operation system error 5: "5(error not found)".<br />
Could not open new database 'DbName'. CREATE DATABASE is aborted.<br />
Cannot attach the file 'FilPath.mdf' as database 'DbName'.<br />
File activation failure. The physical file name 'filpath_log.LDF' may be incorrect.<br />
The log cannot be rebuilt when the primary file is read-only.'

I wonder to say sometimes attachment works but sometimes not. WTF | :WTF:

I already did this attachment process with SQLServer 2000 and it never gives me error Dead | X|

DMASTER

Re: Problem with LDF files ( database log file )

Frank Kerrigan10-Sep-07 9:33

Frank Kerrigan

10-Sep-07 9:33

What are you trying to do ?????

Load a log file via a connection ????

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

Re: Problem with LDF files ( database log file )

rohitsrivastava10-Sep-07 19:54

rohitsrivastava

10-Sep-07 19:54

hello friend

where u get the back of data base it is not saved full some thing is missing so again take back up and there is no error tell me how to creat database with sqlscript or enterprisemanager if u take backup of enterprisemanager is best this is the

step
(1) open Enterprisemanager
(2) right click on database name
(3) All Task
(4) Attach database
(5) MDF File database to attach (Browse the path)
(6) click mdf file and ok button

you have succesfully attach in the server database

then your problem is solve connection to database coding

have a nice day

How to find tree path in a table with parent cod

sepel9-Sep-07 1:39

sepel

9-Sep-07 1:39

i have a table with a tree organiz.
each record have a unic id and a parent id that refrenc to aanother id on this table. so each record have a parent or more
i want to find the fulll path of a record such as :
human/body/leg
i want to do it with a function in mysql;
every one can help me?

-- modified at 7:44 Sunday 9th September, 2007

sepel

Re: How to find tree path in a table with parent cod

Chetan Patel9-Sep-07 21:25

Chetan Patel

9-Sep-07 21:25

Use Recursive function each time it add parent untill the parent is null.

Best Regards,
Chetan Patel

How to implement Transaction in a MySql Stored Procedure with Cursor ?

fearless stallion8-Sep-07 19:16

fearless stallion

8-Sep-07 19:16

Hi

I am using a MySql 5.0 DB. am trying to implement a transaction inside a stored procedure which uses cursors. but the problem is the way the cursor closes it self. it throws an exception, i have written a handler for any sqlexception inside the procedure which simply rolls back, and because of the cursor , transaction gets rolled back without completing the task.

Has anybody ever worked on MySql with transactions. Please Help.

thanks

KSS

Re: How to implement Transaction in a MySql Stored Procedure with Cursor ?

DLM@TD14-Sep-07 12:00

DLM@TD

14-Sep-07 12:00

Hi,

the following stored procedure will work properly with transactions and cursors:

DELIMITER $$

DROP PROCEDURE IF EXISTS `testdb`.`TestCursorRollback` $$
CREATE PROCEDURE `testdb`.`TestCursorRollback` ()
BEGIN
declare n int;
DECLARE done INT DEFAULT 0;
declare cur1 cursor for select col1 from hotels.a;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
start transaction;
open cur1;
repeat
fetch cur1 into n;
if not done then
insert into testdb.b(col1) values (n*10);
end if;
UNTIL done END REPEAT;
close cur1;
rollback; /* or commit*/

insert into testdb.b(col1) values(200);
END $$

DELIMITER ;

FREE cross database comparison and synchronization tools
DBTYP.NET - see database differences, for free (SQL Server, MySQL, Oracle)

Re: How to implement Transaction in a MySql Stored Procedure with Cursor ?

fearless stallion19-Sep-07 16:39

fearless stallion

19-Sep-07 16:39

Hi,

Thanks for the reply but i was looking for another handler for the rollback part.

Like : Declare Exit handler for SQLEXCEPTION ROLLBACK;

I want my proc to roll back in case of any error. because once i find any error it will throw an exception to my application which can never rollback-ed

thanks

Siva

kss

Database App

gtkoder8-Sep-07 16:38

gtkoder

8-Sep-07 16:38

How do i create a form that bind a one to many relationship data source in VB.NET 2005

Re: Database App

Chetan Patel9-Sep-07 21:27

Chetan Patel

9-Sep-07 21:27

can you give me some brief description about you problem

You have to use join for selecting the data and just assign dataset to the DataControl.

Best Regards,
Chetan Patel

how to back up the data base

prasadbuddhika8-Sep-07 16:16

prasadbuddhika

8-Sep-07 16:16

i want to back up my data base automatically everyday at a given time ,can you tell me how to do it in sql server 2005.

Re: how to back up the data base

John-ph8-Sep-07 20:09

John-ph

8-Sep-07 20:09

Check out the BACKUP Command in sql server 2005 which is used to backup the entire database. If you want to Backup the DB periodically then create a procedure with the BACKUP command and schedule a job in the sql server agent that calls the Procedure periodically...

BACKUP DATABASE [DatabaseName] TO  DISK = N'C:\BackUp\DB_BKUP_09_09_07'WITH  DIFFERENTIAL , NOFORMAT, NOINIT,  NAME = N'DatabaseName-Differential Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10

Regards
J O H N

"Even eagles need a push." David McNally

Re: how to back up the data base

Rami Said Abd Alhalim8-Sep-07 20:14

Rami Said Abd Alhalim

8-Sep-07 20:14

hi
you must go to microsoft SQL Server Management Studio => choice Server object
right click on Backup device =>choice backup database => choice your database => and choice option to set information

Re: how to back up the data base

Rami Said Abd Alhalim8-Sep-07 20:21

Rami Said Abd Alhalim

8-Sep-07 20:21

hi you can go to sql server agent ---> choice job right click and choice schedual ---> new schedual --> choice what you need

Rami Abdalhalim

SQL issue

Max++8-Sep-07 15:53

Max++

8-Sep-07 15:53

How can I use SQL operation such as create database ,delete database ,update database, change password, add user.....
by write the code in visual c++.

Please give me the good link or article which support this issue.

Thanks

Re: SQL issue

Paul Conrad8-Sep-07 16:31

Paul Conrad

8-Sep-07 16:31

Your question is way to broad for a post, so I recommend looking around this site. As far as changing passwords, adding users, etc. that all depends on how your database tables are set up.

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Re: SQL issue

Frank Kerrigan10-Sep-07 9:27

Frank Kerrigan

10-Sep-07 9:27

READ SQL Server Books online or buy a book (if you can afford it).

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

join issue

Tauseef A8-Sep-07 2:49

Tauseef A

8-Sep-07 2:49

hi guys

i have the followig query

select a.plhrs ,b.sthrs,a.mon
from

(select to_char(month,'Mon-yyyy') as mon,
sum(st) as plhrs from espcs.bud_mpl where empno='0541'

group by to_char(month,'Mon-yyyy'))a,

(select to_char(ddate,'Mon-yyyy') as mon2 , sum(sthrs) as sthrs

from espcs.manhrs where empno='0572' group by to_char(ddate,'Mon-yyyy')) b

where b.mon2 = a.mon

in this query i am getting sum values from both tables based on the months from
the table a,
but the problem is that it eliminates the records if it does not find the matching months from both tables, as i want that it shud show the month with a value of blan if it does not find the matching the matching months's records in the corresponding table,i want to use joins,,
i am new to oralce , can any body help me
thanks in advance

hello

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