msi

I am new to sql .please help me with this . the following sql statement works when i use like this Dim' CmdStr As String = "insert into table1(id,name,ref,amount) select id,name,ref,amount from table where name = A" I want to copy rows from one table into multiple tables Dim CmdStr …

how to delete duplicate record in a table by using SQL query

Hello all. When I run the statement: select regdate,description,machine_id,machine_nm,status from iris_log.dbo.tb_log_info where regdate like '%23%' I get the result: 2009-01-23 08:05:06.000 Administration Software is Closed. Operator's Name:admin But if I do: select regdate,description,machine_id,machine_nm,status from iris_log.dbo.tb_log_info where regdate like '%-23%' the result is null... why?!?! TIA, -hdmnp

I want to write an sql statement in c# where I want to pass a "true" or "false" value basing on some condition... can we pass true to sql statements Ex: [CODE]select * from emp where (empid=1234 and true); select * from emp where (empid=1234 and false); [/CODE] This true …

Can anyone help? I have been fumbling around with a SQL statement for days trying to make this work. I am looking for a Statement that will output a table based on an incremented number. Example Table1: Value1.......Value2.......Incremented Number 14...............null.............1 12..............15...............2 12...............98..............3 15...............14..............4 17...............15..............5 1.................14..............6 5.................98..............7 Example Table2: Value1.........Value2 X030............1 …