|
|
-
MrsConnieOI Liked 7 Months ago through Just Learned | 1 Point
Hello friends, one interviewer asked that suppose you have two tables
`Employee_Details`, `Employee_Details_History`
now I want to delete original table `Employee_details` and maintain it’s history to other table.
How can it’s possible with only ...
|
-
MrsConnieOI Learned 7 Months ago through Just Learned | 1 Point
Hello friends, one interviewer asked that suppose you have two tables
`Employee_Details`, `Employee_Details_History`
now I want to delete original table `Employee_details` and maintain it’s history to other table.
How can it’s possible with only ...
|
-
MrsConnieOI Liked 9 Months ago through Just Learned | 1 Point
In SQL Server 2008, We have a feature to select multiple lines with specific characters.
In SQL Server 2012, we can append the same text to multiple lines.
Below images will give the clear picture to understand this feature.
Some times we need to ad...
|
-
MrsConnieOI Learned 9 Months ago through Just Learned | 1 Point
In SQL Server 2008, We have a feature to select multiple lines with specific characters.
In SQL Server 2012, we can append the same text to multiple lines.
Below images will give the clear picture to understand this feature.
Some times we need to ad...
|
-
MrsConnieOI Liked 9 Months ago through Just Learned | 1 Point
In SQL Server 2008, We have a feature to select multiple lines with specific characters.
In SQL Server 2012, we can append the same text to multiple lines.
Below images will give the clear picture to understand this feature.
Some times we need to ad...
|
-
MrsConnieOI Learned 9 Months ago through Just Learned | 1 Point
In SQL Server 2008, We have a feature to select multiple lines with specific characters.
In SQL Server 2012, we can append the same text to multiple lines.
Below images will give the clear picture to understand this feature.
Some times we need to ad...
|
-
MrsConnieOI 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...
|
-
MrsConnieOI 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...
|
-
MrsConnieOI 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...
|
-
MrsConnieOI 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...
|