Skip to main content

Posts

Showing posts with the label SQL

Featured post

XM Cloud content sync from prod to uat or UAT to prod step by step

When working with Sitecore, it’s common to need content synchronization across environments. Today, I’ll walk you through the steps to sync content from Production to UAT/TEST and vice versa. Steps to Follow 1. Set Up Your Workspace Create a folder on your computer where you will manage the script files and exported data. Open the folder path in PowerShell to begin scripting. We need to run some scripts in PowerShell to update the folder with the basic requirements for syncing content. PS C:\Soft\ContentSync> dotnet new tool-manifest PS C:\Soft\ContentSync> dotnet nuget add source -n Sitecore https://nuget.sitecore.com/resources/v3/index.json PS C:\Soft\ContentSync> dotnet tool install Sitecore.CLI PS C:\Soft\ContentSync> dotnet sitecore cloud login If the above error occurs, you will need to run a different command to resolve the issue. PS C:\Soft\ContentSync> dotnet sitecore init now, Again run above command to open and authenticate with XM Cloud. It will be there a...
Post a Comment
Read more

How to do partition of table in sql server

CREATE PARTITION FUNCTION myDateRangePF (datetime) AS RANGE RIGHT FOR VALUES ('20110101', '20120101','20130101') GO CREATE PARTITION SCHEME myPartitionScheme AS PARTITION myDateRangePF ALL TO ([PRIMARY]) ALTER TABLE dbo.TABLE1 DROP CONSTRAINT PK_TABLE1 GO ALTER TABLE dbo.TABLE1 ADD CONSTRAINT PK_TABLE1 PRIMARY KEY NONCLUSTERED   (pkcol)    WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,          ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO CREATE CLUSTERED INDEX IX_TABLE1_partitioncol ON dbo.TABLE1 (partitioncol)   WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,         ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)   ON myPartitionScheme(partitioncol)
Post a Comment
Read more

How to get last identity value after inserted in table of sql server ? or How to use scope identity in sql server ?

SCOPE_IDENTITY in sql server It returns the last identity value which is just   inserted into an identity column. It returns value only if it in same scope. using (var conn = new SqlConnection(ConnectionString)) {     int ID;     var cmd = "INSERT INTO foo (column_name)VALUES (@data);SELECT CAST(scope_identity() AS int)";     using (var insertCom = new SqlCommand(cmd, conn)) {         insertCom.Parameters.AddWithValue("@data", "Shashi Keshar");         conn.Open();         ID = (int)insertCom.ExecuteScalar();     } }
Post a Comment
Read more

How to separate data from comma format in stored procedure

Here, You may learn to separate data which is in the form of  comma . If you have data in comma format and want to insert all data separately the follow the below technique. Suppose you have data Example @pid="12,13,15,16,14" @amount="123,435,543,344,343" if want's to get separate and insert one by one in database then use the below code here, I have separated @pid and @amount. CREATE proc [dbo].[usp_setvendorkkshre] ( @vid int=0, @pid varchar(max)='', @amount varchar(max)='', @intResult int out ) as begin transaction declare @slicepid varchar(100),@sliceamount varchar(500),@index int=1,@index1 int=1 set @intResult=1 while @index<>0 and @index1<>0 begin SELECT @index = CHARINDEX(',',@pid) SELECT @index1 = CHARINDEX(',',@amount) IF @index<>0 and @index1<>0 ...
Post a Comment
Read more