Database

13-Jan-09 17:40

I think it may be here on your installation DVD:
x64\Setup\sql_ssms.msi
this is setup of SqlServer Management Studio

Human knowledge belongs to the world

try catch in T-SQL

George_George12-Jan-09 21:59

12-Jan-09 21:59

Hello everyone,

I an new to begin try/end try and begin catch/end catch. Could anyone recommend me some tutorials for a beginner?

My background is, I wrote T-SQL before, but not too much, I have never used begin try/end try and begin catch/end catch.

thanks in advance,
George

Wendelius12-Jan-09 22:16

12-Jan-09 22:16

Have you looked at these:
- http://www.4guysfromrolla.com/webtech/041906-1.shtml[^]
- http://www.codeproject.com/KB/database/ExceptionHandlingSql2005.aspx[^]

The need to optimize rises from a bad design.My articles[^]

George_George13-Jan-09 0:58

13-Jan-09 0:58

Good stuff, thanks Mika!

regards,
George

Hamid_RT15-Jan-09 2:28

Hamid_RT

15-Jan-09 2:28

See Try/Catch Block in SQL Server 2005[^] and T-SQL error handling with Try…Catch blocks[^].

Of one Essence is the human race
thus has Creation put the base
One Limb impacted is sufficient
For all Others to feel the Mace
(Saadi )

George_George15-Jan-09 18:29

15-Jan-09 18:29

Good stuff, thanks Hamid!

regards,
George

GETUTCDATE and GETDATE

George_George12-Jan-09 21:14

12-Jan-09 21:14

Hello everyone,

Any ideas what is the differences between GETUTCDATE and GETDATE? And when to apply GETUTCDATE and when to apply GETDATE?

thanks in advance,
George

Reza Raad12-Jan-09 21:44

12-Jan-09 21:44

getutcdate means : Coordinated Universal Time
and return universal time regardless your time zone
but getdate return time based on your time zone:

<br />
SELECT 'SYSDATETIME()      ', SYSDATETIME();<br />
SELECT 'SYSDATETIMEOFFSET()', SYSDATETIMEOFFSET();<br />
SELECT 'SYSUTCDATETIME()   ', SYSUTCDATETIME();<br />
SELECT 'CURRENT_TIMESTAMP  ', CURRENT_TIMESTAMP;<br />
SELECT 'GETDATE()          ', GETDATE();<br />
SELECT 'GETUTCDATE()       ', GETUTCDATE();<br />
/* Returned:<br />
SYSDATETIME()            2007-05-03 18:34:11.9351421<br />
SYSDATETIMEOFFSET()      2007-05-03 18:34:11.9351421 -07:00<br />
SYSUTCDATETIME()         2007-05-04 01:34:11.9351421<br />
CURRENT_TIMESTAMP        2007-05-03 18:34:11.933<br />
GETDATE()                2007-05-03 18:34:11.933<br />
GETUTCDATE()             2007-05-04 01:34:11.933<br />
*/<br />

Human knowledge belongs to the world

George_George13-Jan-09 0:31

13-Jan-09 0:31

Thanks Reza,

Could I understand GETDATE returns machine local time?

regards,
George

Reza Raad13-Jan-09 2:53

13-Jan-09 2:53

George_George wrote:
Could I understand GETDATE returns machine local time?

GetDate() returns current date of your sqlserver machine(means the server where your sqlserver installed)

Human knowledge belongs to the world

George_George14-Jan-09 2:10

14-Jan-09 2:10

Thanks Reza!

regards,
George

Wendelius12-Jan-09 21:45

12-Jan-09 21:45

GETUTCDATE returns current date of the system in UTC time (Greenwich Mean Time) while GETDATE return current time in the timezone where the system is working.

The need to optimize rises from a bad design.My articles[^]

George_George13-Jan-09 0:31

13-Jan-09 0:31

Thanks Mika!

regards,
George

Wendelius13-Jan-09 0:45

13-Jan-09 0:45

You're welcome Smile | :)

The need to optimize rises from a bad design.My articles[^]

J4amieC13-Jan-09 1:47

J4amieC

13-Jan-09 1:47

For pete's sake george your questions are becoming more asanine by the day.

What the bloody hell do you think the difference would be given the method names are very explicit.

George_George13-Jan-09 2:13

13-Jan-09 2:13

Thanks J4amieC,

I appreciate people'e help here. I am a newbie. Smile | :)

regards,
George

J4amieC13-Jan-09 3:03

J4amieC

13-Jan-09 3:03

George_George wrote:
I am a newbie.

You dont say?!

However, newbie aside, one of the most important skills you must learn if you want to work in this profession is how to look thinks up.... wait, im wasting my time again! You've had this point explained ad infinitum.

George_George14-Jan-09 2:11

14-Jan-09 2:11

Sorry for any in-convenience, J4amieC! Smile | :)

I am catching-up with SQL Server soon.

regards,
George

Hamid_RT15-Jan-09 2:30

Hamid_RT

15-Jan-09 2:30

See What Is the Difference Between GETDATE() and GETUTCDATE()?[^] and Date and Time Functions[^].

Of one Essence is the human race
thus has Creation put the base
One Limb impacted is sufficient
For all Others to feel the Mace
(Saadi )

George_George15-Jan-09 18:19

Which database is best for my application.

15-Jan-09 18:19

Good stuff, thanks Hamid!

regards,
George

Nanda_MR12-Jan-09 18:46

Nanda_MR

12-Jan-09 18:46

I m creating a application it record information per min 4*32 set of record.
So which database i can use. I am planning to MYSQL. is it any other best database is there

Note: I need a mass storage.

Thanks in advance.

Re: Which database is best for my application.

Reza Raad12-Jan-09 18:51

Re: Which database is best for my application.

12-Jan-09 18:51

The Oracle can be good selection
but why this mass of record??!!

Human knowledge belongs to the world

Nanda_MR12-Jan-09 20:15

Nanda_MR

12-Jan-09 20:15

My program like that it store one second 4*32. A machine send that much set of record.

Re: Which database is best for my application.

Wendelius12-Jan-09 22:22