|
|
-
Patrick Lambin knew 10 Months ago through Just Learned | 1 Point
create table #temp
(
a varchar(10)
)
insert into #temp values(' a ')
select COUNT(*) from #temp where a=' a'
select COUNT(*) from #temp where a='a'
first query will return 1
2nd will return 0 as sql ...
|
-
Patrick Lambin knew 10 Months ago through Just Learned | 1 Point
create table #temp
(
a varchar(10)
)
insert into #temp values(' a ')
select COUNT(*) from #temp where a=' a'
select COUNT(*) from #temp where a='a'
first query will return 1
2nd will return 0 as sql ...
|
-
Patrick Lambin knew 12 Months ago through Just Learned | 1 Point
I just learn from [Nakul''s Blog][1] That sp_dboption store procedure is “discontinued” SQl Server 2012
Replacement is the ALTER DATABASE statement, for existing sp_dboption
ALTER DATABASE TestDB SET READ_ONLY
Thank You
[1]: http://beyo...
|
-
Patrick Lambin knew 12 Months ago through Just Learned | 1 Point
I just learn from [Nakul''s Blog][1] That sp_dboption store procedure is “discontinued” SQl Server 2012
Replacement is the ALTER DATABASE statement, for existing sp_dboption
ALTER DATABASE TestDB SET READ_ONLY
Thank You
[1]: http://beyo...
|
-
Patrick Lambin knew 12 Months ago through Just Learned | 1 Point
With help of below query we can quickly find the node on which sql is currently running. This is useful in clustered environments.
Select serverproperty('ComputerNamePhysicalNetBIOS')...
|
-
Patrick Lambin knew 12 Months ago through Just Learned | 1 Point
With help of below query we can quickly find the node on which sql is currently running. This is useful in clustered environments.
Select serverproperty('ComputerNamePhysicalNetBIOS')...
|
|
|
|
|
-
Patrick Lambin knew 12 Months ago through Just Learned | 1 Point
I learned about this from Pinal Dave's blog(You can see the original article in references.)
In SQL Server, while creating a table, we can give maximum length of 128 characters. However, while creating temp tables, maximum length can be of 116 chara...
|
-
Patrick Lambin knew 12 Months ago through Just Learned | 1 Point
I learned about this from Pinal Dave's blog(You can see the original article in references.)
In SQL Server, while creating a table, we can give maximum length of 128 characters. However, while creating temp tables, maximum length can be of 116 chara...
|