Hi All, Can I get only date without time. example:- 2007-03-21 14:33:22.670 I must get only 2007-03-21 thank you with regards aruna
Hi All, I have got huge number of rows (1,00,000) in the view. I want to get top 15 values when a click event done on the page number. For every...
Hi, How do I connect to different databases at the same time and retieve the data. There should not be any performance issue. Please provide the...
Hi All, User Table a. Id - Unique Identifier b. Active - bool c. TransactionNumber - Integer d. CreatedBy - varchar (20) e. CreatedOn - DateTime f....
Hi All, I have a table "Data_Record_Address" with three address type ids. 1. Shipper Address 2. Consignee Address 3. Bill To Address...
Hi All, I would like to know the data structure used for indexes. I mean to say that, what is the name of the data structure used for clustered...
Hi, I've got 3 respective stored procedures SP1, SP2 and SP3. I have used the Serializable transaction in each stored procedure. Now, SP1 calls...
Hi, I have written the following query in MySQL, its taking lot of time to retrieve the values. Please provide me the solution. The Table "lap_City"...
Hi All I have got one table "Table1" with 58 fields. There are two columns "FileID" and "FileDataID". "FileDataID" is unique and it is primary key....
Hi All, I want to know the total table size. Because, i need to insert hospital bill items in the table, it will be a huge data...so how can i...
Hi All, When I am executing my stored procedure like exec usp_KPIGetGraphData 311, null, '11/1/2003', '11/30/2003', 10 Its giving the...
Hi All, Can I Generate HTML Reports using SQL server 2000. Because I have seen in Oracle. It is generating HTML reports. Like that I want generate...
Hi All, I am writing a procedure to retrieve a record from the table by passing record position. The procedure should take record number as a...
Hi All, I have 10 functions located in DatabaseI. I need to copy those functions in other database called databaseII. How to copy those functions...
Hi All, When I am debugging a stored procedure through Visual studio.Net or with Sql Server 2000 For VS.Net I am getting, "User does not have...
Hello All, Can I call a udf_Function into another udf_Function. If so, plz provide one example to me. Thanku Aruna Mathew
I got a float value like 73.456002313456 after some calculation . But I need to have only two values after the decimal point. How to get that value?...
declare @temp datetime set @temp='2/18/2004' with system date With Regards Aruna Mathew
declare @Bdate datetime declare @d1 datetime set @Bdate = '14/12/2005' set @d1 = '20/12/2005' SELECT DATEDIFF(d, @Bdate, @d1) AS days, DATEDIFF(wk,...
I need to get the data by sending Page Number and size of the page from front end. For example:- PageNumber = 5 and page size is 10 rows per page....
Separate names with a comma.
