|
|
-
Latheesh NK Answered 1 Years ago through Quizzes
Views allow you to create a virtual table by defining a query against one or more tables. With a standard view, the result is not stored in the database. Instead, the result set is determined at the time a query utilizing that view is executed. Creating...
|
-
Latheesh NK Answered 1 Years ago through Quizzes
A collation specifies the bit patterns that represent each character in a data set. Collations also determine the rules that sort and compare data. SQL Server supports storing objects with different collations in a single database. For non-Unicode colum...
|
-
Latheesh NK Answered 1 Years ago through Quizzes
A collation specifies the bit patterns that represent each character in a data set. Collations also determine the rules that sort and compare data. SQL Server supports storing objects with different collations in a single database. For non-Unicode colum...
|
-
Latheesh NK Answered 1 Years ago through Quizzes
The following are the locking modes in SQL server 2008 R1
Shared (S):
Used for read operations that do not change or update data, such as a SELECT statement.
Update (U):
Used on resources that can be updated. Prevents a common form of deadloc...
|
-
Latheesh NK Answered 1 Years ago through Quizzes
<pre class='brush: plain'>
--Method: 1 (Sargable) (Most preferrable to me)
SELECT *
FROM T11
WHERE name LIKE '[A-J]%'
--Method 2:(Sargable)
Select * From T11 Where name like 'A%' Or
name like 'B%' Or
name like 'C%' Or
name like 'D%' Or
na...
|
-
Latheesh NK Commented 1 Years ago through Blogs
Thanks for your comment. I will add this to my favourites for sure!!!...
|
|
|
-
Latheesh NK Answered 1 Years ago through Quizzes
**What is an IDENTITY Value?**
Identity value is an auto number value column on a table. Identity property depends on its increment factor whether its an incremental value or decremental value. It has a seed to start a number with.
**What are the d...
|
-
Latheesh NK Posted 1 Years ago through Blogs
This post is really inspired by Nakul's wonderful post: http://beyondrelational.com/blogs/nakul/archive/2011/12/29/sql-server-t-sql-different-ways-to-generate-a-comma-separated-string-from-a-table.aspx...
|
-
Latheesh NK Posted 1 Years ago through Syndicated Blogs
This post is really inspired by Nakul's wonderful post: http://beyondrelational.com/blogs/nakul/archive/2011/12/29/sql-server-t-sql-different-ways-to-generate-a-comma-separated-string-from-a-table.aspx
However, Whenever I faced a situation to concatena...
|