|
No problem
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
|
Good stuff, thanks Mika!
regards,
George
|
|
|
|
|
|
Good stuff, thanks Hamid!
regards,
George
|
|
|
|
|
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
|
|
|
|
|
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 />
<br />
Human knowledge belongs to the world
|
|
|
|
|
Thanks Reza,
Could I understand GETDATE returns machine local time?
regards,
George
|
|
|
|
|
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
|
|
|
|
|
Thanks Reza!
regards,
George
|
|
|
|
|
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.
|
|
|
|
|
Thanks Mika!
regards,
George
|
|
|
|
|
You're welcome
|
|
|
|
|
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.
|
|
|
|
|
Thanks J4amieC,
I appreciate people'e help here. I am a newbie.
regards,
George
|
|
|
|
|
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.
|
|
|
|
|
Sorry for any in-convenience, J4amieC!
I am catching-up with SQL Server soon.
regards,
George
|
|
|
|
|
|
Good stuff, thanks Hamid!
regards,
George
|
|
|
|
|
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.
|
|
|
|
|
The Oracle can be good selection
but why this mass of record??!!
Human knowledge belongs to the world
|
|
|
|
|
My program like that it store one second 4*32. A machine send that much set of record.
|
|
|
|
|
Do you mean that yo will store 128 records per minute. If so, that isn't so much, but if the amount rises, I think the first bottleneck will be the program storing those records and the possible network between the program and the database. Most of the databases canhandle that amount easily as long as the commands can be delivered to them fast enough.
One consideration is also that do you insert every record separately or can you make insertions as a batch. For example SQL Server client in .Net framework has SqlBulkCopy class which might be useful. Also SqlDataAdapter can handle batches. I'm not sure what's the sitatuation with MySQL client.
|
|
|
|