Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: murzina
  • Order by date
  1. murzina

    alter and primary key

    As I enter the code below, I get the error below. It says not enough space allocated. What's wrong? Why does it give the error below? And how do I fix it? USE Zipcodes GO Create Table Distance (zid int(1000000), ZipCodes varchar(7), Radius Numeric(5)...
  2. murzina

    alter and primary key

    For some reason the million database doesn't fit into integer value. I need some other variable that can hold a million record database. The varchar doesn't have enough space allocated either. What variable I can use?
  3. murzina

    alter and primary key

    I would like to add a field to the table. Is this the right way to do it? Alter table Distance Add (zid integer(10000000)); I would like to set one of the fields as a primary key. I did not do it at the creation of the table. Is it possible to set a field as a primary key after the creation of...
  4. murzina

    small database creation

    So would that be a correct code below? Create Database Zipcodes; GO Create Table Distance (ZipCodes Number(5), Radius Number(5), KM_MI varchar(30), Calling_Website varchar(100)); GO Insert into Distance Values (46835, 5, 'Km', 'www.website.com'); GO
  5. murzina

    small database creation

    What syntax is used for setting up a small database in SQL Express? For instance, CREATE USER Alex WITHOUT LOGIN CREATE Table zipcodes;
  6. murzina

    variable passing

    What is the syntax in SQL Express for passing a variable, for instance, Declare @@number decimal begin print '@@number' end What is wrong with this coding?
  7. murzina

    Microsoft SQL Server vs Oracle 8i

    Where can I find a glossary of commands used in Microsoft SQL Server? It's kinda tedious to ask for every command on the forum. I used Oracle 8 and 7 before, but, obviously, it has its own syntax.
  8. murzina

    Microsoft SQL Server vs Oracle 8i

    It outputs a string "Any text".
  9. murzina

    Microsoft SQL Server vs Oracle 8i

    I would like to find out what is the equivalent syntax in Microsoft SQL Server for dbms_output.put_line('any text'); (this line is OK for Oracle 8i).
  10. murzina

    SQL Express create a few tables

    How do I create a DB in SQL Express in Visual Studio 2005? I would like to create a few tables for starters. Where do I start?
  11. murzina

    SQL Express

    Is it necessary to use SQL Express or SQL Server in Visual Studio 2008 is sufficient to create a database on a laptop? If SQL Express is necessary, then what version is appropriate and where can I download it?
  12. murzina

    ASP.NET

    I have fixed previous problem. I have tried to find a way to create a database in Visual Studio. When I tried to search for an SQL Server .exe file, I could not find one. When I tried to create a database file of Visual Studio using my laptop, there was an error. Remote connection is not...
  13. murzina

    ASP.NET

    I am just starting ASP after a long break. I have an error and I don't know how to fix it. Here it is below: XML Parsing Error: not well-formed Location: file:///C:/Users/Anastasia/Documents/Visual%20Studio%202008/WebSites/WebSite1/Second.aspx Line Number 1, Column 2:<%@ Page Language="VB"...
  14. murzina

    error type in ASP. NET

    I get the error below. What does it mean? XML Parsing Error: not well-formed Location: file:///C:/Users/Anastasia/Documents/Visual%20Studio%202008/WebSites/WebSite1/Second.aspx Line Number 1, Column 2:<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default"...

Part and Inventory Search

Back
Top