Skip to main content

Home/ Software Tutorials for Visual Learners/ Group items tagged microsoft sql server

Rss Feed Group items tagged

Filter: All | Bookmarks | Topics Simple Middle
adie afton

Microsoft links free SQL database with ASP .Net - 0 views

sqlserver-guide.blogspot.com/...ks-free-sql-database-with.html

Sql db2 data base design structured query language sql database my sql open source sql server2000 ms sql server microsoft sql server sql programming SQL Server

shared by adie afton on 29 Jan 11 - No Cached
  • adie afton on 29 Jan 11
     
    Microsoft is enabling its free SQL CE (SQL Server Compact Edition) database to work within ASP.Net Web applications, thus providing a lightweight database option for ASP.Net Web development, a Microsoft official said this week.
adie afton

Microsoft links free SQL database with ASP .Net - 0 views

sqlserver-guide.blogspot.in/...ks-free-sql-database-with.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached
  • adie afton on 20 Aug 12
     
    Microsoft is enabling its free SQL CE (SQL Server Compact Edition) database to work within ASP.Net Web applications, thus providing a lightweight database option for ASP.Net Web development
adie afton

SQL Server 2008's Database Engine - 0 views

sqlserver-guide.blogspot.com/...ver-2008s-database-engine.html

Sql db2 data base design structured query language sql database my sql open source sql server2000 ms sql server microsoft sql server sql programming SQL Server

shared by adie afton on 29 Jan 11 - No Cached
  • adie afton on 29 Jan 11
     
    The Database Engine is the primary component of SQL Server 2008. It is the Online Transaction Processing (OLTP) engine for SQL Server, and has been improved and enhanced tremendously in this version.
adie afton

SQL Server Security - 0 views

sqlserver-guide.blogspot.com/...sql-server-security.html

Sql db2 data base design structured query language sql database my sql open source sql server2000 ms sql server microsoft sql server sql programming SQL Server

shared by adie afton on 29 Jan 11 - No Cached
  • adie afton on 29 Jan 11
     
    There are several levels of security to SQL Server. At the a base level, in order to be granted get access to a SQL Server, a user is required to have a login account.
adie afton

What's New in SQL Server 2005-Enhancements for Data Base Administrators. - 0 views

sqlserver-guide.blogspot.in/...whats-new-in-sql-server.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached
  • adie afton on 20 Aug 12
     
    The SQL Server Management Studio is a one point access to a number of services - the relational database, the Integration services, Analysis services, Reporting services, Notification Services and SQL Mobile.
adie afton

To make SQL Queries Case Sensitive - 0 views

sqlserver-guide.blogspot.in/...ql-queries-case-sensitive.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached
  • adie afton on 20 Aug 12
     
    To make SQL Queries Case Sensitive using Collation.You can make SQL Queries Case sensitive at the column level or Table level or DataBase level.
adie afton

What is SQL Server 2008/RDBMS? - 0 views

sqlserver-guide.blogspot.com/...t-is-sql-server-2008rdbms.html

Sql db2 data base design structured query language sql database my sql open source sql server2000 ms sql server microsoft sql server sql programming SQL Server

shared by adie afton on 29 Jan 11 - No Cached
  • adie afton on 29 Jan 11
     
    SQL Server 2008 can be more accurately described as an Enterprise Data Platform.
adie afton

Difference between TOP clause in SQL 2000 and SQL 2005 - 0 views

sqlserver-guide.blogspot.in/...between-top-clause-in-sql.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached
  • adie afton on 20 Aug 12
     
    Generally TOP clause is used to perform SELECT on top n results. This feature of TOP is extended in SQL 2005 so that we can also use expression apart from int, bigint and percent to perform query and also extended to be used in UPDATE and DELETE statements.
adie afton

SQL Keys - 0 views

sqlserver-guide.blogspot.in/...sql-keys.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached
  • adie afton on 20 Aug 12
     
    In SQL, keys are used to maintain referential integrity among relations. Put simply, this means keys allow tables to reference each other, and each reference will be "correct" every time.
adie afton

Structured Query Language: Integration Services - 0 views

sqlserver-guide.blogspot.com/...integration-services.html

Sql db2 data base design structured query language sql database my sql open source sql server2000 ms sql server microsoft sql server sql programming SQL Server

