Hello all, i play whit CREATE VIEW's in MySQL 5, now i have a troble, how can i make sure when i use this code. SELECT * FROM view_shop_invoicer_list WHERE accept_date >= '2009-10-16 00:00:00' AND accept_date <= '2009-10-31 23:59:59' AND shopid = [SHOPID]; my VIEW look like this, down here, and it will not take ...
I am using SQL Server 2000 and feeling stuck about how to do this: I have a stored procedure that returns a single resultset which is bound to a gridview in a .Net web app. Now I'd like to have a "table" so I can use it in an existing VB6 application like this: SELECT * FROM myTable ...where the schema of "myTable" is reflects the...
Hi, I created a MySQL view using UNION ALL from two tables so that I would get the same column names for the same data in those tables (i.e. tbl1.author2 AS translator ... tbl2.translator AS translator) and so on, the problem is when I try to select something from that view, half of the data comes out as BLOB, instead of the original val...