Can I get only date without time.
example:- 2007-03-21 14:33:22.670
I must get only 2007-03-21
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...
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...
a. Id - Unique Identifier
b. Active - bool
c. TransactionNumber - Integer
d. CreatedBy - varchar (20)
e. CreatedOn - DateTime
I have a table "Data_Record_Address" with three address type ids.
1. Shipper Address
2. Consignee Address
3. Bill To Address...
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...
I've got 3 respective stored procedures SP1, SP2 and SP3.
I have used the Serializable transaction in each stored procedure.
Now, SP1 calls...
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"...
I have got one table "Table1" with 58 fields. There are two columns "FileID" and "FileDataID". "FileDataID" is unique and it is primary key....
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...
When I am executing my stored procedure like
exec usp_KPIGetGraphData 311, null, '11/1/2003', '11/30/2003', 10
Its giving the...
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...
I am writing a procedure to retrieve a record from the table by passing record position.
The procedure should take record number as a...
I have 10 functions located in DatabaseI. I need to copy those functions in other database called databaseII. How to copy those functions...
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...
Can I call a udf_Function into another udf_Function.
If so, plz provide one example to me.
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
with system date
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.