Видео

Not exact solution though but below code would give you the clue to solve these start patterns SET @maxlen := 5; WITH RECURSIVE cte AS ( SELECT @maxlen num UNION ALL SELECT num - 1 FROM cte WHERE num > 1 ) SELECT REPEAT('*', num) FROM cte

Hope this will give some clue with rws as ( select 'split,into,rows' str from dual ) select regexp_substr ( str, '[^,]+', 1, level ) value from rws connect by level <= length ( str ) - length ( replace ( str, ',' ) ) + 1; VALUE split into rows

Its applies on each row... even though there are duplicate rows, it will pick up each row and split the values based on delimiter

You're welcome 😊

Thanks

choose SQL server if you are importing to SQL server table

Thank you

It's worth sending an email to Microsoft team if they are providing any vouchers for the exam, also check if your email has any vouchers

@@sqlwithravimartha6357 Oh yes, thank you

Try using string_to_array(ColumnName, ',')

Below code would give clue to solve these star patterns SET @maxlen := 5; WITH RECURSIVE cte AS ( SELECT @maxlen num UNION ALL SELECT num - 1 FROM cte WHERE num > 1 ) SELECT REPEAT('*', num) FROM cte

Its better to do certification based on your future plans in terms of upskilling. DP 203 requires good preparation as it covers various azure services. I am not sure difficulty level of AZ104 certification.

sure

yes, Thanks for pointing it out. I didn't have a different server or a different instance on my machine... except choosing the target server name rest all same. I have mentioned the same thing the video as well.

You're welcome 😊

Be sure to reschedule or cancel exam appointments at least 24 hours before your scheduled exam or your fee will be forfeited

Its always advisable to go through concepts and attempt the exam. However if you google search there are few websites which would give similar questions which are asked in the exam.

sure

sure

plaese help thanks

Please post me the snippet and the query to check the error?

You can directly Importing table with constraints, however those constraints will not be creating in destination table. If you want to have the same table structure as source then while importing go to Edit Mapping and Edit SQL and define the destination table with constraints same as source table. Attached snippet for the same in my blog link. Hope that helps. sqlwithravimartha.blogspot.com/2020/07/importing-tables-from-one-server-to.html

NPR to EUR is not yet available on wise platform. will let you know when it is available.

One easy way to use REPLACE() function twice one for [ and one for ].

Hi, Thanks for your comment. I have pinned the solution as the first comment, please refer and let me know if you still need help.

@@sqlwithravimartha6357 you have solution for that pls share

@@hanumegowdabh6268 You can create a function as below if you are using older version of MS SQL Server and call the function to split: CREATE OR ALTER FUNCTION [dbo].[udf_String_Split] (@StringtoSplit VARCHAR(8000)) RETURNS @ReturnTable TABLE (columname [nvarchar] (1000)) AS BEGIN DECLARE @SubString NVARCHAR(255) DECLARE @Index INT WHILE CHARINDEX(',',@StringtoSplit) > 0 BEGIN SELECT @Index = CHARINDEX(',', @StringtoSplit) SELECT @SubString = SUBSTRING(@StringtoSplit,1,@Index-1) INSERT INTO @ReturnTable SELECT @SubString SELECT @StringtoSplit = SUBSTRING(@StringtoSplit, @Index+1, LEN(@StringtoSplit)-@Index) END INSERT INTO @ReturnTable SELECT @StringtoSplit RETURN END ---------------------------- Explanation: 1. Here we are passing the column name which needs to split as a parameter. 2. Using the While loop, we identify the first position of delimiter and split the first substring and insert it to the return table. 3. Reset the Original String to the updated string excluding the first substring which we have written to the return table. 4. Will loop through the entire string and add those substring to the return table (table variable) 5. once we exist the While loop the String which needs to split will have just the last substring 6. That will be inserted to the return table after exiting the while loop. by which, all the substrings with delimiter will be loaded to Return table. Quick Check: SELECT * FROM dbo.[udf_String_Split] ('1,2,3,4,5')

yes, you can use this to concatenating rows with specified delimiter / seperator.

You are welcome!

Hi Vivek, I have provided the link in the description. Hope this info helps you. All the best! Here is the link: www.istqb.org/certifications/certified-tester-foundation-level Click download on the first pdf link on the right side with name: CTFL Syllabus 2018 v3.1.1

Glad you liked it

Yes, we can use window function as well. Just tried to explain one method in each video.

Pretty much similar, select the records from the table where id >= 18610 and id <= 19019 and generate the sequence starting from 18610 and do a left join.