I need to do an order by on my select, but not working..
What I have... select size from table where jonny_id = '05' order by size desc
What I get... 8.00mm, 5.00mm, 12.00mm, 11.00mm
What...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23056669.html
Hello
in SQL Server 2005,I want to prevent any empty value in some columns in a table in updating or inserting and if user entered the empty value in a column it must convert to null instead
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2315...
I want to be able to access and administer any SQL server from any computer in a multiple domain system. Trusted security is setup. We can see the NT servers and administer them but we cannot see S...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10058008.html
Hi!
I got a message from sql server when I accessed a data base.... can I deactivate it and after that, send a message fom VB to the user of my program?
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_DB/Q_10124719.html
Zones:
VB DBDate Answered: 05/09/1999 Grade: C Views: 0
I'm have a stored procedure in SQl Server . It accept 3 parameters and I want know how must be a structure in VB to access the 'sp'. The stored procedure have any files in your process, I have to d...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_DB/Q_10139261.html
Zones:
VB DBDate Answered: 03/17/1999 Grade: D Views: 0
How can I trigger a replication in SQL Server 7.0
I do not want to use schedule
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10188861.html
I need to know which one to use on our SQL 7 server configuration? Clustering or Failover. Redundancy is very important but I find very little information on actual configuration information. I nee...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10205765.html
I am using microsoft SQL SERVER 6.5
====================================
1) what is the equivalent of "DESCRIBE TABLE" in sql server 6.5 ?
2) HOw do I drop a column in Ms sql 6.5 ?
ALTER ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10323235.html
Dear experts
Can anyone educate me in how to extract the the size of an individual database within SQL Server 7.0. I realise the Enterprise Manager displays this information but how is this extr...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_11206636.html
In my one of table I am having triger on insert operation and in that triger I am having SQL statement for insert,update and delete on the same table one after other. Then how many times the wil ex...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_11338517.html
