|
|
-
kingkong0924 Liked 11 Months ago through Just Learned | 1 Point
I recently saw the following code:
IF EXISTS (SELECT * FROM sys.objects
WHERE object_id = OBJECT_ID(N'[dbo].[TableName]')
AND type in (N'U'))
DROP TABLE [dbo].[TableName];
However, this is more complicated than needed. You can j...
|
-
kingkong0924 Learned 11 Months ago through Just Learned | 1 Point
I recently saw the following code:
IF EXISTS (SELECT * FROM sys.objects
WHERE object_id = OBJECT_ID(N'[dbo].[TableName]')
AND type in (N'U'))
DROP TABLE [dbo].[TableName];
However, this is more complicated than needed. You can j...
|
-
kingkong0924 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...
|
-
kingkong0924 Learned 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...
|
-
kingkong0924 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...
|
-
kingkong0924 Learned 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...
|
-
kingkong0924 Liked 11 Months ago through Just Learned | 1 Point
This will change the stored procedure from the username schema to the dbo schema
ALTER SCHEMA dbo TRANSFER [username].[usp_MyProcedure]
...
|
-
kingkong0924 Learned 11 Months ago through Just Learned | 1 Point
This will change the stored procedure from the username schema to the dbo schema
ALTER SCHEMA dbo TRANSFER [username].[usp_MyProcedure]
...
|
-
kingkong0924 Liked 11 Months ago through Just Learned | 1 Point
This will change the stored procedure from the username schema to the dbo schema
ALTER SCHEMA dbo TRANSFER [username].[usp_MyProcedure]
...
|
-
kingkong0924 Learned 11 Months ago through Just Learned | 1 Point
This will change the stored procedure from the username schema to the dbo schema
ALTER SCHEMA dbo TRANSFER [username].[usp_MyProcedure]
...
|