rathnakar

hi friend, this query selects 4th max record from the table . select top 1 * from vehicles where sno in(select top 4 sno from vehicles )order by sno desc regards, rathnakar

[QUOTE=sknake;905163]There is no out of the box way to do this with MSSQL but its a common request for web applications so you can show rows 1-10, 11-20, 21-30, etc. on a website. Try googling "MSSQL PAGING" or "MSSQL PAGINATION" and you should come up with a lot of relevant …

hi friend, followind queries will help u, update table1 set column1=b.column1 from table1 a,table2 b where a.column2=b.column2 or update table1 set column1='ap' where dist in(select dist from tabl2) regards, rathnakar [QUOTE=fatjoez;907557]I have 3 tables, below are their structures ( a bit of pseudo code ) I'm trying to update one …

hi friend, to disable trigger : DISABLE TRIGGER trigger_create to enable trigger: enable TRIGGER trigger_create regards, rathnakar

hi friend , use following query in your code(sql command) select case when date1 is null then 'date is not found' else convert(nvarchar,date1,105) end as date1 from datetest regards, rathnakar [QUOTE=vytla;914795]hi friends fetching datetime values from database, when data is null in code side it is displying the some garbage …