<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>...

<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...

<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>...

<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>Hi guys..</p> <p>Is there a way to find the client's ip address in a stored procedure?</p> <p>I want to fetch the ip address of the client from a store procedure. Is there any way around?</p>...

<p>Hi all ..</p> <p>i want to get row count of all tables in my database along wait table name in table format. How to achieve this.Do i have to write a cursor or some thing like that for this.</p>...

<p>I want to export my data from SQL to excel.</p> <p>I fetch my data through sql query and save results to an excel file always in this query itself.</p> <p>So help me out in this guys.</p>...

<p>Hi i always worked with php and my sql.</p> <p>I just want to know is there any in-built functions for get day number of the year like today is 54  day of the year i am not able to find any this kind of in built function but i want to acheive this...