Przełącznik języka
Tools
Mining
Security
CMS
Hardware
Backup
Windows Server
Databases
Emulators
Powershell
Storage Array
Active Directory
SEO
MSSQL
Antivirus program
Linux
Licznik
Visitor Info
- IP: 10.3.190.67
- Browser: Unknown
- Browser Version:
- Operating System: Unknown
Who Is Online
7
Online
Viernes, 03 Abril 2026 21:22
Wildcard Characters in SQL Server
Wildcard Characters in SQL Server
| Symbol | Description | Example |
|---|---|---|
| % | Represents zero or more characters | bl% finds bl, black, blue, and blob |
| _ | Represents a single character | h_t finds hot, hat, and hit |
| [] | Represents any single character within the brackets | h[oa]t finds hot and hat, but not hit |
| ^ | Represents any character not in the brackets | h[^oa]t finds hit, but not hot and hat |
| - | Represents a range of characters | c[a-b]t finds cat and cbt |
Here are some examples showing different LIKE operators with '%' and '_' wildcards:
| LIKE Operator | Description |
|---|---|
| WHERE CustomerName LIKE 'a%' | Finds any values that starts with "a" |
| WHERE CustomerName LIKE '%a' | Finds any values that ends with "a" |
| WHERE CustomerName LIKE '%or%' | Finds any values that have "or" in any position |
| WHERE CustomerName LIKE '_r%' | Finds any values that have "r" in the second position |
| WHERE CustomerName LIKE 'a__%' | Finds any values that starts with "a" and are at least 3 characters in length |
| WHERE ContactName LIKE 'a%o' | Finds any values that starts with "a" and ends with "o" |
select name from sys.servers -- > Lists the linked server
Lists the linked server
select name from sys.servers -- > Lists the linked server
How to View SQL Server Database Size and File Locations
How to View SQL Server Database Size and File Locations
SELECT
--database ID
mdf.database_id,
--database name
mdf.name,
--database file location
mdf.physical_name as data_file,
ldf.physical_name as log_file,
db_size_MB = CAST((mdf.size * 8.0)/1024 AS DECIMAL(8,2)),
log_size = CAST((ldf.size * 8.0 / 1024) AS DECIMAL(8,2))
FROM (SELECT * FROM sys.master_files WHERE type_desc = 'ROWS' ) mdf
JOIN (SELECT * FROM sys.master_files WHERE type_desc = 'LOG' ) ldf
ON mdf.database_id = ldf.database_id
--sort DESC or ASC
order by db_size_MB DESC
Najlepsze górnicze GPU 2021
Najlepsze górnicze GPU 2021
1.MSI Gaming GeForce RTX 2070
SPECYFIKACJE
Zegar rdzenia: 1620MHzMemory
Pamięć: 8 GB GDDR6
Zegar pamięci: 14 Gb/s
Złącza zasilania: 6 pin + 8 pin
Pobierana Moc: 225W
Wyjścia: DisplayPort x 3 (v1. 4) / HDMI 2. 0b x 1
2. Nvidia GeForce RTX 2080 Ti
SPECYFIKACJE
Zegar rdzenia: 1350MHz
Pamięć: 11 GB GDDR6
Zegar pamięci: 14 Gb/s
Power Connectors: 8 pin + 8 pin
Power Draw: 260W
Wyjścia: DisplayPort, HDMI, USB typu C
3.MSI Gaming GeForce GTX 1080 Ti
SPECYFIKACJE
Core Clock: 1481MHz
Pamięć: 11 GB GDDR5X
Memory Clock: 11 Gbps
Złącza zasilania: jeden 6-pinowy, jeden 8-pinowy
Power Draw: 250W
Wyjścia: DisplayPort x 2 / HDMI x 2/ DL-DVI-D
4. ASUS ROG Strix AMD Radeon RX 5700XT
SPECYFIKACJE
Zegar rdzenia: 1605 MHz
Pamięć: 8 GB GDDR6
Zegar pamięci: 14 Gb/s
Złącza zasilania: 1 x 8-pin, 1 x 6-pin
Pobierana Moc: 225W
Wyjścia: 1.4 z DSC DisplayPort, HDMI z obsługą 4K60
5. Karta graficzna FX AMD Radeon RX 580 GTS XXX Edition
Core Clock: 1386 MHz
Pamięć: 8 GB GDDR5
Zegar pamięci: 14 Gb/s
Złącza zasilania: 1 x 8-pin, 1 x 6-pin
Power Draw: 150W
Wyjścia: 3x DisplayPort, 1x HDMI, 1x DVI-D