SQL Server database programming

Hi,     I have SQL 2000. I run the query: Select Field1, Field2, Field1 / Field2 * 100 as [Answer] From Table1 ....(Field1 =37 and Field2 = 50 and are Int datatype) SQL Server returns 0 as the [Answer] Is something wrong with my query or has anyone else had this problem? ...

Hi all, I have a problem. I have to replicare this complex select with many NOT IN clause: SELECT uid, sid, Cliente, OpCode, IdServizio, IdProdotto, Quantita, OperationDate, ModalitaPagamento, PaymentReference, Importo, Status     FROM  tblTransazioniInput     WHERE Cliente IN ...

Hello I have created this code to go through all the tables in my databases, changing Nullable fields to 'Not null' -- Drop Procedure DropNulls -- use ChangeOrders_BESQLSERVERSQL --Create procedure DropNulls as set xact_abort OFF --select 1/0 Declare MyTablesCur Cursor for SELECT [name]  FROM ...

I have a parameter in which I need to pass a code that contains an "&" (ie.  'TI & GT').   What is the syntax for me to correctly do this?   I have tried 'TI & GT' and 'TI &amp GT' as parameters but get no rows ...

someone asked me to write a trigger to validate the record that has been inserted, not all of them. I am really confused. I dont know how to validate the particular record that aleardy inserted. Any ideas? Farrukh ...

Hi all, I would like to develop a VB.NET windows application with SQL 2005 as a database. My requirement is data must be sent to VB app in an ecrypted format and the app will decrypt the data. When I deploy the application ...

hey My problem is that my select don't return any rows. As you see I have commented out the "where" clause, because I thought the error was related to it, but no it wasn't. The SP return no rows.. The table has about 20 rows, ...

Hi all, I need ur help. How to store  Hours and minutes only in the datetime field Is it possible? Thanks in Advance Sundara Murthy ...