|
|
-
Jan Novak Liked 1 Years ago through Just Learned | 1 Point
I have been working on creating my demo scripts for "Tech-ED India 2012" and while trying different options, realized that the FORMAT function can be (mis)used to embed external strings into the format specification.
PRINT FORMAT( GETDATE(), ...
|
-
Jan Novak Liked 1 Years ago through Just Learned | 1 Point
I have been working on creating my demo scripts for "Tech-ED India 2012" and while trying different options, realized that the FORMAT function can be (mis)used to embed external strings into the format specification.
PRINT FORMAT( GETDATE(), ...
|
-
Jan Novak Learned 1 Years ago through Just Learned | 1 Point
I have been working on creating my demo scripts for "Tech-ED India 2012" and while trying different options, realized that the FORMAT function can be (mis)used to embed external strings into the format specification.
PRINT FORMAT( GETDATE(), ...
|
-
Jan Novak Learned 1 Years ago through Just Learned | 1 Point
I have been working on creating my demo scripts for "Tech-ED India 2012" and while trying different options, realized that the FORMAT function can be (mis)used to embed external strings into the format specification.
PRINT FORMAT( GETDATE(), ...
|
-
Jan Novak Liked 1 Years ago through Just Learned | 1 Point
I have always heard about the terms sargable and non-sargable but never really understood how they help in developing efficient sql code. Here is what I have found out...
Try to avoid WHERE clauses that are non-sargable. The term “sargable” (which i...
|
-
Jan Novak Liked 1 Years ago through Just Learned | 1 Point
I have always heard about the terms sargable and non-sargable but never really understood how they help in developing efficient sql code. Here is what I have found out...
Try to avoid WHERE clauses that are non-sargable. The term “sargable” (which i...
|
-
Jan Novak Liked 2 Years ago through Just Learned | 1 Point
While dropping a table present in a different database, you can use the fully qualified Table Name ("DatabaseName.SchemaName.TableName" format) and drop the table as shown below.
[code]
DROP TABLE AdventureWorks.HumanResources.Department
GO
[/code...
|
-
Jan Novak Liked 2 Years ago through Just Learned | 1 Point
While dropping a table present in a different database, you can use the fully qualified Table Name ("DatabaseName.SchemaName.TableName" format) and drop the table as shown below.
[code]
DROP TABLE AdventureWorks.HumanResources.Department
GO
[/code...
|
-
Jan Novak Learned 2 Years ago through Just Learned | 1 Point
While dropping a table present in a different database, you can use the fully qualified Table Name ("DatabaseName.SchemaName.TableName" format) and drop the table as shown below.
[code]
DROP TABLE AdventureWorks.HumanResources.Department
GO
[/code...
|
-
Jan Novak Learned 2 Years ago through Just Learned | 1 Point
While dropping a table present in a different database, you can use the fully qualified Table Name ("DatabaseName.SchemaName.TableName" format) and drop the table as shown below.
[code]
DROP TABLE AdventureWorks.HumanResources.Department
GO
[/code...
|