User Profile

Collapse

Profile Sidebar

Collapse
askohen
askohen
Last Activity: Mar 24 '08, 07:50 PM
Joined: Mar 24 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • askohen
    replied to Create Table Conditional
    in SQL Server
    Any hints on how to do this? I created a test trigger, but not sure how to go forward,

    Code:
    CREATE TRIGGER test_howto
	ON howto
	FOR INSERT
		AS Print('foo');
GO
    See more | Go to post

      Leave a comment:

    • askohen
      replied to How can I start?
      in Python
      Learning Python is a pretty good book too. But I think that assumes some programming experience. But not as much as Diving Into Python.
      See more | Go to post

        Leave a comment:

      • askohen
        started a topic Create Table Conditional
        in SQL Server

        Create Table Conditional

        I have this CREATE TABLE statement:

        [CODE=mysql]CREATE TABLE howto (
        id INT IDENTITY(1,1) PRIMARY KEY,
        title VARCHAR(100) UNIQUE NOT NULL,
        url VARCHAR(20) UNIQUE NOT NULL,
        order_on_homepa ge SMALLINT UNIQUE, --just put an order on this and if it's not null, then its on the homepage
        CONSTRAINT CK_HOWTO_URL CHECK(url != ''),
        CONSTRAINT CK_HOWTO_TITLE CHECK(title != '')
        );
        ...
        See more | Go to post
        Last edited by debasisdas; Mar 25 '08, 06:45 AM. Reason: added code=mysql
        No activity results to display
        Show More
        Working...