Get Current System Date Time

Answer Posted / ahamed razik

select getdate()

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does partitioning improve performance?

591


what is a live lock? : Sql server database administration

562


What is the difference between SQL notification and SQL invalidation?

671


What are types of scd? : sql server analysis services, ssas

629


hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2558






how to create “alternate row colour”?

115


What are cursors stored procedures and triggers?

588


Write the SQL query to drop, truncate and delete table.

644


How to identify current user in ssrs report?

285


List all types of constraints in sql server?

594


How to create indexed view?

641


What is the difference between a primary key and a unique key? Are they the same?

650


How do I find sql server instance name?

604


What is shrink log file?

581


How do we know if any query is retrieving a large amount of data or very little data?

634