I'm looking for a way to do something analogous to the MySql dump from SQL Server. I need to be able to pick the tables and export the schema and the data (or I can export the schema via SQL Server Management Studio and export the data separately somehow). I need this data to be able to turn around and go back into SQL Server so it need...
Hi, I need to display the table name in the select statement. how? exact question: we have common columns in two tables. we are displaying the records by using select column_name from table_name_1 union select column_name from table_name_2 But the requirement is, we need to display the source table_name along with the data. cons...
I'm currently migrating a customers application from ColdFusion on Windows with SQL Server to ColdFusion on Linux with MySQL and I'm running into some issues recreating their views with regards to joins. Can anyone help me work out how the following should be converted. SELECT <columns> FROM assetType INNER JOIN assets INNER JOIN ...
I have a passion for meta-queries, by which I mean queries that answer questions about data rather than answering with data. Before I get a lot of justified criticism, I do realize that the approach of meta-queries is not ideal, as eloquently described here for example. Nevertheless, I believe they do have their place. (So much so that ...
I have 2 tables as follows (sample data shown): TableName: A ID Type 1 Bug 2 Requirement 3 Task 4 Specification 5 Bug 6 Specification 7 Production Issue 8 Production Issue 9 Bug 10 Task Tablename: B ID RelatedID 1 2 1 7 5 8 5 4 9 6 9 10 I want to fetch all the bugs that have atleast one related p...
Hello, I can connect to sql server reporting services both in the browser and through studio manager, but with problems. In the browser, there's no "site sections" at the top or anything in the tab area (content, etc). In Studio Manager, when I expand the "Home" node, I get the error "Failed to retrieve data for this report.....The pe...
I'm using an oledb data source in an SSIS package to pull a column from a database. The column is XML data type. In SSIS, it is automatically recognized as data type DT_NTEXT. It's going to a script component where I'm trying to load it into a System.Xml.XmlDocument. This is the code that I'm using to get the xml data into a string: Sys...
I have been looking around the current options (and related SO questions) regarding PHP ORM solutions, however I have a couple of unique requirements: I am running PHP on Windows Server 2003 I need to interface with SQL Server 2005 I can't seem to find a simple answer from the PHP ORM solutions out there as to which (if any) support ...
I am going on a job interview and have zero experience with MS SQL Server. However I have 1 year with Oracle. Is there such a huge difference between the two? What programming questions can I expect? ...
I'm trying to use SOAP headers to allow for SQL Authentication while accessing a webservice published on my SQL 2005 box via HTTP Endpoint. On the endpoint, I've set Authentication = (Basic), Ports = (SSL), and LOGIN_TYPE = MIXED. I'm able to generate the WSDL and consume it just fine in VS utilizing domain credentials. However, when ...
There is a project in flight at my organization to move customer data and all the associated records (billing transactions, etc) from one database to another, if the customer has not had account activity within a certain timeframe. The total number of rows in all the tables is in the millions. Perhaps 100 million rows, with all the vari...
Ok, I've been doing a lot of reading on returning a random row set last year, and the solution we came up with was ORDER BY newid() This is fine for <5k rows. But when we are getting >10-20k rows we are getting SQL time outs, the Execution planned tells me that 76% of my query cost comes from this line. and removing this line increa...
It is very simple to do paging on access database (using absolute and pagesize) but I heard its hard to do paging on SQL Server database. How do I do I add simple paging to the following codes. <% SQL = "SELECT I.IMAGESID, I.IMAGESNAME, I.IMAGESSMURL" SQL = SQL & " FROM IMAGES I" Set objImages = objConn.Execute(SQL) %> ...
I have a solution file in BI that contains 10 report projects. I publish these projects manually with every change. I want to know that is there a solution to deploy these projects on report server programmatically? ...
Can I write the T-SQL like below select * FROM (select * from TableA where FieldA = 1 ) where FieldB > 10 which means I want to query from the results of another query. ...
I need to deploy a Sql Server Express 2008 database in unattended installation using command line or AutoIt, and I need to : 1.- Set sa password. 2.- Disable built-in\Administrators account to deny login. 3.- Attach a database with all users accounts enabled. Thx ...
I have created a statistics in a table using SQL SERVER 2008 . In which system table this information is getting stored (Just like all the table info are stored in in sys.tables)...? ...
I want to print a report (RDL) directly without previewing it. Is there a solution for this work? ...
Hi all, This is a one typical Question asked my boss.. Q: how to select the value which are nulls in Database using LIKE operator.. I tried like below: select c.ClaimID from claim c where c.InjuredPartyFirstName like (''+coalesce(c.InjuredPartyFirstName,'')+'') But this also not working........ Please help some one Thanks in Ad...
We are using a custom Membership Provider in an ASP.NET MVC application. We have been experiencing intermittent 'System.InvalidOperationException - There is already an open DataReader associated with this Command which must be closed first.' problems with the class so I decided to enabled MARS. This is the connection string in the web c...