NEW LISTINGS 
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
Getting Started with Transact-SQL Statements
35574
Getting Started with Transact-SQL Statements
http://dba.fyicenter.com/faq/sql_server/Getting_Started_with_Transact-SQL_Statements.html
A collection of 10 tutorials for you to get started quickly with running Transact-SQL statements on SQL Server 2005. Clear examples are provided for running CREATE TABLE, INSERT, UPDATE, DELTE, SELECT, CREATE USER, GRANT EXECUTE statements. Topics included in this collection are:
How to use Transact-SQL statements to access the database engine?
How to create new databases with "CREATE DATABASE" statements?
How to create new table with "CREATE TABLE" statements?
How to insert and update data into a table with "INSERT" and "UPDATE" statements?
How to read data in a table with "SELECT" statements?
How to create a login to access the database engine using "CREATE LOGIN" statements?
How to create a user to access a database using "CREATE USER" statements?
How to create a view and a stored procedure using "CREATE VIEW/PROCEDURE" statements?
How to grant a permission using "GRANT EXECUTE" statements?
How to delete database objects with "DROP" statements? Tools and Utilities > Database Tools Jun 22, 2007 FYIcenter.com send email to FYIcenter.com
How to use Transact-SQL statements to access the database engine?
How to create new databases with "CREATE DATABASE" statements?
How to create new table with "CREATE TABLE" statements?
How to insert and update data into a table with "INSERT" and "UPDATE" statements?
How to read data in a table with "SELECT" statements?
How to create a login to access the database engine using "CREATE LOGIN" statements?
How to create a user to access a database using "CREATE USER" statements?
How to create a view and a stored procedure using "CREATE VIEW/PROCEDURE" statements?
How to grant a permission using "GRANT EXECUTE" statements?
How to delete database objects with "DROP" statements? Tools and Utilities > Database Tools Jun 22, 2007 FYIcenter.com send email to FYIcenter.com
Write a Review
Add to My Favorite
Refer it to Friend
Report Broken Link
| |
|
Other links owned by this user
The Secure File Transfer Protocol provides secure file transfer functionality over any reliable data stream, SSH in this case. It is the standard file transfer protocol for use with the SSH2 protocol. wodSFTPdll library implements client side of this protocol which is reliable and easy to use.
SFTP protocol is designed to provide primarily file transfer, but also more general file system access on the remote server - in secure manner. SFTP protocol assumes it is running on secure channel (secure channel is implemented in wodSFTPdll), thus no plaintext passwords or file information is exposed to the network.
This library implements protocol that is also used in well known SCP (Secure Copy) command on UNIX systems. Internally, SCP client opens SFTP connection with the server for file transfer (much better than calling RCP over SSH connection).
SFTP protocol is designed to provide primarily file transfer, but also more general file system access on the remote server - in secure manner. SFTP protocol assumes it is running on secure channel (secure channel is implemented in wodSFTPdll), thus no plaintext passwords or file information is exposed to the network.
This library implements protocol that is also used in well known SCP (Secure Copy) command on UNIX systems. Internally, SCP client opens SFTP connection with the server for file transfer (much better than calling RCP over SSH connection).
Category:
Learn how to create airplane animation using the Action Script in flash 8. You will also learn:
1. How to convert airplane into a Moive Clip Symbol.
2. How to create a button, that will be control airplane animation
3. How to use Instance input field from the Properties Panel and more.
1. How to convert airplane into a Moive Clip Symbol.
2. How to create a button, that will be control airplane animation
3. How to use Instance input field from the Properties Panel and more.
Category:
Magic Magnify is an elegant way to zoom into your images with a magnifying-glass. The user does not need to click anything - they just move their mouse over the photo to see every detail in your product.
Category:
pPicture Gallery is a PHP driven, single file application to turn your directory of images into a sleek gallery with thumbnails.
It's so simple, all you need to do is alter a few settings, drop the PHP script into the directory and you're done!
Supports: JPEG, GIF, PNG
It's so simple, all you need to do is alter a few settings, drop the PHP script into the directory and you're done!
Supports: JPEG, GIF, PNG
Category:
PowerCmd enhances your command prompt with an easy-to-use Windows GUI-style interface and allows you to run multiple consoles within a single tabbed window. You can easily organize multiple consoles in vertical, horizontal, and grid forms. Auto-log, auto-completion, keywords highlight, configurable font and colors, customizable toolbar for frequently used commands or tools and minimizing to tray are easy solutions to daily needs.
Category:
Learn how to apply blur effect on picture using the flash filters. After that, I will show you how to enlarge picture using the Free Transform Tool(Q).This picture effect is very attractive and you can apply it wherever you like. To create this tutorial, you don't have to use action script.
Category:
A file-based guest book and does not use a MySQL database. Easy installation and customization. It removes HTML. Includes visible/invisible mode for messages. Edit and delete users messages. A guestbook that is templated, easily modified to fit your site's design.
Category:
It's holiday time and I make a decision to make some simple, but in the same time very attractive and practical holiday card. You don't have to use action script code to make this holiday animation. You can use this animation every christmas and new year holiday as header, flash banner.....
Category:
We are trying to achieve loading content into a ‘div’ element without refreshing the page, as well as showing a cool loading window inplace of the content as it is loading.
Category:
A blog is a frequently updated, personal website featuring diary-type commentary and links to articles or other Web sites. Blogs range from the personal to the political, and can focus on one narrow subject or a whole range of subjects
Category:
Export data to SQL utility allows the user to export content of the selected table to the set of SQL statements (INSERTs). This database export utility supports all modern versions of DB2. ODBC driver is required.
Category:
For the creation of the whole navigation bar we group the whole code into a function, this way it's more portable and we can accesses the code several times in one script without to repeat the code.
Category:
This easy tutorial will show you how to create on a simple way very attractive and practical zoom in zoom out text animation. You don't have to use action script code to make this tutorial. You can use this tutorial for any text animation, presentation, text banner...
Category:
The flash menu component provides an easy way to add a vertical or horizontal two-level menus Flash drop down menu to your Flash websites. Menu items and links can be defined using a very simple XML file (without any coding) or through ActionScript.
Category:
Dreamweaver Visual Calendar allows you to visually create a calendar where you can publish events, notes associtated to dates or any other kind of information linked to dates or date ranges.
The information associated to a date, and the interface of the actual calendar, are appealing thanks to dynamic effects compatible with all current browsers.
The information associated to a date, and the interface of the actual calendar, are appealing thanks to dynamic effects compatible with all current browsers.
Category:
The server core is based on the open instant messaging protocoll Jabber / XMPP, thus allowing the integration with a wide set of clients and Jabber libraries. GroupChat Server also introduces new Jabber protocol extensions to allow video conferencing over RTMP, or moderated / censored chat rooms for example. The according graphical user interface is exposed by the GroupChat Flash-Client, to offer a platform independent web integration. The Architecture-Overview slide shows the parts and services belonging to the GroupChat Server solution. Basically, it consists of the GroupChat Server core, the Admin-Interface, a separate webserver for configuration settings and the GroupChat database engine.
Category:
Testing Master is an easy-to-use and affordable website testing tool. It tests the performance of web sites or intranet applications by load and stress testing and helps you to find bottlenecks of your web site. Web site testing tool Testing Master can simulate thousands of users, came from the same quantity of IPs and analyze, how many concurrent users can handle your web site. Website testing tool Testing Master has many useful features, such as IP spoofing, multiple simultaneous test cases and website testing features for sites with dynamic content and secure HTTPS pages. And this is not the whole story. Our website testing tool presents test results for you in graphs and text reports, so you can analyze the performance characteristics of your web site, and by this way, make it better.
Category:
Full XML website is a complete solution for publishing multimedia contents. Built under XML files you can edit all contents. Dynamic html pages, image galleries, video galleries, news section and all your information for the contact form.
Category:
topsites list ranks a group of related sites by popularity. Webmasters join the topsites list and are given a button to put on their site and link back to the topsites list.
Stats
Counts pageviews, hits in, and hits out
Stats for individual members and overall stats for the entire list are easily accessible
Security
Stats
Counts pageviews, hits in, and hits out
Stats for individual members and overall stats for the entire list are easily accessible
Security
Category:
Other links at Tools and Utilities > Database Tools
A database is a web of relationships. Working with a database is risky business: do you have all the necessary information before making a change? Do you have the right database tool solution to make an informed decision?
Category:
2. Oracle
All Oracle data types (except BFILE and MLSLABEL) and attributes are supported
Works with all versions of Unix and Windows MySQL servers
Command line support
Converts indexes with all necessary attributes
Converts foreign keys
Merges Oracle data into an existing MySQL database
Converts individual tables
VServer user's option (see below)
Exports Oracle databases into MySQL dump file (see below)
Easy-to-use wizard-style interface
Full install/uninstall support
Works with all versions of Unix and Windows MySQL servers
Command line support
Converts indexes with all necessary attributes
Converts foreign keys
Merges Oracle data into an existing MySQL database
Converts individual tables
VServer user's option (see below)
Exports Oracle databases into MySQL dump file (see below)
Easy-to-use wizard-style interface
Full install/uninstall support
Category:
pgAdmin III is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world. The application may be used on Linux, FreeBSD, Solaris, Mac OSX and Windows platforms to manage PostgreSQL 7.3 and above running on any platform, as well as commercial versions of PostgreSQL such as Pervasive Postgres, EnterpriseDB, Mammoth Replicator and SRA PowerGres.
Category:
As all "ABC Amber" products, it's really easy as ABC and powerful as Amber.
Category:
DB Solo is a powerful yet affordable cross-platform database development and management tool for both developers and DBAs. With its rich feature set, it is comparable to tools that are orders of magnitude more expensive. DB Solo has an intuitive user interface that allows you to explore and manage your database objects as well as execute your own ad-hoc queries. DB Solo supports most major operating systems and DBMS products available today.
Category:
Main Category
178
2033
792
284
174
1802
1113
905
1157
7351
70
898
59
2186
172
Join Mailing List
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.
Top 10
Directory Statistics
Links: 19152
Categories: 1275
Registered Users: 697
Mailing List Subscribers: 2042
Unique Outgoing Hits: 222384
Pagerank Statistics
PHP News