I am trying to insert a file into a database which uses SQL File Streaming. When I try to initialize the SqlFileStream object that I will be inserting with I receive a File Exception stating that the network path could not be found. The code in question is below: using (SqlFileStream sqlStream = new SqlFileStream(filePathName.Value, fi...
I have a simple two field form that stores its data in the database, for some reason it isn't working. I have verified that the connection string works, as it is used in another project I made. I didn't include the beginning of the first class or its page load. Code: protected void btnSubmit_Click(object sender, EventArgs e) { ...
Ok so i have this structure PRODUCTS * PRODUCT_ID (primary key) * PRODUCT_NAME CATEGORIES * CATEGORY_ID (primary key) * CATEGORY_NAME * CODE PRODUCT_CATEGORIES_MAP * PRODUCT_ID (primary key, foreign key to PRODUCTS) * CATEGORY_ID (primary key, foreign key to CATEGORIES) * QUANTITY I am using this query SELECT * FROM `products...
How does one create date/time ranges for TIMESTAMP WITH TIMEZONE timestamps with a range precision down to the level of seconds? Here is my sample query, however I can only create ranges down to the day level: SELECT COLUMN_NAME, MY_TIMESTAMP FROM TABLE_NAME WHERE (MY_TIMESTAMP BETWEEN SYSDATE - INTERVAL '1' DAY AND SYSDATE - INTERV...
I've done some complex SQL queries, but never joined two tables by multiple values, and im not sure is it is possible. I've the following two tables: users +-------+----------+ | u_ID | username | +-------+----------+ | 1 | Pablo | +-------+----------+ | 2 | Mike |...
Hi, in sql server 2005 there is initialization icon on the RS config manager but not in SQL server 2008/R2.. does anyone know? using SQL server 2008 R2 and receving the error: The report server installation is not initialized. (rsReportServerNotActivated) (rsRPCError) Get Online Help ...
I have a customers table as following: customername, ordername, amount ============================= bob, book, 20 bob, computer, 40 steve,hat, 15 bill, book, 12 bill, computer, 3 steve, pencil, 10 bill, pen, 2 I want to run a query to get the following result: customername, ordername, amount =========================...
When I try to connect to a database that was previously opening with a SQL connection I get a "File in Use" error. Process Explorer tells me that sqlservr is still holding the file. Any ideas on how to get sql to release the file from within the vb.net 2010 code? ...
Is it even possible to create an abstraction layer that can accommodate relational and non-relational databases? The purpose of this layer is to minimize repetition and allows a web application to use any kind of database by just changing/modifying the code in one place (ie, the abstraction layer). The part that sits on top of the abstra...
This is my sql query: select case when table.field1 = 1 then 1 when table.field2 = 3 then 3 when table.field2 = 4 then 4 when table.field3 = 1 then 5 else .... Status //item name from table I want that in case the "else" occurs -> the row will be removed from the dataSet. I can't use "St...
how to find size of table in SQL? ...
How Can I make a left join in qcode/qcubed and select fields from both tables. ( no FK exists but there are fields that are logical to join ). ...
I have a windows batch file that does this: for %%s in (*.sql) do call It loops through all the sql script in a folder. In the folder the file names are like: s4.06.01.sql s4.07.01.sql s4.08.01.sql s4.10.01.sql s5.01.sql But the for loop goes through the files randomly (not in the name order), it first run s5.01, then s4.06, then s4...
My situation is i have four tables Patient, Receipt, Clinic and Laboratory. CREATE DATABASE TestHosp GO USE TestHosp GO Information about patient CREATE TABLE Patient (Id INT Not NULL PRIMARY KEY IDENTITY(1,1), FirestName VARCHAR(12) NOT NULL, LastName VARCHAR(12) NOT NULL, Birthday DATETIME) CREATE TABLE Clinic (Id INT N...
VARIABLE StayWorkflow_Id_max number; BEGIN SELECT max(StayWorkflow_Id)+1 into :StayWorkflow_Id_max from MVStayWorkflow; END; / insert into MVStayWorkflow (StayWorkflow_Id, Stay_Id, Passage_Id, User_Id, RespUnit_Id, Resource_Id, WorkflowAction, CurrentState, PreviousState, WorkflowTime, UserStamp, TimeStamp) ...
Need to backup Database Users and Logins for particular database from prod server and restore it to Dev server ?hw can i proceed ...
hi folks, i'am using eclipseLink with jpa. in my persistence.xml, i defined to generate a create.sql file. the file will be generated, but with missing ';'-separators for each sql statement. is there a possibility to define a separator in the persistence.xml or in some other way? regards bva Example persistence.xml: <provider>o...
Morning, is it possible to order sql data rows by the length of characters? e.g. SELECT * FROM database ORDER BY data.length() ...
I've previously used sql-oracle just fine in Xemacs on XP and vista. However, now I'm using Postgresql psql on the command line but I kinda find it lame (as compared to using sql-* from within emacs) So, I'm trying to get it(psql) working within xemacs(21.4.22) on windows. When I type M-x sql-postgres ENTER, I get the following 3 pro...
Hello, i have a database and I want to sort the a column according to the number of words included in each field. Ex: a b (has 2 words) a b c d e (has 5 words) a b c (has 3 words) And i want 'a b c d e' to be the first in sort result, and 'a b c' the second. .. etc Do you have a solution fot it? Edit: Thanks guys for quicly answer...