15,796,333 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Python questions
View PHP questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
The default search term operator is
OR
for a simple list of search terms.
Any selected filters such as document type, tags, categories, etc. are ANDed to the query in the search box.
You can use brackets,
AND
,
OR
, and
NOT
to improve your search. For example:
C# AND NOT(VB or SQL)
A query of a single
*
will return everything, filtered by any filters.
Filter examples:
Search by Author
author:"author name"
Filter by tag
tag:C#
or
tag:(C++ or Java)
Wildcard search
use "?" or "*" eg.
gr?d
or
gr*
2,778 Results
Filters
Articles
Technical Blogs
Tips & Tricks
Reference Articles
Projects
Assets
Questions
Answers
Forum Messages
News Items
Just My Stuff
My Bookmarks
Sort by
Relevance
Rating (Hi - Lo)
Rating (Lo - Hi)
Popularity (Hi - Lo)
Popularity (Lo - Hi)
Votes (Hi - Lo)
Votes (Lo - Hi)
Modified (New - Old)
Modified (Old - New)
Thread Modified (New - Old)
Thread Modified (Old - New)
Created (New - Old)
Created (Old - New)
Title (A - Z)
Title (Z - A)
Author (A - Z)
Author (Z - A)
Match
All Fields
Title
Description
Author(s)
Tags
Any Date
Last 12 hours
Last 24 hours
Last week
Last 2 weeks
Last month
Last 3 months
Last 6 months
Last year
January
February
March
April
May
June
July
August
September
October
November
December
Rating Range
All - Including Unrated
1.0 - 5.0
2.0 - 5.0
3.0 - 5.0
4.0 - 5.0
4.5 - 5.0
4.8 - 5.0
5.0
More Filters
Article Topics
All Topics
Artificial Intelligence
Internet of Things
DevOps
Containers
High Performance Computing
Hosted Services
Security
Web Development
Mobile Apps
Desktop Programming
Database Development
Productivity Apps and Services
Game Development
Multimedia
General Programming
Programming Languages
Article License
All Licenses
Ms-RL
Custom
CPOL
CDDL
Ms-PL
MPL
CPL
Eclipse
MIT
BSD
Apache
CC (ASA 2.5)
Zlib
Public Domain
CC (Attr 3U)
CC (ASA 3U)
CC (BY-ND 3.0)
LGPL3
GPL3
Forums
All Forums
Feature Forums
General Programming
Web Development
Mobile Development
Product Lifecycle
Database & SysAdmin
General Discussions
Page 1 of 278
Page Size:
10
·
25
·
50
Tag filtered by: SQL-Server
❌
SQL Server: Unexpected Behavior of the LIKE Operator When Used with the ISNULL Function
6 Dec 2023
by
scastelli
license:
CPOL
Database Development
»
Sql Server
SQL
SQL-Server
spSearchTables: Search and Find Tables or Columns by Name or Value
Please
Sign up or sign in
to vote.
21 Nov 2023
by
Federico Di Marco
license:
CPOL
spSearchTables: a helper T-SQL stored procedure for digging into (large) databases
Database Development
»
Sql Server
SQL
SQL-Server
T-SQL
SSMS
Query Excel or CSV files with T-SQL
Please
Sign up or sign in
to vote.
24 Oct 2023
by
Federico Di Marco
license:
CPOL
Query Excel or CSV files with T-SQL without importing them in a table first
Database Development
»
Sql Server
SQL
SQL-Server
CSV
SSMS
ini
How to "Monitor Data Changes in SQL Server Tables with Triggers"
Please
Sign up or sign in
to vote.
7 Aug 2023
by
zidane168
license:
CPOL
Use SQL triggers to keep track of the changes made to your data
Desktop Programming
»
System
SQL
SQL-Server
system
management
trigger
operations
CSV to SQL Server
Please
Sign up or sign in
to vote.
11 Jul 2023
by
Igor Krupitsky
license:
CPOL
Application lets you copy tables from folder with CSV files to SQL Server
Database Development
»
Sql Server
VB
SQL-Server
Spilt DateTime Ranges in SQL Server
Please
Sign up or sign in
to vote.
1 Jul 2023
by
Dipon
Roy
license:
CPOL
Split date time ranges into days or possibly other ranges using CTE in SQL Server
Database Development
»
Sql Server
SQL
SQL-Server
DateTime
PHP Sample of Database Connection Configuration File having Both Connection String for MySQL and MSSQL
Please
Sign up or sign in
to vote.
1 Jun 2023
by
Micah Ebohon
license:
CPOL
Having MSQL and ODBC connection string in one configuration file for your application
Database Development
»
Mysql
SQL-Server
MySQL
Migrating a SQL Database with CLR Integration from Old SQL Server Versions
Please
Sign up or sign in
to vote.
4 May 2023
by
Bruno van Dooren
license:
CPOL
Ways to deal with changed security for CLR code in SQL databases
Security
SQL
SQL-Server
security
CLR
Easy Compare DB
Please
Sign up or sign in
to vote.
24 Apr 2023
by
Eligio Morgado H.
license:
CPOL
Compare two SQL Server databases and show difference in tables and fields
Database Development
C#
SQL-Server
database
.NET6
Workaround for AT TIME ZONE Performance Issues in SQL Server Views & Dynamic SQL
Please
Sign up or sign in
to vote.
6 Mar 2023
by
Andriy Protskiv
license:
CPOL
Workaround for performance issues with AT TIME ZONE
Database Development
SQL
Windows
SQL-Server
database
Page 1 of 278
1
2
3
4
5
6
7
8
9
10
First
·
Prev
·
Next
·
Last