Interested to Buy Any Domain ? << Click Here >> for more details...
How do we get current date in SQL Server 2000, Oracle, MS
Access?
- 13 Answers
- 52857 Views
- I also Faced
- E-Mail Answers
Answer Posted / lrk
SELECT GETDATE() AS 'Current Date'
GO
| Is This Answer Correct ? | 66 Yes | 20 No |
Post New Answer View All Answers
What is SQL Azure Firewall?
How you can add messages to the nt event log from within a stored procedure?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
Why use triggers?
Write SQL queries on Self Join and Inner Join.
Differentiate between a primary key and a unique key.
Why do we backup Active Directory ?
what is sql server? : Sql server database administration
What is the Disadvantage of indexed sequential file.
Do you know the different ddl commands in sql?
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.
Explain system functions or built-in functions? What are different types of system functions?
Explain features and concepts of analysis services?
Do you know clustered and non-clustered index?
How to drop an existing schema in ms sql server?
