Re: date problem - Database Discussion Boards

abcurl31-Aug-09 0:16

31-Aug-09 0:16

I have 2 columns in the table.
Want to create script for new column, and it's IS_Nullable value should be No.
Can u please provide me teh script to do so?

Re: Not Null field script

εїзεїзεїз31-Aug-09 6:56

εїзεїзεїз

31-Aug-09 6:56

if not exists(Select * from syscolumns where name ='yourfldname' and id in(Select id from Sysobjects where xtype ='U' and name ='yourtablename'))
ALTER TABLE yourtablename add yourfieldname bit default(0) not NULL

Best Of Regards,
SOFTDEV
Sad like books with torn pages, sad like unfinished stories ...

date problem

venu65630-Aug-09 21:54

venu656

30-Aug-09 21:54

hi experts
in my table i have a column with name Date and id

Date id

2009-7-13 218665
2009-7-14 218665
2009-7-15 218665
2009-7-16 218665

2009-7-19 218665

2009-7-20 218665

2009-7-21 218665

i want to know weather rows r present from one date to another like from date and to date

if i have give from date =2009-7-13 and to date = 2009-7-20 it shuld compare with the date column it should not show all the rows are present because 200-7-17 is not available....

if i have given from date = 2009-7-12 and to date= 2009-7-16 even it shuld not show because 2009-7-12 is not present and vice versa

plz guide me

Re: date problem

dan!sh 30-Aug-09 23:00

dan!sh

30-Aug-09 23:00

How about this?

if(exists(select col1 from temptable where col1 = @fromDate or col1 = @toDate))
begin
select col1,col2 from tablename
where (col1 between @fromDate and @toDate)
end

else
begin
select 'Table does not contains one of the date.'
end

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

Re: date problem

venu65630-Aug-09 23:38

venu656

30-Aug-09 23:38

no friend it was not working even the columns r getting which r out of dates

Re: date problem

dan!sh 31-Aug-09 0:26

dan!sh

31-Aug-09 0:26

Missed out the first part. Sorry.

AFAIK you will need to write a while loop to do this matching all the dates between the range. But beware, from whatever I have read in the forums, looping techniques might cause performance related issues.

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

Re: date problem

venu65631-Aug-09 0:30

venu656

31-Aug-09 0:30

can u work out on that iam not getting good idea abt while loop

Re: date problem

dan!sh 31-Aug-09 0:36

dan!sh

31-Aug-09 0:36

venu656 wrote:
can u work out on that

Will I get paid for that? I guess no. Then I wont.

Here are the links that will help you.

While loop in SQL[^]

DateAdd function in SQL[^]

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

Re: date problem

venu65631-Aug-09 0:57

venu656

31-Aug-09 0:57

no yaar i cant pay iam still under bankrupt so let me describe that

Re: date problem

Luc Pattyn31-Aug-09 1:06

Luc Pattyn

31-Aug-09 1:06

your database should store dates and datetimes as such, not as strings. stringed dates just beg for problems.

Smile | :)

Luc Pattyn

Badger | [badger,badger,badger,badger...]

Have a look at my entry for the lean-and-mean competition; please provide comments, feedback, discussion, and don’t forget to vote for it! Thank you.

Re: date problem

venu65631-Aug-09 2:29

venu656

31-Aug-09 2:29

thats not a big problem of string i want to know how to check each and every field in the date

Re: date problem

Luc Pattyn31-Aug-09 2:43

Luc Pattyn

31-Aug-09 2:43

when you store dates as real dates, not strings, you could use date functions[^]; stored as strings, you can try and apply string substringing, however you could be subject of regional setting difference problems.

Smile | :)

Luc Pattyn

Have a look at my entry for the lean-and-mean competition; please provide comments, feedback, discussion, and don’t forget to vote for it! Thank you.

Re: date problem

Henry Minute31-Aug-09 2:49

Henry Minute

31-Aug-09 2:49

If there can only be one entry per date then you can compare the number of rows returned with the number of days between the two dates.

Other than that I cannot help. Smile | :)

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Re: date problem

venu65631-Aug-09 19:01

venu656

31-Aug-09 19:01

hai sir
the date is one fiels but we are comparing here one fiels with fromdate and todate

Re: date problem

Eddy Vluggen31-Aug-09 4:58

Eddy Vluggen

31-Aug-09 4:58

A date does not contain subfields. You're prolly referring to the parts called "day", "month" and "year", but it takes all three to create a date.

A date is not internally stored as a combination of "day, month, year", but as a number, representing "days passed since <startdate>".

