No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
Hi This might be a basic question for all of u, but i need help from you guys. here is my query select (sum(datediff(dd,DateAdmitted, DateDischarged))/count(*)) AS Avrvg from table1 where DateDischarged is not null this gives me the result as 4 in the column Avrvg. but the actual result should … |
|
I have a query. Say in a notepad( D:\SQL.txt) I have 100 commands written in it UPDATE sal SET sal= sal+3000 select * from .................. insert into table tab_name values(........) insert into table tab_name values(........) insert into table tab_name values(........) .........so on Is there any SQL query like that if … |
|
Re:
Is there anyway to have (in one query) two separate queries? For example if query one fails then it will not affect the rest of it. Example code: Say that the lastLogin table does not exist: UPDATE userInfo SET lastLogin=3 WHERE id=5 UPDATE userInfo SET LastLogin=3 WHERE id=5 Is there … |