ddl
SQL query error - can't see why?
I\'m currently reading through this Yii applica开发者_如何学Pythontion eBook: http://www.packtpub.com/agile-web-application-development-yii11-and-php5/book - and I\'m having a problem inputting the tu[详细]
2023-03-14 16:26 分类:问答Using a Default Value on Null Entry in Sybase
Good morning, I have a question regarding default values and NULL values in Sybase ASE 12.To make a long story short: I have inherited a very old Sybase database as well as the PowerBuilder front end[详细]
2023-03-12 08:36 分类:问答VB.Net, MVC3, Razor, EF 4.1 DB First, and Linq - Populating DDL Options and Values
Background - I\'m trying to populate a drop down list with state information from a database. I\'d like the full state name to be the option and the state abbreviation to be the value. Example:[详细]
2023-03-10 22:19 分类:问答drop tablespace if do not exist
I have written pl/sql script (works, but doesn\'t look nice): DECLARE v_exists NUMBER; BEGIN SELECT count(*) INTO v_exists FROM dba_tablespaces WHERE tablespace_name = \'hr_test\';[详细]
2023-03-09 14:42 分类:问答Generate DDL for JPA 2.0 with EclipseLink
I\'ve created my model classes with JPA 2.0 annotations. At runtime, I will use EclipseLink 2.2.0, but I\'ve been careful to use only pure JPA annotations in my model classes.[详细]
2023-03-06 04:14 分类:问答How to find out the name of the constraint CHECK of a field in the MSAccess database?
I am implementing a solution for updating the schema of MSAccess databases on customer site andI am using DataWeigher to generate the update script.[详细]
2023-03-04 16:16 分类:问答Delete column from SQLite table
I have a problem: I need to delete a column from my SQLite database开发者_运维知识库. I wrote this query[详细]
2023-03-04 12:21 分类:问答How can I create multiple views in a stored procedure?
I want to create a temporary stored procedure to create several views; so something like this: create proc #t1 as[详细]
2023-02-25 18:25 分类:问答what is the importance of the SSMS generated commands (ansi nulls, quoted ident, ansi pad, etc..)
Here\'s the generated script from SSMS \"Script Table as\"->\"Create To\": USE [DADatabaseMarch11] GO SET ANSI_NULLS ON[详细]
2023-02-25 10:56 分类:问答Script Oracle tables (DDL) with data insert statements into single/multiple sql files
I am needing to export the tables for a given schema, into DDL scripts and Insert statements - and have it scripted such that, the order of dependencies/constraints is maintained.[详细]
2023-02-21 10:59 分类:问答