I just saw a select query which returns 20 output column and at the end of the query there was an order by clause (ORDER BY 1,2). In the where condition...
ORDER BY 1,2 denotes the first columns in the SELECT list. The result is sorted based on first column first and then on second column. ... From: Techie...
Hi, This denote that order by clause will be applied on selected list from the sequence in which order it is written. For Example:- SELECT Col1,Col2,Col3 FROM...
Dear Tech, You can replace the column name with column number..(ie ORDER BY 1,2 is ORDER BY column1, column) Best Regards Sunil John ... From: Techie...
Dear All, I hv installed SQL 2005 express edition and its working fine. I have little problem in login I can log on with sa and with NT authentication by...
Hi, We are using Transaction Replication in SQL 2000. Due to network problem, our replication get failed. If i used Start Sychronization, it will restart all...
Hello Inder, Â Localhost or (.) or Local will not work as the machine name and the instance name that exress edition takes by default (i.e \sqlexpress) are...
I think this feature is available in SQL 2005 but not in sql 2000. ... From: Manish Sharma <connect_manish@...> Subject: MUGH-SQLCON Replication Problem ...
Anybody has an any idea how to fix the below issues and start working on installing the cluster from 2k to 2k5. Error message when you install SQL Server 2005:...
Dear All, When I restore database in sql2005 i simply clickon databases->Restore databases and fill all the required info but restore fails with the message ...
Hi Varra, SQL has issues with cluster installs when you have a login open on any of the remote nodes. Another problem might be the Windows Task Scheduler is...
Hi Inder, Don't create a new database beforehand . When open the restore DB window , just type the name of the database u want,it will autamatically creates...
You might have to give the "move" option details for the new location details of the logical files inside the backup file. Try "Restore filelistonly from...
Hi All, what is the examination pattern for MCTS 70-431?? is it multiple choice or multiple choice + simulation Please let me know because am going to write...
Dear all, How can get difference between two date in sql 2000. say my startdate is '2008-01-01 00:00:43.753' and enddate is '2008-01-01 00:00:44.783'. i want...
Check this select datediff(ms,'2008-01-01 00:00:43.753' ,'2008-01-01 00:00:44.783') Madhu ... 01-01 00:00:44.783'. i want the difference even to millisecond...
Try this link: http://www.sqlservercentral.com/scripts/T-SQL+Aids/30242/ You may have to register to view this page, but registration is free Best Regards, ...
Hi All, While creating Publisher on SQL 2000 I am getting error "Process could not access database ... of server...". I have checked the owner and every...
Hi All, While creating Publisher on SQL 2000 I am getting error "Process could not access database ... of server...". I have checked the owner and every...
Hi All, I have made a few blog posts on generating subtotal/total rows as part of the query results, this week. These posts examine different options using...
Hi All, I have 10 partitions on a table. Now I want to remove 2 out those 10. I dont even want to save the data in those patitions. What's the fastest way to...
Hi, There is nothing so complicated about the LEN() function. But I observed a few interesting points about its behaviour in different cases. I have posted my...
Hi, I have been writing about the SET options of SQL Server and wrote about ANSI_NULLS and ANSI_WARNINGS. I was in the middle of a post that discusses SET...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
