Does order by actually change the order of the data in the tables or does it just change the output?
No Answer is Posted For this Question
Be the First to Post Answer
What is a domain constraint give an example?
How many types of built in functions are there in sql server 2012?
Hi SQL gurus, i am working for an MNC... My team is having a problem in sql server. when user slects date prompts from jan 1st to april 30, it should display all months data like : jan aa feb bb mar cc but when it comes to april its taking data like : jan aa feb bb mar cc apr dd...and so on means its taking data again from jan to april which we dont want. we want the data only april month as we are getting jan, feb and mar... can any one write the code to relsove the issue please would be greatful if you can send to shiva_sans@yahoo.co.in and also please send your email also ...so that we will be in touch for any kind of queries ... Thanks a lot in Advance !!!
How to list all dsn entries on your local machine using odbc_data_source()?
Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.
How to call stored procedure using http soap?
How many primary keys are possible in a table?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
What do you understand by sql server agent?
What is blocking and how would you troubleshoot it? : sql server database administration
Do you know what are the properties of the relational tables?
how we can store the value like that 001,003,023 etc in sql server 2005
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)