select dateadd(day, datediff(day, 0, getdate()), 0)
the result for above statement is 2007-03-21 00:00:00.000
the result should not give time values...
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...
Tell me if they are on the same server how do I retrieve the data.
They are on the different servers.
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...
Thank you for giving the code, But what should I write in "--Your Code" content.
Please provide me the answer.
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...
Do you know the answer?
Please give me the answer.
I didn't get you Mr.Adriaan.
Could you please ask again.
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"...
Table Name : FileData<br />Columns : FileDataID, FileID, Pro_Number, Invoice_Number, Customer_Reference1, <br />...
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...
Sql server 2000 service pack is 2 and i dont know what is hotfix level on SQL Server
Please provide answer to me
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...
Separate names with a comma.