|
|
-
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 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 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 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 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 Liked 11 Months ago through Just Learned | 1 Point
In earlier versions of Reporting Services running in native mode, SQL Server 2005 Report Builder could be started using the following URLS:
Full trust :- http:///reportserver/reportbuilder/reportbuilder.application
Partial trust :- ...
|
-
MrsConnieOI Liked 11 Months ago through Just Learned | 1 Point
In earlier versions of Reporting Services running in native mode, SQL Server 2005 Report Builder could be started using the following URLS:
Full trust :- http:///reportserver/reportbuilder/reportbuilder.application
Partial trust :- ...
|
-
MrsConnieOI 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]
...
|
-
MrsConnieOI 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]
...
|
-
MrsConnieOI Liked 11 Months ago through Just Learned | 1 Point
Do you know we can get the definition of all the database programmable objects using a single query only?
You can get the definition of procedure, view, trigger and function using following query:
[code]
SELECT OBJECT_NAME(object_id),
def...
|