DECLARE @StartTime DATETIME = '2011-09-23 15:00:00'
,@EndTime DATETIME = '2011-09-23 17:54:02'
SELECT CONVERT(VARCHAR(8), DATEADD(SECOND, DATEDIFF(SECOND,@StartTime, @EndTime),0), 108) as ElapsedTime
Subscribe to:
Post Comments (Atom)
-
Step 1. Create Table Like below. CREATE TABLE [dbo].[Suppliers]( [SupplierID] [int] IDENTITY(1,1) NOT NULL, [CompanyName] [nvarchar](... -
Step 1. Create Table Name "Employee" In Sql Server CREATE TABLE [dbo].[Employee]( [Id] [int] IDENTITY(1,1) NOT NULL, [Name]... -
Step 1 . Create table Pubs. CREATE TABLE [dbo].[stores]( [stor_id] [char](4) NOT NULL, [stor_name] [varchar](40) NULL, [stor_addres...
No comments:
Post a Comment