I have a table (on sqlserver05) with an xml column. The format of the column is similar to this: <doc> <field name="a">foo</field> <field name="b">bar</field> <field name="c">fizz</field> <field name="d">buzz</field> </doc> I would like to copy a subset of that xml to a new xml column, for instance: <doc> <field name="...
I'm having a problem trying to make my LINQ to SQL queries and the mapping to my domain objects DRY without incurring the cost of multiple round trips to the db. Given this example: var query1 = from x in db.DBProducts select new MyProduct { Id = x.ProductId, Name = x.ProductName, ...
Is it possible to connect to Sql Server for the purpose of executing simple Sql commands within a native iPhone app? If so, how does one go about it? I'm stumped. More generally, I would at least like to see how this is done with GCC. Thanks in advance, Rich ...
I am building a application in silverlight which will enable users read information about their payment. Their login and password will be save in table in db. It is possibility to improve security in my app by limiting what data a query has access to? For instance i want to prevent a user from selecting data they do not own. A limitati...
Hello We got a script to disable FK constraints by passing 'D' deactivate 'A' for activate. Once these are disabled, they get enabled back again after couple of hours or a day. What could be the reason ? Script is as below: CREATE PROCEDURE [dbo].[sp_DisableEnableForeignKeys] @PutFK CHAR(1) as DECLARE @IdFK integer DECLARE @Foreig...
I have some really good books for SQL Server, like: SQL Server 2008 Bible Pro SQL Server 2008 - Relational Database Design and Implementation SQL Server 2008 for Developers. Can you suggest/recommend some other titles, that may address other topics perhaps, that you found truly useful? ...
I have two tables, to be concise let’s call them TableA and TableB. This is the schema: TableA ID – int Name varchar(50) TableB ID – int TableA_Fk – int Value varchar(50) Each record in table A can have at most 9 records in table B. I want to be able to retrieve the data in a columnar form: TableA-Name, TableB-Value1, … TableB-Value...
I came across this question after searching for a ODBC or JDBC. To my surprise, since I am new to db4o I found there are tools to browse db4o, including a Netbeans and Eclipse plug in. However, when it comes to the question at hand, I only found one company, and the product is not being sold nor demoed (makes me think is not ready yet). ...
i downloaded and installed AdventureWorks db for sql server 2008. do u know if there are any exercises or tutorials for it? i want to practice my SQL select statements ...
Does anyone know of any tools that can be used to visualize data in a SQL Server database? I'm specifically interested in a tool that can show measures such as number of rows, size of table in bytes, number of columns, using multi-dimensional graphs. A 2D example might use a circle for each table, where the relative size of the circle...
Table1 ID product 001 LG 001 Sony 001 LG 001 LG 001 Sony 001 BPL 001 BPL 001 Samsung 002 LG 002 BPL 002 LG ..., I want to take each product count for each personid. Expected Output ID BPL LG Samsung Sony 001 2 3 1 2 002 1 1 0 0 .., How to make a query of taking each product count for each personid. Need SQL Query Help. ...
I have just downloaded SQL Server 2005 express edition from here: To be used as a database for a vb.net program. But I'm confused in using sql server. I do not know where to start from here: http://screencast.com/t/ZTdiMDU5 Do I have to create the database in vb.net?--> http://screencast.com/t/ZjRlYjkx If not, where could I create...
I want to restore a database backup existing beside the application in setup time. I have custom action and in the install method need to restore the database with the backup file. When I use SQL Server 2008 Express edition I got error. please help me. ...
How to retrieve data from two tables whose column names are the same? ...
Can Anybody tell me when to use with clause. ...
I need to pull data from one SQL 2005 Express database to another and I need to do this periodically. It is not a straight copy from one table to another, but I would use different views from the source table. I also need to do this periodically. My first idea is to write a small application in C# and run it somehow in every hour or so...
I do not not know much about Regex, I want to try parsing sting from database according to flowing instructions. I know that I am need to use CLR but for begin I want to learn Regex Data in tables look like create table #tempTBL (opis varchar(40)) go insert into #tempTBL select 'C 136' union select 'C 145' union select 'C146' union ...
how to convert a binary(128) from little endian to big endian in SQL Server? ...
Hi. A have a database on MS-SQL Server 2008 that is growing a lot, year by year. What I want to do is: take some data and store in a XML file, and store this file in a table, at the same database. Is this a good idea? Do you have any idea? Thanks. ...
I have a CakePHP app that is being moved to Sql Server from MySql. There is one query that does not seem to transfer correctly: $this->Model->find('all', array( 'conditions' => array( 'Model.column' => array(1, 2, 3) ) ) ); When I use this syntax with mysql, it seems to 'unpack' the array correctly, and...