|
|
|
Monday, 19 December 2011 00:53 |
Database Publishing Wizard is very flexible and works with modes like schema only, data only or both. It generates a single SQL script file which can be used to recreate the contents of a database by manually executing the script on a target server.
You may find at following location in your machine:
File Name:
SqlPubWiz.exe
Path:
C:\Program Files\Microsoft SQL Server\90\Tools\Publishing
Download Database Publishing Wizard from here http://sqlhost.codeplex.com/wikipage?title=Database%20Publishing%20Wizard&ProjectName=sqlhos Read more: |
|
|
Thursday, 15 December 2011 00:28 |
I would like to share cool feature of SQL Server with you guys like:
Please use the following query when concatenate two or more rows with comma (or any you want) in a single string.
SELECT STUFF((SELECT ',' + RTRIM(RegionDescription) FROM Region FOR XML PATH('')),1,1,'') AS 'Regions'
This would be also useful when you have to check between condition in SQL Query.
 Read more: |
|
Monday, 29 November 2010 03:00 |
 | About Navicat for Oracle
An ideal solution for SQL Server administration and development which lets you create, edit databases, run SQL queries and connect to remote SQL Server in an easier way. It features an intuitive GUI and offers powerful visual tools such as Query Editor with syntax highlight capability, SQL Preview, SQL Console, TEXT, Hex and BLOB viewer/editor, SSH Tunnel and more, to increase your productivity.
Also, Navicat provides a number of tools allowing to perform all the necessary database operations such as creating, editing, and duplicating database objects. It also offers a well-described wizard system that simplifies your database development tasks and a full featured graphical manager for setting the users and access privileges. Navicat for SQL Server can connect to SQL Server 2000, 2005 and 2008R2, and supports most of the latest features including Trigger, Function, View and others. |
Read more: |
|
|
Tuesday, 02 November 2010 10:03 |
# Iterate over one record at a time using ActiveRecord, instead of being slurpy.
def self.foreach(conditions = nil, &block)
conn = connection.raw_connection
sql = "select * from #{table_name}"
sql += " where #{conditions}" if conditions
begin
raw_cursor = conn.exec(sql)
while rec = raw_cursor.fetch_hash
object = self.new
# To get around protected attributes we must assign all attributes
# individually, instead of passing a single hash to self.new.
rec.each{ |key, value|
cname = key.downcase
object.send("#{cname}=", value)
}
yield object
end
ensure
raw_cursor.close if raw_cursor
end
end
 Read more: |
|
Tuesday, 24 August 2010 07:00 |
 | About RazorSQL
Gives users the ability to query, navigate, update, and manage databases via JDBC. Users can run SQL scripts; do SQL programming; visually edit, create, alter, and view tables; visually build queries; import and export data; and browse databases. |
Read more: |
|
|
|
|
|
|
|