|
|
-
Paul Hutagalung Learned 7 Months ago through Just Learned
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 ...
|
-
Paul Hutagalung Liked 7 Months ago through Just Learned
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 ...
|
|
|
-
Paul Hutagalung Learned 11 Months ago through Just Learned
This will change the stored procedure from the username schema to the dbo schema
ALTER SCHEMA dbo TRANSFER [username].[usp_MyProcedure]
...
|
-
Paul Hutagalung Liked 11 Months ago through Just Learned
This will change the stored procedure from the username schema to the dbo schema
ALTER SCHEMA dbo TRANSFER [username].[usp_MyProcedure]
...
|
-
Paul Hutagalung Learned 11 Months ago through Just Learned
This will change the stored procedure from the username schema to the dbo schema
ALTER SCHEMA dbo TRANSFER [username].[usp_MyProcedure]
...
|
-
Paul Hutagalung Liked 11 Months ago through Just Learned
This will change the stored procedure from the username schema to the dbo schema
ALTER SCHEMA dbo TRANSFER [username].[usp_MyProcedure]
...
|
-
Paul Hutagalung Liked 1 Years ago through Pages
We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...
|
-
Paul Hutagalung Liked 1 Years ago through Blogs
Did you know that table variables are stored in the tempdb database for execution scope only?. Ok. Let us run this code
declare @t table(i int)
select * from tempdb.INFORMATION_SCHEMA.TABLES
The result is
TABLE_CATALOG TABLE_SCHEMA TA...
|
-
Paul Hutagalung learned 1 Years ago through Blogs
Did you know that table variables are stored in the tempdb database for execution scope only?. Ok. Let us run this code
declare @t table(i int)
select * from tempdb.INFORMATION_SCHEMA.TABLES
The result is
TABLE_CATALOG TABLE_SCHEMA TA...
|