Pages

SQL
Hot In It
Money
Blogging Tips
Asp.Net
About Me

My Blog List

hotinit.com. Powered by Blogger.

Search This Blog

skip to main | skip to sidebar

Tips for Sql

A Blog about Sql Server 2008.Easy to understand Sql Server Tips and Tutorials for beginners and useful sql server knowledge information for database developers.

Online Support

Click Here For Free Online Chat

Round Off Time

Tuesday, 14 June 2011

Select CAST(DATEADD(mi,(DATEPART(mi,DATEADD(mi,1,GETDATE()))/10)*10,DATEADD(hh,DATEDIFF(hh,0,DATEADD(mi,1,Getdate())),0)) as Time)

Posted by Madhu at 00:30

Email This BlogThis!Share to X Share to Facebook

Labels: round off time

No comments:

Post a Comment

Newer Post Older Post Home

Subscribe to: Post Comments (Atom)

Popular Posts

Exe To Windows Service

How to convert an exe to a service? How to create user defined function in windows? How to create a PACS windows Service Using dc...
Check Column exists in table, if not, add

Check For a Column Exists In A Table If Not Add IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA . COLUMNS WHERE TABLE_NAME = ...
CharIndex

select charindex ( 'an' , 'madhsan' ) --output 6 select charindex ( 'an' , 'madhsan' , 1 ) ...
SQL OPTIMIZATION

OPTIMIZATION In Subquery Some of us will use a subquery within the IN operator such as this. SELECT * FROM TABLENAME WHERE COLUMN IN...
SQL SERVER - Insert from one table to another Table

In SQL Database , You can probably insert data from one table into another using two methods. 1. Insert Into - This is used when the tab...
All Linked Server Info

Select * From sysservers
Calling Stored Procedure From Command Prompt

@ECHO OFF set sqlserverinstance=192.168.1.2\sqlexpress set serverusername=sa set serverpassword=123 set DatabaseName=Madhan Sqlcm...
Dynamically generate connestion String Using Script Task IN SSIS

Dynamically generate connestion String Using Script Task (visual basic) Public Sub Main() Dts.Variables( "Destn" ).Value = ...
Pivot Example

BEGIN TRAN --Create the table CREATE TABLE #Pivot ( ColA nvarchar ( 500 ), ColB nvarchar ( 500 ), ...
Sql To Xml ( Create xml using sql select )

Example code for you select * from ( select 1 as id , 'one' as name union all select 2 as id , 't...

Labels

Blogger templates

Archives

► 2013 (4)
- ► February (3)
- ► January (1)

► 2012 (9)
- ► October (1)
- ► June (5)
- ► May (3)

▼ 2011 (71)
- ► December (2)
- ► October (1)
- ► September (3)
- ► August (23)
- ► July (3)
- ▼ June (30)
- ► May (9)

Blogger news

Blogroll

Most Reading

Check Column exists in table, if not, add

Check For a Column Exists In A Table If Not Add IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA . COLUMNS WHERE TABLE_NAME = ...
SSIS Connection String Format

Connection String is assigned to a variable in the below format Data Source=10.200.2.55;User ID=sa;Password =Welcome123;initial Catalog=Med...
Precision, Scale, and Length (Transact-SQL)

Precision is the number of digits in a number. Scale is the number of digits to the right of the decimal point in a number. For example,...
Exe To Windows Service

How to convert an exe to a service? How to create user defined function in windows? How to create a PACS windows Service Using dc...
Importing XML File to Sql Server Table

Here is the example on how to import an xml file in the sql server installed machine to sql server table . Steps to do this 1. Save the ...
Function to Parse AlphaNumeric Characters from String

CREATE FUNCTION dbo.UDF_ParseAlphaChars ( @string VARCHAR ( 8000 ) ) RETURNS VARCHAR ( 8000 ) AS BEGIN DECLARE @IncorrectCharLoc SMA...
SQL SERVER - Insert from one table to another Table

In SQL Database , You can probably insert data from one table into another using two methods. 1. Insert Into - This is used when the tab...
wait statistics -Dynamic Management Views

Select * from sys . dm_os_wait_stats Select * from sys . dm_os_waiting_tasks
Free Google Online Chat Support For Website and Blogs

Free Google Online Chat Support For Website and Blogs STEP1 Go to the following site and create a badge as shown in the Picture http://ww...
XML TO SQL SERVER

I f you’ve got some XML data in a SQL Server column, how can you flatten it out and query it or present it as though it was relational da...

Tags

Copyright © . Tips for Sql For Quickbooks Support Contact SupportCensor.Com

8.6/10