Category Archives: SQL Server

http://www.microsoft.com/sql/howtobuy/default.mspx Note: The retail price for Microsoft SQL Server 2005 Developer Edition is $49.95. Microsoft SQL Server 2005 Developer Edition may be installed and used by one user to design, develop, test, and demonstrate your programs. SQL Server 2005 Pricing … Continue reading →

Version de SQL SELECT @@VERSION  

While browsing the SQL Server newsgroups, every once in a while, I see a request for a script that can search all the columns of all the tables in a given database for a specific keyword. I never took such … Continue reading →

SQL Server es una aplicación Winsock que se comunica a través de TCP/IP utilizando la biblioteca de red de sockets. SQL Server escucha las conexiones entrantes en un puerto concreto; el puerto predeterminado para SQL Server es 1433. El puerto … Continue reading →

Problema de instalación Windows Clean Utility

T-SQL code BACKUP: USE myDatabaseName GO BACKUP DATABASE myDatabaseNameTO DISK = ‘C:\filePath\myDatabaseName.bak’NAME = ‘The name of the back up.’   RESTORE: RESTORE databaseName FROM DISK = ‘C:\filePath\backupFilename’ Tags: backup, restore