Answer - Question of the Week - 28/12/2013 - Question 2
Question:- Suppose we have a table named tbl_charactername have only one column say "charactername".It contains 10 rows. First 5 rows contains...
2014-01-01
593 reads
Question:- Suppose we have a table named tbl_charactername have only one column say "charactername".It contains 10 rows. First 5 rows contains...
2014-01-01
593 reads
In While loop, we set a condition for the repeated execution of a SQL Code block or a SQL Statement....
2014-01-01
22,825 reads
HAPPY NEWYEAR2014
Wishing all of the readers of this blog a very happy New Year. Thanks for supporting me and my...
2013-12-31
1,017 reads
Many times we caught in a situation where we have a table where there is no primary or unique column...
2013-12-29
59,379 reads
Question:- Suppose we have a table says tbl_students whose structure is given below:-
Create table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150))
Suppose it...
2013-12-28
758 reads
Question:- Suppose we have a table named tbl_charactername have only one column say "charactername".It contains 10 rows. First 5 rows...
2013-12-28
523 reads
Suppose we have a table says tbl_students whose structure is given below:-
Create table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150))
Suppose it contains...
2013-12-25
466 reads
Ranking Function:- Sometimes we need to provide a Row number to the rows in a table or within a partition....
2013-12-25
9,945 reads
Stuff function: - This function is used to replace string from the given start position, passed as 2nd argument with string...
2013-11-25
34,450 reads
Case Statement/ Expression in SQL server
Sometimes we need to get one result output from multiple possible outcomes based on the...
2013-11-25
1,780 reads
By Steve Jones
I think we might have forgotten this a bit, but on one of the...
By Brian Kelley
I refresh my test SQL Servers at least monthly with a fresh VM. Setting...
By Chris Yates
Embracing Total Responsibility In every organization there comes a moment when teams must choose...
Comments posted to this topic are about the item Change Tracking Default Retention
I am trying to create a subscription that posts to a one drive directory. ...
Comments posted to this topic are about the item What is Delayed Durability in...
I run this command on my SQL Server 2022 database:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON;What is the default data retention period? See possible answers