From the column_constraint page on MSDN: ON DELETE { NO ACTION | CASCADE | SET NULL | SET DEFAULT } Specifies what action happens to rows in the table that is altered, if those rows have a referential relationship and the referenced row is deleted from the parent table. The default is NO ACTION. So, … Read more
You can try to use Create Table As command like this: CREATE TEMP TABLE mytable AS SELECT * from source_tab; From the docs: This command is functionally similar to SELECT INTO, but it is preferred since it is less likely to be confused with other uses of the SELECT INTO syntax. Furthermore, CREATE TABLE AS … Read more
With cte as ( select top(1) shipfirtsname From ShipBillInfo where CustomerId=’134′ order by OredrGUID desc) Update cte set shipfirstname=”abc”;
The SET needs to come before the FROM\JOIN\WHERE portion of the query. UPDATE CE SET sJobNumber = AD.JobNumber FROM CostEntry CE INNER JOIN ActiveCostDetails As AD ON CE.lUniqueID = AD.UniqueID WHERE CE.SEmployeeCode=”002″ AND SubString(CostCentre, 1, 1) = sDepartmentCode AND substring(CostCentre, 3, 1) = sCategoryCode AND substring(CostCentre, 5, 2) = sOperationCode
The semantic of the relationship doesn’t look right. I think it should be something like: class Restaurant(db.Model): … dishes = db.relationship(‘Dish’, secondary=restaurant_dish, backref=db.backref(‘restaurants’)) Then, to retrieve all the dishes for a restaurant, you can do: x = Dish.query.filter(Dish.restaurants.any(name=name)).all() This should generate a query like: SELECT dish.* FROM dish WHERE EXISTS ( SELECT 1 FROM restaurant_dish … Read more
Use dbms_lob.instr and dbms_lob.substr, just like regular InStr and SubstStr functions. Look at simple example: SQL> create table t_clob( 2 id number, 3 cl clob 4 ); Tabela zosta│a utworzona. SQL> insert into t_clob values ( 1, ‘ xxxx abcd xyz qwerty 354657 [] ‘ ); 1 wiersz zosta│ utworzony. SQL> declare 2 i number; … Read more
Check if its null OR your condition like this: WHERE {client_id} IS NULL OR sr.client_id = {client_id} The WHERE clause evaluate as follow: If the variable is empty, then the WHERE clause evaluate to true, and therefore – no filter. If not, it continue to the next condition of the OR
Using SetTriggerOrder is fine, but if your code depends on a specific sequence of execution, why not wrap all your triggers into stored procedures, and have the first one call the second, the second call the third, etc. Then you simply have the first one execute in the trigger. Someone in the future will be … Read more
You can use Hibernate Dialect API for Database independence as follow class SequenceValueGetter { private SessionFactory sessionFactory; // For Hibernate 3 public Long getId(final String sequenceName) { final List<Long> ids = new ArrayList<Long>(1); sessionFactory.getCurrentSession().doWork(new Work() { public void execute(Connection connection) throws SQLException { DialectResolver dialectResolver = new StandardDialectResolver(); Dialect dialect = dialectResolver.resolveDialect(connection.getMetaData()); PreparedStatement preparedStatement = … Read more
To locate the troublesome row use the errorfile specifier. BULK INSERT myData FROM ‘C:\…\…\myData.csv’ WITH ( FIELDTERMINATOR = ‘,’, ROWTERMINATOR = ‘\n’, ERRORFILE = ‘C:\…\…\myRubbishData.log’ ); myRubbishData.log will have the offending rows and a companion file myRubbishData.log.txt will give you row numbers and offsets into the file. Companion file example: Row 3 File Offset 152 … Read more