How can you compare two tables -- say, table A and table B and determine if their content is the same? Assuming that A and B have same structure, here's how:First, from set theory, recall that: If ((|A| = |B|) && |A U B| = |A|)) ====>>> A = B |A| = NUMBER of rows […]
2002-08-07
1,470 reads
this scripts presents the way to retrieve from a given result set the values given n where n determines that the Nth value,2N th values , 3Nth value will be returnedin the example n = 3 the returning rows are 22,32,42the given set is 20,21,22,30,31,32,40,41,42
2002-08-01
433 reads
This script is used to extract from a temprary table with long string all elements in an array formatlength of 15 chars is assumed.
2002-08-01
615 reads
Using a Having clause I eliminate getting the EVEN rows and getting ovly the odd primary keysBy using Having (count(*) %2) = 0 I will get the even and not the odd.
2002-07-20
290 reads
a Basic Example of how to use TEXTPTR and updatetext in T-SQL to MANIPULATE text columns
2002-07-18
900 reads
a Basic example of how to manipulate an IDENTITY COLUMN AN HOW TO STOP the automatic counting using SET IDETNTITY_INSERT
2002-07-18
698 reads
procedure is an extended xp called xp_getNetName to get the computer network identifcation name
2002-07-18
764 reads
a Procedure to get the SQL sid for a Login either SQL standard or WINDOWS authenticated
2002-07-18
995 reads
there are 2 extended STORED PROCEDURES xp_dirtree will get the directory name and nesting level from a given parameter root directory xp_subdirs will get the directories list in the first sub level from a given parameter root directory
2002-07-18
871 reads
THERE is an extended sp called xp_fileexists given a full path to a file Name information is a 3 Bit vector 0/1 if a file doesn't/does exist0/1 is given name is a directory0/1 if the parent directory exists
2002-07-18
1,077 reads
Try this step-by-step guide to build and deploy a scalable serverless app that’s accessible...
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
By Steve Jones
The more I work with the Data API Builder (DAB), the more I lean...
Comments posted to this topic are about the item Vector DB implementation using FAISS
Comments posted to this topic are about the item The Types of Changes
Comments posted to this topic are about the item Escaping Like I
I have this data in a SQL Server 2022 table:
PlayerIDPlayerNamePlayerStatus 1The \%ChampActive 2The ChampActive 3The_ChampionActive 4The__ChampionActive 5The\_ChampActiveHow many rows are returned by this code in SQL Server 2022?
select PlayerName from player where playername like 'The\_C%' escape '\'See possible answers