Virtual 01 Notepad

A very simple statement can accomplish the task of finding a list of all tables in a MS SQL Server CE (*.sdf) database : The query is given below: SELECT  table_name FROM  information_schema.tables WHERE(TABLE_TYPE <> 'VIEW') You may use SQLCommand class to execute this sql command. Thanks  

First of all you have to know  what the FTP is " File Transfer Protocol ( FTP ) is a standard network protocol used to transfer files from one host or to another host over a TCP -based network". FTP Installation & Configuration: Step 1: Install the Web Server role with the IIS Management Console and FTP Server role services: Step 2: Add a new FTP Site Step 3: Setup the site with the default bindings and choose Allow SSL to avoid deploying a certificate:     Step 4: Configure user permissions and basic or anonymous permission. If your server is connected to your domain you can specify domain users, otherwise they must be local user accounts: Note: Finally you’ll have to configure your server’s firewall rules to allow access.Disregard any existing FTP firewall rules; although they should be enabled, they don’t actually allow access! Run Allow a Program Through Windows Firewall and grant access to C:\Windows\System32\svchost.exe T...

I've been asked today by one of my younger brother that " How can we create a table using SQL command in Oracle 10g   such that a column must accept those values that start with a specific character e.g. A. " Then I replied him to use Integrity Constraints . Since he was not familiar about  Integrity Constraints  hence he wanted to get the complete solution of his real problem. His Problem statement was: "Create cust table which contains cno having pk(primary key),cname and occupation where data values inserted for cno must start with the capital letter C and cname should be in uppercase. " Integrity Constraints are those which ensure that all the changes made to the Database by authorized users don't result in a loss of data consistency. A list of Integrity Constraints are given below Primary Key Foreign Key Unique  Check Not Null We will use Check  Integrity Constraint to solve the problem. Syntax: column_name data_type(size) CHECK(l...