How do we get month name in SQL Server 2000, Oracle, MS Access?
Answers were Sorted based on User's Feedback
Answer / anil sharma
SELECT CONVERT(varchar,GETDATE(),0)
Return Value = Jun 6 2007
| Is This Answer Correct ? | 5 Yes | 10 No |
Where do you think the users names and passwords will be stored in sql server?
what is difference between having and where clause ?
Can we join two tables without primary key?
Explain the first normal form(1nf)?
How send email from database?.
3 Answers CarrizalSoft Technologies, Merrill Lynch,
Is index a datbase objects in sql server?
How do you check sql server is up and running?
Can we insert data into a view?
How to retrieve error messages using mssql_get_last_message()?
Can a cursor be updated? If yes, how you can protect which columns are updated?
Indexes are updated automatically is the full-text index also updated automatically?
my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)