Answer Posted / tp
select * from table1 where date between dateadd(yy,-
5,getdate()) and getdate()
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Equi join and non equi join is possible with sql server?
What is a view in sql?
What is in place upgrade in sql server?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
Why should you use or avoid select * statements?
what is the difference between openrowset and openquery?
Disadvantages of the indexes?
Why use identity in sql server?
What is clustered index
What is sql server query analyzer?
What is temporary table in sql server? Why we use temp table?
Why and when do stored procedure recompile?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What is the difference between upgrade and migration in sql server?
what is spatial nonclustered index
