Home | Contact Us | Log In | Help
HOME NEW LISTING MOST POPULAR HIGHEST RATED SCRIPTS ADD SCRIPT DOWNLOADS FORUM
Tutorials
  ASP.Net & C#
  ASP
  Perl and PHP
  Java Scripts
  C and C++
  Ajax Tutorials
  J2ee, J2Me, Java
  Python & Ruby Rail
  Crystal Report
  Sap
  CGI
  XML
  Cold Fusion & CFML
  HTML, DHTML & CSS
  Dreamweaver
  FLASH
  Photoshop/Web Designing
  Tools & Utilities
  Oracle/D2K
  Sql Server
  MySql
  Domain Name Registration
  Remotely Hosting
  Web/Server Application
  Hotel Marketing
  Internet and Law
   Search Engine Optimization/SEO
E-Commerce
Interview Questions
SQL Server 11
Stored Procedures

To create a procedure:

  • In the Object Explorer, expand the database for which you want to create the procedure, expand its Programmability node, right-click Stored Procedures, and click New Stored Procedure... A query window with a skeleton syntax would be displayed. You can then modify that code using the techniques we will learn in this lesson.
  • Open an empty query window associated with the database for which you want to create the stored procedure and display the Templates Explorer. In the Template Explorer, expand the Store Procedure node. Drag Create Stored Procedure and drop it in the query window
  • Open an empty query window associated with the database for which you want to create the stored procedure and enter the necessary code
SQL JOIN

Sometimes we have to select data from two or more tables to make our result complete. We have to perform a join.

Tables in a database can be related to each other with keys. A primary key is a column with a unique value for each row. Each primary key value must be unique within the table. The purpose is to bind data together, across tables, without repeating all of the data in every table.

In the "Employees" table below, the "Employee_ID" column is the primary key, meaning that no two rows can have the same Employee_ID. The Employee_ID distinguishes two persons even if they have the same name.

Migrating from Sybase to SQL Server
Projects involving database migration are common. In this article Sayed shares his experiences in migrating from Sybase to SQL Server...I was involved in a recent project to migrate a Sybase database to Microsoft SQL Server 2000. The experience I gained by working on this project has led me to write this article to show Sybase database administrators (DBA’s) and managers the steps that should be followed to migrate from a Sybase database to an SQL Server 2000 database.

Although some differences will be quite noticeable, such as a Sybase stored procedure that refuses to compile in SQL Server, other differences are much more subtle. It will be necessary to heavily test the behavior and resultsets of all programming logic in script files and stored procedures prior to completing the conversion.
SQL Server 2000 Reporting Services with SQL Server 2000

SQL Server 2000 Reporting Services with SQL Server 2000

Report Development

Creating new SSRS reports
To launch  and start a new Reporting Services project
1.To launch and open the Start menu and select Programs, Microsoft Visual Studio.Net
2.To start a new Reporting Services project, select File, New, and then Project.Then the Bussiness Intelligence Projects

3.Select the Report Project project type.

4.Type the name of your project and click the OK button.
5.Once the new project is created, you will see two folders in Solution Explorer: Shared Data Sources and Reports.  The Shared Data Sources folder contains a list of data sources that are shared among all reports. You use it to define a single data source that can be reused. The Reports folder contains all reports that you define. Adding new data sources. And  Creating new reports

SQL and T-SQL

Structured Query Language, also known as SQL, is a query and programming language. It can be used for accessing, updating, deleting, and adding data in a database. SQL can also be used for managing the RDBMS (Relational Database Management System) itself. Different databases may use versions of SQL that very slightly, but most comply with the standard ANSI SQL-92 implementation of SQL, commonly call ANSI SQL. You can group SQL statements into two main categories: Data Definition Language (or DDL) and Data Manipulation Language (or DML).

DDL statements, as the name suggests, allow you to define the database structure. Most DDL statements begin with CREATE, ALTER, or DROP. The two DDL statements we are going to cover today are CREATE DATABASE (used for creating new databases) and ALTER DATABASE (used for altering existing databases). We will look at the exact syntax of these two statements later on in this article.

  Copyright 2000-2006 © SoloScript.com, All rights reserved.