The date that you "see" (the string) is a visual representation of the same fact, but formatted for your local culture. It's a visualisation of the date (the plain number in the database) in a specific, culture-dependant string.

In other words; if it fits in a DateTime, then you won't have to check whether the month is larger than "12" Smile | :)

Dictionaries: How do they work?

msn9230-Aug-09 11:45

msn92

30-Aug-09 11:45

Hi everybody.

I would like to know about dictionaries: How do they work?
By "dictionary" I mean a program that translates a word from one language to another.

So my questions are:
1. What kind of database do they usually use to store data?
2. How do they search so quickly?
3. Where can I get more info about dictionaries/their development?

PS if it's not the right place I posted at.

Re: Dictionaries: How do they work?

Eddy Vluggen30-Aug-09 23:05

Eddy Vluggen

30-Aug-09 23:05

msn92 wrote:
1. What kind of database do they usually use to store data?

A fast, embedded database. Often some custom format.

msn92 wrote:
2. How do they search so quickly?

Indexes

msn92 wrote:
3. Where can I get more info about dictionaries/their development?

Download the Ergane[^] dictionaries, and take a look at the structure. The dictionaries are in MS-Access format, and they should provide a decent starting point.

Measuring programming progress by lines of code is like measuring aircraft building progress by weight.

-- Bill Gates

Re: Dictionaries: How do they work?

msn9231-Aug-09 7:32

msn92

31-Aug-09 7:32

Thank you for your reply Eddy Vluggen!

Could MS-Access database be "A fast, embedded database" ? Smile | :)

Re: Dictionaries: How do they work?

Eddy Vluggen31-Aug-09 10:44

Eddy Vluggen

31-Aug-09 10:44

msn92 wrote:
Could MS-Access database be "A fast, embedded database" ?

Yup, those databases are actually the datafiles that the Ergane-application itself uses Smile | :)

"The wine is good, but the meat is rotten"

Remote DML/DDL from different Nodes to MS SQL Server 2005

nt_virus29-Aug-09 11:07

nt_virus

29-Aug-09 11:07

Hello. I was tried figuring out how to use my different pc to perform DML/DDL operation in Mircosoft SQL Server and whose effect will be shown in Main PC. There demo is described below.

3 PC. 2 PC = Client for DML/DDL Operation. 1 PC = Server to reflect changes.
OS in 3 PCs = XP Pro.
All 3 PCs have Sql Server 2005 installed.

Now.. what I want to do is .. if I do any DML/DDL operation from those two pcs which acting as a client the changes should affect in the Main Server PC.

I m not figuring out the way to LINK those two PC's SQL Server with the Main PC's SQL Server.

Please assist me in finding a technique to solve this problem. We already connect these 3 pcs successfully with LAN but not getting a way to solve this problem.

Re: Remote DML/DDL from different Nodes to MS SQL Server 2005

Henry Minute29-Aug-09 12:27

Henry Minute

29-Aug-09 12:27

Is the SqlServer on these PCs the Express version?

Re: Remote DML/DDL from different Nodes to MS SQL Server 2005

Mycroft Holmes29-Aug-09 14:45

Mycroft Holmes

29-Aug-09 14:45

This sounds weird and not very good.

Do you want all 3 servers to reflect the changes made in 1?

There is not way that I know of to do this 'on the fly', you can use something like Red-Gate SQL Compare and data compare to synchronise the structure but this is a seperate operation, it generates a script that could be run on each server.

Backup/Restore will include the data (obviously)

Never underestimate the power of human stupidity
RAH

Re: Remote DML/DDL from different Nodes to MS SQL Server 2005

nt_virus29-Aug-09 22:14

nt_virus

29-Aug-09 22:14

I have Developer Edition of SQL Server.

What actually will happen is 2 data entry operators will enter datas from 2 pcs and the changes should be made in the database reside in my Server PC. It doesn't matter for me if those 2 pcs are having SQL Server installed.

My main concern if DML/DDL from 2 pc should affect Server PC.

Re: Remote DML/DDL from different Nodes to MS SQL Server 2005

Mycroft Holmes29-Aug-09 23:35

Mycroft Holmes

29-Aug-09 23:35

What is the client the DE users are using?

Never underestimate the power of human stupidity
RAH

Re: Remote DML/DDL from different Nodes to MS SQL Server 2005

nt_virus30-Aug-09 2:02

nt_virus

30-Aug-09 2:02

Sorry I didn't get you mate.

All PCs have Developer Edition [DE]. And application are made by me and my friends.

Suppose when I open SQL Server 2005 and Run the Insert Query on a table then that insert should ALSO reflect in SERVER. We don't care if that Data will store in Client side too.

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