Netvouz / sdmahesh06 / tag / database http://netvouz.com/sdmahesh06/tag/database?feed=rss sdmahesh06's bookmarks tagged "database" on Netvouz ALTER the Database in SQL http://sqlserver-guide.blogspot.com/2008/11/alter-database.html ALTER the Database in SQL SQL sdmahesh06 Thu, 27 Nov 2008 11:45:28 GMT Analysis Services http://sqlserver-guide.blogspot.in/2011/01/analysis-services.html Analysis Services delivers Online Analytical Processing (OLAP) and Data Mining functionality for business intelligence applications. sdmahesh06 Thu, 19 Jul 2012 10:49:04 GMT create a TABLE in SQL http://sqlserver-guide.blogspot.com/2008/11/create-table.html create a TABLE in SQL and Sytax SQL sdmahesh06 Thu, 27 Nov 2008 11:44:58 GMT Crystal Reports - Geterogeneus databases: SQL Server, Oracle, Unidata, Btrieve – tips for developer http://sqlserver-guide.blogspot.in/2010/07/mysql-50-new-features.html MySQL user who wants to know "what's new" in version 5. The short answer is "stored procedures, triggers, views, and information schema". sdmahesh06 Thu, 19 Jul 2012 10:39:36 GMT Data Definition Language http://sqlserver-guide.blogspot.com/2008/11/data-definition-language.html " Data definition level language which includes the following statements. A) CREATE Statement B) ALTER Statement C) DROP Statement D) TRUNCATE Stat " SQL sdmahesh06 Thu, 27 Nov 2008 11:43:04 GMT Data Types in SQL Server http://sqlserver-guide.blogspot.com/2008/10/data-types-in-sql-server.html Data type means the type of data which users provided to specific column in Sql Server SQL sdmahesh06 Thu, 27 Nov 2008 11:41:40 GMT Database file properties in SQL http://sqlserver-guide.blogspot.com/2008/11/each-database-file-has-five-properties.html Each database file has five properties SQL sdmahesh06 Thu, 27 Nov 2008 11:44:30 GMT Database files and File groups http://sqlserver-guide.blogspot.com/2008/11/database-files-and-file-groups.html A database file is nothing but an Operating system file. A database spans at least two, and possible several database files. SQL sdmahesh06 Thu, 27 Nov 2008 11:43:34 GMT Database files in SQL Server 2000 http://sqlserver-guide.blogspot.com/2008/11/sql-server-2000-allows-three-types-of.html SQL Server 2000 allows three types of database files SQL sdmahesh06 Thu, 27 Nov 2008 11:43:59 GMT Difference between TOP clause in SQL 2000 and SQL 2005 http://sqlserver-guide.blogspot.in/2010/06/difference-between-top-clause-in-sql.html 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. sdmahesh06 Thu, 19 Jul 2012 10:31:08 GMT