Escaping an apostrophe or a quote in MySQL can be done by putting a \ (backslash) in front of them.
Example: insert into tablename (columnname) values ('It\'s time to eat.');
Escaping an apostrophe or quote in MSSQL can be done by doubling up the apostrophe or quote.
Example: insert into tablename (columnname) values ('It''s time to eat.');
Source: from
HeidiSQL is a very nice free program for connecting to multiple types of databases. I use it to connect to SQL Express since Microsoft removed the Query Analyzer from the SQLExpress 2008 install. You just need to know the hostname and the instance name of the database to connect. In my case the instance name is RLH.
Configuring the Windows Firewall to Allow SQL Server Access
From: http://msdn.microsoft.com/en-us/library/cc646023(d=printer).aspx
yum -y install phpMyAdmin php-mysql php-mcrypt
vi /etc/httpd/conf.d/phpMyAdmin.conf
Change line 14 and add any IP address that you want to allow access to your phpmyadmin web page.
By default it will allow the local host: Allow from 127.0.0.1
You can add any computer on your domain: Allow from 127.0.0.1 10.0.0.0/24
This is assuming your domain IP address range is 10.0.0.0/24.
Alternatively, you can add access to any computer by changing the line to read: Allow from All
You should setup SSL access to your server if you are going to allow all.
Save the changes and restart httpd by typing:
sudo /etc/rc.d/init.d/httpd reload
or
sudo service httpd restart
Example of phpMyAdmin.conf file:
# phpMyAdmin - Web based MySQL browser written in php
#
# Allows only localhost by default
#
# But allowing phpMyAdmin to anyone other than localhost should be considered
# dangerous unless properly secured by SSL
Alias /phpMyAdmin /usr/share/phpMyAdmin
Alias /phpmyadmin /usr/share/phpMyAdmin
<Directory /usr/share/phpMyAdmin/>
Order Deny,Allow
Deny from All
Allow from 127.0.0.1
Allow from ::1
</Directory>
<Directory /usr/share/phpMyAdmin/setup/>
Order Deny,Allow
Deny from All
Allow from 127.0.0.1
Allow from ::1
</Directory>
# These directories do not require access over HTTP - taken from the original
# phpMyAdmin upstream tarball
#
<Directory /usr/share/phpMyAdmin/libraries/>
Order Deny,Allow
Deny from All
Allow from None
</Directory>
<Directory /usr/share/phpMyAdmin/setup/lib/>
Order Deny,Allow
Deny from All
Allow from None
</Directory>
# This configuration prevents mod_security at phpMyAdmin directories from
# filtering SQL etc. This may break your mod_security implementation.
#
#<IfModule mod_security.c>
# <Directory /usr/share/phpMyAdmin/>
# SecRuleInheritance Off
# </Directory>
#</IfModule>
From: http://www.server-world.info/en/
EXEC sp_MSforeachtable @command1 = “DROP TABLE ?”
This is a hidden SP in sql server, this will be executed for each table in the database you connected (you cant rollback this)
If u want to delete it from the command prompt try this
EXEC xp_cmdshell ‘SQLCMD -U <user> -P <password> -Q ‘EXEC sp_MSforeachtable @command1 = “DROP TABLE ?” ‘ ,no_output
Delete/truncate all the Data from each table for in the database you connected
EXEC sp_MSforeachtable @command1 = “DELETE FROM ?”
EXEC sp_MSforeachtable @command1 = “TRUNCATE TABLE ?”
I too explain it now, as sp_MSforeachtable is Stored Procedure, that will execute for all the tables for database & @command1 is variable which will run against each table for connected database, now whatever you will write in the double quotes, that will be act as a command for each table, where ‘?’ is the name of the table.
try this, it will clear your comcepts
EXEC sp_MSforeachtable @command1 = “SELECT * FROM ?” — Selects all the rows form all the table
EXEC sp_MSforeachtable @command1 = “PRINT ‘?'” –Just print the tables names with owner(dbo)
For more understanding, go for the MSDN or google, this is the right way.
If you are having connectivity problems specify the database name in the box that asks “Which SQL Server do you want to connect to?” For instance, Computername\SQLEXPRESS.
You can also use the command line ‘sqlcmd’ to access SQL Server Express.
It is a pain to use but it works. You can write your code in a text
file then import it using the sqlcmd command. You also have to end
your query with a new line and type the word ‘go’.
Example of query file named test.sql: use master; select name, crdate from sysdatabases where xtype='u' order by crdate desc; go
Example of sqlcmd: sqlcmd -S %computername%\RLH -d play -i "test.sql" -o outfile.sql & notepad outfile.sql