shared by adie afton on 29 Jan 11 - No Cached
  • adie afton on 29 Jan 11
     
    SQL Server Integration Services (SSIS) is Microsoft's new enterprise class data Extract, Transform, and Load (ETL) tool.
adie afton

SQL Perl/PL Overview - 0 views

sqlserver-guide.blogspot.in/...sql-perlpl-overview.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached
  • adie afton on 20 Aug 12
     
    The following examples make use of PostgreSQL's implementation of PL/Perl, but the examples should be relevant and similar to other procedural language extensions in most databases that support such additions.
adie afton

MySQL Tip: How To Check, Repair & Optimize All Tables in All Databases - 0 views

sqlserver-guide.blogspot.in/...-to-check-repair-optimize.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached
  • adie afton on 20 Aug 12
     
    mysqlcheck uses the SQL statements CHECK TABLE, REPAIR TABLE, ANALYZE TABLE, and OPTIMIZE TABLE in a convenient way for the user.
adie afton

MySQL SQL Delete Notes - 0 views

sqlserver-guide.blogspot.in/...mysql-sql-delete-notes.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached
  • adie afton on 20 Aug 12
     
    To delete duplicates from a MySQL database table I normally copy the duplicate data first to a temporary table and then use the copied id's to delete from the original table.
adie afton

Top 7 Free Open Source Database Server - 0 views

sqlserver-guide.blogspot.com/...en-source-database-server.html

Sql db2 data base design structured query language sql database my sql open source sql server2000 ms sql server microsoft sql server sql programming SQL Server

shared by adie afton on 29 Jan 11 - No Cached
  • adie afton on 29 Jan 11
     
    After an extensive research we sorted out the top 7 Open Source Server based database management systems, have a look.
adie afton

MySQL SQL Delete Notes - 0 views

sqlserver-guide.blogspot.com/...mysql-sql-delete-notes.html

Sql db2 data base design structured query language sql database my sql open source sql server2000 ms sql server microsoft sql server sql programming SQL Server

shared by adie afton on 29 Jan 11 - No Cached
  • adie afton on 29 Jan 11
     
    To delete duplicates from a MySQL database table I normally copy the duplicate data first to a temporary table and then use the copied id's to delete from the original table.
adie afton

How to start/stop MySQL server on Linux - 0 views

sqlserver-guide.blogspot.in/...top-mysql-server-on-linux.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached
  • adie afton on 20 Aug 12
     
    This will kill the mysqld process. However the best way to stop (because it stops properly) is obviously
adie afton

Stored Procedures in MySQL 5.0 - 0 views

sqlserver-guide.blogspot.in/...ed-procedures-in-mysql-50.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached
  • adie afton on 20 Aug 12
     
    MySQL 5.0 introduced Stored Procedures which allow us to automate or program our way out of many tasks on directly on the server rather than having to write external scripts to do complex manipulation of data.
adie afton

MySQL 5.0 New Features: Data Dictionary - 0 views

sqlserver-guide.blogspot.in/...-features-data-dictionary.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached
  • adie afton on 20 Aug 12
     
    MySQL now has a new "database" named INFORMATION_SCHEMA. It is a virtual database only; there will never be a need to create a file by that name, and the MySQL server itself creates and populates the tables therein.
adie afton

Stored Procedures in MySQL 5.0 - 0 views

sqlserver-guide.blogspot.com/...ed-procedures-in-mysql-50.html

Sql db2 data base design structured query language sql database my sql open source sql server2000 ms sql server microsoft sql server sql programming SQL Server

shared by adie afton on 29 Jan 11 - No Cached
  • adie afton on 29 Jan 11
     
    MySQL 5.0 introduced Stored Procedures which allow us to automate or program our way out of many tasks on directly on the server rather than having to write external scripts to do complex manipulation of data.
adie afton

MySQL Tip: How To Check, Repair & Optimize All Tables in All Databases - 0 views

sqlserver-guide.blogspot.com/...-to-check-repair-optimize.html

Sql db2 data base design structured query language sql database my sql open source sql server2000 ms sql server microsoft sql server sql programming SQL Server

shared by adie afton on 29 Jan 11 - No Cached
  • adie afton on 29 Jan 11
     
    Here is a simple command to auto repair, check and optimize all the tables in all databases running on a MySQL server:
1 - 20 of 37 Next ›
Showing 20▼ items per page