How do i find if current date is the last date of the month or not... Like if i pass a date then my fuction should return Yes if it is last Date of month or Return NO if it is not.. Thanks in Advance... ...

<p>How do i find if current date is the last date of the month or not...</p> <p>Like if i pass a date then my fuction should return Yes if it is last Date of month or Return NO if it is not..</p> <p>Thanks in Advance...</p>...

i would like to join a table with and function is this possible within SQL. as if table table has column sid int primary key and function takes parameter sid as input and return some records for that sid. So i want top 10 sid's from table and join thi...

<p>i would like to join a table with and function is this possible within SQL.</p> <p>as if table table has column sid int primary key and function takes parameter sid as input and return some records for that sid.</p> <p>So i want top 10 sid's from tabl...

How to get only time part from datetime field i am only intereted in time so is there anyway to get only time, if possible then please provide a script through which only time in entered in the database. Thanks in Advance. ...

<p>How to get only time part from datetime field i am only intereted in time so is there anyway to get only time, if possible then please provide a script through which only time in entered in the database.</p> <p>Thanks in Advance.</p>...

Hi i have an column say Codes and Codes has value like Codes ajsfh 10x2 dhjgh 37x8 and something like this i want to know the position of first numbernic value say between 0-9. I tried like this but this is not giving me right answer. SELECT...

<p>Hi i have an column say <b>Codes</b> and Codes has value like</p> <p>Codes</p> <p>ajsfh 10x2 </p> <p>dhjgh 37x8</p> <p> </p> <p>and something like this i want to know the position of first numbernic value say between 0-9. I tried like this but...

<p>Thank you very mch. This one is really helpful.</p>...

Hi guys.. Is there a way to find the client's ip address in a stored procedure? I want to fetch the ip address of the client from a store procedure. Is there any way around? ...