Database

rameez Raja wrote:

please write the few lines of query with simple example for understanding

SELECT DATEADD(hh,-1,GETDATE())
SELECT GETDATE()

SELECT DATEADD(hh,@HourToAdd,GETDATE()))

AlexeiXX3 wrote:

By the way, whats DR?

getutcdate()

<br />
getutcdate()<br />
Returns the datetime value that represents the current UTC time (Coordinated Universal Time or Greenwich Mean Time). The current UTC time is derived from the current local time and the time zone setting in the operating system of the computer on which the instance of Microsoft SQL Server is running.<br />

Create Table Mytable
(
U_ID int indentity(100,01) not null,
--you can continue with other fields.

)

SELECT count(*) as [count] FROM User_Submit
WHERE Type like 'System%'

declare @username as varchar(255)<br />
set @username = (select top 1 name from Admin where avilable = true order by  tickets asc)<br />
<br />
Insert into User_submit values (val1,val2,val3,...@username,nextval,...)

SELECT COUNT(*),
	UserName
FROM TicketTable
	INNER JOIN UserTable ON UserTable.UserID = TicketTable.UserID
		AND UserTable.OnLine <> 0
GROUP BY UserName
ORDER BY COUNT(*)

UPDATE TableX
SET ...
FROM TableX
INNER JOIN TableY
ON ...