|
|
-
abhIShek BandI Liked 6 Months ago through Just Learned | 1 Point
There are 2 Set Options available to only parse the SQL Statements.
> 1.
SET PARSEONLY ON;
GO
SELECT * FROM TableName;
GO
SET PARSEONLY OFF;
GO
> 1.
SET NOEXEC ON;
GO
SELECT * FROM TableName;
GO
SET NOEXEC OFF
> 1. Option only give schema of T...
|
-
abhIShek BandI knew 6 Months ago through Just Learned | 1 Point
There are 2 Set Options available to only parse the SQL Statements.
> 1.
SET PARSEONLY ON;
GO
SELECT * FROM TableName;
GO
SET PARSEONLY OFF;
GO
> 1.
SET NOEXEC ON;
GO
SELECT * FROM TableName;
GO
SET NOEXEC OFF
> 1. Option only give schema of T...
|
-
abhIShek BandI Liked 7 Months ago through Just Learned | 1 Point
Today my colleague came up with a problem that he were not able to restore database having error like follows.
Restore failed for Server ''. (Microsoft.SqlServer.Smo) System.Data.SqlClient.SqlError: The file "D:\Db.mdf" is compressed bu...
|
-
abhIShek BandI Learned 7 Months ago through Just Learned | 1 Point
Today my colleague came up with a problem that he were not able to restore database having error like follows.
Restore failed for Server ''. (Microsoft.SqlServer.Smo) System.Data.SqlClient.SqlError: The file "D:\Db.mdf" is compressed bu...
|
-
abhIShek BandI Liked 8 Months ago through Just Learned | 1 Point
I just learnt that, we can access environment variables simply by typing "%VariableName%" in "Run Window" (Win + R). Most of you might have used "%temp%" in your run window to reach the temp folder on your computer and that "temp" actually refers to ...
|
-
abhIShek BandI Learned 8 Months ago through Just Learned | 1 Point
I just learnt that, we can access environment variables simply by typing "%VariableName%" in "Run Window" (Win + R). Most of you might have used "%temp%" in your run window to reach the temp folder on your computer and that "temp" actually refers to ...
|
-
abhIShek BandI Liked 8 Months ago through Just Learned | 1 Point
It is not possible to create the VIEW in another database directly - unlike CREATE TABLE, CREATE VIEW statement doesn't have a "database_name" - part in its syntax. But you can do it by calling sp\_executesql stored procedure:
DECLARE @s nvarc...
|
-
abhIShek BandI Learned 8 Months ago through Just Learned | 1 Point
It is not possible to create the VIEW in another database directly - unlike CREATE TABLE, CREATE VIEW statement doesn't have a "database_name" - part in its syntax. But you can do it by calling sp\_executesql stored procedure:
DECLARE @s nvarc...
|
-
abhIShek BandI Liked 8 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 ...
|
-
abhIShek BandI knew 8 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 ...
|