SELECT GETDATE() CurrentTime; WAITFOR DELAY '00:00:10' 10 Second Delay SELECT GETDATE() CurrentTime;
WAITFOR DELAY '10:30';
Select Replace(Replace(Replace(@str,' ','{}'),'}{',''),'{}',' '); DECLARE @str varchar(150) SET @str='Hello Welcome to dot net funda . com' Select Replace(Replace(Replace(@str,' ','{}'),'}{',''),'{}',' ')
exec xp_cmdshell 'dir c:\*.exe'
select parsename(replace(isnull('vishal kumar',''),' ','.'),1);
select parsename(replace(isnull('vishal kumar',''),' ','.'),2);
Select * From sys.Tables;
Select * From Information_Schema.Tables;
select count(*) from information_schema.tables where table_type = 'base table';
WITH temp_Table as ( SELECT ROW_NUMBER() Over(PARTITION BY FirstName,LastName,PAN_No ORDER BY FirstName) As RowNumber,* FROM Employee_Master; ) DELETE FROM temp_Table where RowNumber >1; SELECT * FROM Employee_Master order by FirstName asc;
SELECT * FROM Employee_Master Group By PAN_No Having Count(Pan_No) >1;