|
|
-
Patrick Lambin Commented 11 Months ago through Just Learned | 1 Point
Instead SELECT $IDENTITY FROM Companies , i would use
SELECT $IDENTITY.Companies
( only because i am a little lazy )
Anyway, thanks to permit me to recall this tip...
|
-
Patrick Lambin Commented 11 Months ago through Just Learned | 1 Point
Instead SELECT $IDENTITY FROM Companies , i would use
SELECT $IDENTITY.Companies
( only because i am a little lazy )
Anyway, thanks to permit me to recall this tip...
|
-
Patrick Lambin Liked 11 Months ago through Just Learned | 1 Point
"SQL Authority" Pinal Sir published a tip about $rowguid, which can be used to fetch uniqueidentifier column from a table. It was awesome. You can find the link below.
[SQL SERVER – Identifying Column Data Type of uniqueidentifier without Querying S...
|
-
Patrick Lambin forgotten 11 Months ago through Just Learned | 1 Point
"SQL Authority" Pinal Sir published a tip about $rowguid, which can be used to fetch uniqueidentifier column from a table. It was awesome. You can find the link below.
[SQL SERVER – Identifying Column Data Type of uniqueidentifier without Querying S...
|
-
Patrick Lambin Liked 11 Months ago through Just Learned | 1 Point
"SQL Authority" Pinal Sir published a tip about $rowguid, which can be used to fetch uniqueidentifier column from a table. It was awesome. You can find the link below.
[SQL SERVER – Identifying Column Data Type of uniqueidentifier without Querying S...
|
-
Patrick Lambin forgotten 11 Months ago through Just Learned | 1 Point
"SQL Authority" Pinal Sir published a tip about $rowguid, which can be used to fetch uniqueidentifier column from a table. It was awesome. You can find the link below.
[SQL SERVER – Identifying Column Data Type of uniqueidentifier without Querying S...
|
-
Patrick Lambin Liked 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 Liked 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...
|