Restore SQL Server database with SQL code
We have options to restore a system database using SQL Server Management Studio, but we cannot always have it at hand, or especially when it...
Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts
How to create a SQL Server database as it is created in UOL or Locaweb?
When we create a database on the SQL server, when we install SQL Server express, we always see all the databases we create, even if a specif...
MariaDB - Discover a promising new database
Yes, this is exactly the name you are reading from the newest promising database: MariaDB. This database originated from the true MySQL deve...
What is Cross Apply - SQL Server
In SQL Server, you can do an INNER JOIN to join in a query result of several tables. However, when consulting another table with many result...
Facebook database
Facebook had a period in its history when nobody accessed it, and after that, it started to grow slowly, and today it is one of the largest ...
Choosing your application database
How to choose the database that will store your application data? This is a question that many ask when starting a new system and sometimes ...
Securing SQL Inject queries in ASP Classic
When saving a form, we usually take the value and pass it directly to a part of an SQL query string and run it in the bank, right? Wrong! Be...
How to disable logging on SQL Server
This week I had some problems with the database transaction log, which when running a query presented the following error: The transaction l...
Query NULL records in SQL Server
Hardly to be found on google (with several scripts with more than 10 or 20 lines), I found a method that is so simple, but I really needed i...
SQL Server 2008 string math
Well, after a long time without a post, I'm back here with some advanced SQL tips. Today in my service, I came across a situation in whi...
Examples of SQL commands
The entire system uses a database, and you sometimes need advanced programming skills to be able to create them. In this tutorial you will f...
Connect to MS Access Database Driver and Others in VBS Scripts
Here is the connection string, which we often need to find on the internet and not easily found. You can create programs based on the Visual...
Subscribe to:
Posts
(
Atom
)
Parceiro de sustentação:
