Logging SQL in Weblogic Server 8.13
Hi, I am trying to print out the SQL statement that my EJB uses to create record in the database into a log file. Does anyone have any experience to do this. thank you. Cheers, ...
sql
What is the best way to delete a joined association to a stored file in a database?
I want to know the sql statement(s) to use to delete old data and the association to the old data without deleting the more important parent table, which should live forever. I have the following tables: Step Id bigint OccurredOn datetime ScreenshotId bigint Screenshot Id bigint Data varbinary(max) I want to delete all Scr...
Is it bad to put WITH PERMISSION_SET = UNSAFE in SQL 2005?
Hi I need to use CLR to make a stored procedure that uses stuff in .net 3.5. If I don't put Permission_Set = UnSafe I can't do it it will just die and give me this error Deploy error SQL01268: .Net SqlClient Data Provider: Msg 6503, Level 16, State 12, Line 1 Assembly 'system.core, version=3.5.0.0, culture=neutral, publick...
Easy SQL Select Case When Statement throwing an incorrect syntax error and I can't find it!
Thank you to everyone who tries to help! I have 2 case select statements and I get the error on this statement: Center, Case Center When 'Concord Call Center' Then 'CCC' When 'Livermore Call Center' Then 'LCC' When 'Morgan Hill Call Center' Then 'MHCC' When 'Natomas Call Center' Then 'NCC' When 'Virtual Call Center' Then 'VCC' Else Cen...
How to make this CLR work with 2005?
Hi I am trying to make a clr stored procedure for a sql 2005 database that uses .net 3.5 assemblies So first I had to change sql 2005 to recognize system.core as unsafe what I am not too happy about(I rather have had it say SAFE). Now I get this error Msg 6522, Level 16, State 1, Procedure StoredProcedure1, Line 0 A .NET Framework e...
How can I refactor this django query to not select each individual object?
Here's my view: def rsvp_list(request, id, template="rsvp/rsvp_list.html"): rsvp = RSVP.objects.get(id=id) return render_to_response(template, { 'attendees': rsvp.attendee_set.all().order_by('email__first_name'), }, context_instance=RequestContext(request)) and here's my template: {% for attendee in attendees %...
Import multiple queries written in SQL into access
I've got to write 50 relatively simple queries, that all use the same basic form, but each successive query depends on the one before it to run. I can quick and easily write the queries in SQL in an text editor e.g. word, but I dont know how to import the text back into access. Nor do I know how to specify the name of the query in the S...
question for h2 which is faster?
now I have two choice. I have the same schema for all the data. the record stand for the connection between to hosts.So one record belongs to two hosts. now I do the action that once I need to get the connection of 1 host. I will insert the record in to h2. So if there is a connection between host1 and host2. Everytime I query the conne...
SQL Update Using From
I know this is a contrived example so please do not jump all over me for the uselessness of the code. This is an issue in more complex chunk of code but I wanted to isolate the I am having. The error I am getting is 'SQL Error: ORA-00933: SQL command not properly ended'. Any ideas? I am using SQL Developer by the way. Once again...this...
SQL Virtual Column
I am getting the 'SQL Error: ORA-01733: virtual column not allowed here' Here is my code: update ( Select g.FIRST300BB from ( select FIRST300BB, row_number() over (order by pitchandeventid) r from gamedata_me where hitterid = 5000 and (eventcode = 'BB') ) g where r between 0 and 300 ) t set t.FIRST30...
Basic database design about intermediate optional models
I'm working on a project in which I'm having slight difficulties coming up with the design for a seemingly very simple scenario: user belongs to city which belongs to country, however, the city reference may be null while user must belong to a country nevertheless. In other words (in basic RoR model syntax), # class User < ActiveRecord...
help for sql query
i have table with name sample in my database it has threecolumns namely words,D1,D2 and it has some data like below Words D1 D2 D3 pleasure 1 0 1 question 0 0 0 answer 0 1 1 request 1 0 0 scount 1 0 0 so now i want to calculate parameter N00 which means scount=...
Fetching fetch the first occurance from the result.
Hello, I have a oracle sql select distinct tab1.col1, tab2.col1 from table1 tab1 join table2 tab2 on tab1.col1 = tab2.col1 Here i get the as expected in terms of distinct values. For Example : The result rows are 1 2 3 4 5 6 Now i want to add one more join for table3. so my sql is select distinct ...
sql per month identity
is it possible to create a per month identity ? basically what I need is create table ( id identity primary key regDate DateTime not null, regDateNumber int not null ) and when I insert data I need set the regDateNumber as an identity in the scope of the regDate's month like this: id regDate regDateNumber 1 1 jan 2008 1 2 ...
Viewing oracle's metadata about primary/foreign key constraints.
Which table contains detailed information(For example the table the foreign key is referring to) about the constraints? The tables 'all_cons_columns' , 'all_constraints' contains only the name of the constraints which isn't very helpful. I am currently using dbms_metadata.get_ddl() but it doesn't work on all the databases. Thanks. ...
Sql Server replication over wan
Im looking at developing a simple ecommerce platform and need to replicate product and customer data to the web host over the internet so the website can run disconnected. The two options i can think of at present are using enterprise messaging and database replication. Im leaning towards database replication over enterprise messaging ...
How to find a time delta of a datatime row in mysql?
I have a column in a database which provides datetime stamps for series of sensor readings. I'd like to segment those reading into unbroken, continuous sets of sensor readings. If a sensor reading is broken, then there will be a discontinuity in the date time column. And so I'd like to perform a query on the datetime column and then comp...
In SQL Server, how can I compare rows using the column names from another table
I have two tables A and B, with dynamic columns where I have no idea what columns are key inside them, except from another table called C. The C table specifies which column/s is a key column in tables A and B. There can be 1 or more key columns. My question is, how would I generate such a query where I select all rows from A where the...
error while working with reporting services in SQL server 2008 EXPRESS_ADVANCED`
While using reporting services in share Point Integrated mode, it throws error that reporting services cant be used in this version of SQLEXPRESS ADVANCED. I am currently using SQL Server 2008 R2 edition which supports Reporting services and it is also written that it supports SYNCING with Office Servers. I am confused now on which SQL v...
Standard SQL alternative to Oracle DECODE
Is there an ANSI SQL equivalent to Oracle's DECODE function? Oracle's decode function is the IF-THEN-ELSE construct in SQL. ...