Job interview question

Getting started with SQL Server

Index ‹ SQL Server
- Archive
  - SharePoint
  - Dotnet
  - VS Express
  - SQL Server
  - VFP
  - Architecture
  - Windows Live
  - Windows Vista
  - IE
  - Visual Studio
  - VB
  - Windows Forms
  - Office
  - VS 2008
  - Smart Device
  - Visual C#
  - Game
  - VC++
  - ISV

- Previous
  - 1
    - Navigation from the header Hello I have a link on the header to jump to another report. It was working fine on test server but when deployed to production, is giving the followin error. Any suggestions Thanks Inder The path of the item "(null)" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. (rsInvalidItemPath) Tag: Job interview question
  - 2
    - Problems trying to insert data into the database using excel Hi all, I have encountered a problem. In the past i run a sql query to select all the data from the excel file and insert them into my SQL database. However recently i encountered an error when i run the query. Msg 7399, Level 16, State 1, Line 4 The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "excel_ls" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 4 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "excel_ls". How i solve this error. Any ideas Thanks Tag: Job interview question
  - 3
    - tempdb Log file - stop/start SQL Server to reset tempdb??? On a 24/7 availability system you size your tempdb for what is required to run the system. Generally if you are having to reduce it in size then you are taking away space that it needs during normal processing and it will need to reclaim that space (assuming it is available) later. If the space is not available then it will stop (at least the user process and possibly the SQL Server). In SQL Server 2005 tempdb is more heavily used and so generally needs more space than it did before. Here is a link to a Microsoft white paper that goes into more details. http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx It does include information on shrinking tempdb if that is what you decide to do (but it does recommend against it). Tag: Job interview question
  - 4
    - Code to flatten a CellSet into a datatable Hi, Here's some code I've written which flattens a CellSet into a datatable. I looked for a long time to find similar code but could not find any. Can I please have some thoughts on optimisation/elegance etc... I'm a bit new to .NET so any advice would be great! Thanks. Code Snippet Public Function GetFlatData() As DataTable 'If (Me.Cells.Count = 1) Then ' Return New DataTable() 'End If Dim table As DataTable = New DataTable() Dim headers As ArrayList = New ArrayList() For a As Integer = 0 To (Me.Axes.Count - 1) For i As Integer = 0 To (Me.Axes(a).Set.Hierarchies.Count - 1) Dim h As Hierarchy = Me.Axes(a).Set.Hierarchies(i) If (Not h.Name.Contains("Measure")) Then table.Columns.Add(h.Name) End If Next i Next a Dim items As ArrayList = New ArrayList() For x As Int32 = 0 To (Me.Axes(0).Set.Tuples.Count - 1) Dim tx As Tuple = Me.Axes(0).Set.Tuples(x) Dim itemBase As CellItem = New CellItem() For Each mx As Member In tx.Members If (mx.LevelName.Contains("Measure")) Then If table.Columns.IndexOf(mx.Caption) = -1 Then table.Columns.Add(New DataColumn(mx.Caption, GetType(Double))) End If itemBase.AddMeasure(mx) Else itemBase.AddAttribute(mx) End If Next If (Me.Axes.Count > 1) Then For y As Int32 = 0 To (Me.Axes(1).Set.Tuples.Count - 1) Dim item As CellItem = itemBase.Clone(True) Dim ty As Tuple = Me.Axes(1).Set.Tuples(y) Dim memy As Member For Each memy In ty.Members If (memy.LevelName.Contains("Measure")) Then item.AddMeasure(memy) Else item.AddAttribute(memy) End If Next item.ValueCell = Me.Cells.Item((y * Me.Axes(0).Set.Tuples.Count) + x) 'item.ValueCell = Me.CellGrid(x, y) items.Add(item) Next Else ' for 1 axis cellsets itemBase.ValueCell = Me.Cells.Item(x) items.Add(itemBase) End If Next '' might have no measures need to cater For i As Integer = 0 To (items.Count - 1) Dim row As DataRow = table.NewRow() Dim attributes As ArrayList = (CType(items(i), CellItem)).Attributes For j As Integer = 0 To (attributes.Count - 1) Dim member As Member = CType(attributes(j), Member) row(j) = member.Caption Next Dim measures As ArrayList = (CType(items(i), CellItem)).Measures If Not measures Is Nothing Then ' each CellItem should only have one measure For j As Integer = 0 To (measures.Count - 1) Dim member As Member = CType(measures(j), Member) Dim value As Cell = (CType(items(i), CellItem)).ValueCell If Not (String.IsNullOrEmpty(value.Value)) Then 'need to set appropriate type accroding to cell 'table.Columns[member.Caption].DataType = value.CellProperties. row(member.Caption) = value.Value Else row(member.Caption) = DBNull.Value End If Next End If table.Rows.Add(row) Next Return table End Function #End Region #Region " Private Classes " Private Class CellItem Private _measures As ArrayList Private _attributes As ArrayList Private _valueCell As Cell Public Property Attributes() As ArrayList Get Return _attributes End Get Set(ByVal value As ArrayList) Me._attributes = value End Set End Property Public Property Measures() As ArrayList Get Return _measures End Get Set(ByVal value As ArrayList) Me._measures = value End Set End Property Public Property ValueCell() As Cell Get Return _valueCell End Get Set(ByVal Value As Cell) _valueCell = Value End Set End Property Public Sub New() _attributes = New ArrayList() _measures = New ArrayList() End Sub Public Sub New(ByVal attributes As ArrayList, ByVal measures As ArrayList, ByVal valueCell As Cell) Me.Attributes = attributes Me.Measures = measures Me.ValueCell = valueCell End Sub Public Sub AddAttribute(ByVal o As Object) _attributes.Add(o) End Sub Public Sub AddMeasure(ByVal o As Object) _measures.Add(o) End Sub Public Function Clone(ByVal isDeep As Boolean) As Object If (isDeep) Then Dim item As CellItem = New CellItem(Me.Attributes.Clone(), Me.Measures.Clone(), Me.ValueCell) Return item Else Return New CellItem(Me.Attributes, Me.Measures, Me.ValueCell) End If End Function Tag: Job interview question
  - 5
    - LIKE HI,I want the synthaxe of a query with "LIKE" knowing that the fields must contain strings then a parametre then strings I tested with this synthaxe but it is not true: New_VilleExtensionBase.New_name LIKE “%” + @param1 + “%” How is that done Tag: Job interview question
  - 6
    - How to specify the MSSQL.1 DATA folder in SQL Express? Thanks Jon. We do that already. My data is installed in x:\MSSQL2005\InstanceName\ MSSQL than adds: x:\MSSQL2005\InstanceName\MSSQL.1\MSSQL\DATA but if someoneelse has installed a different app I would get x:\MSSQL2005\InstanceName\MSSQL.2\MSSQL\DATA The problem is I don't have any control over the last part. Tag: Job interview question
  - 7
    - Is Full-Text Index really that much overhead? As Rich has mentioned, A solid argument would be that an out-of-the-box solution already exists. It doesn't make sense to re-invent the wheel especially considering the time/labor costs associated with development, testing, and documentation. Equally, cursors carry a lot of overhead on the server but they do have their place. It wouldn't make sense for a DBA to argue that a developer can easily loop through the records without an equal amount of overhead. This simply isn't logical. Adam Tag: Job interview question
  - 8
    - Hourly Data Would you expect to see the results broken down by day, or would you want to see the total number of rows for the 3 o'clock to 4 o'clock period (for example) for all days represented by a single row e.g. Either: Day 1, Hour 3, 564 Day 2, Hour 3, 989 Day 3, Hour 3, 43 etc... or a single row for hour 3 for all three days: Hour 3, 1596 Chris Tag: Job interview question
  - 9
    - What happens when the 4 GB database size limit is reached? Thanks! But the database will still be usable (readable) after this exception occured It doesn't become corrupted by that, I hope Tag: Job interview question
  - 10
    - Can I debug a SQL 2005 stored procedure with the SA account I want to know if I can debug stored procedures remotely with the SA account. I can not have Active Directory in my system right now. Thanks Tag: Job interview question
  - 11
    - What permission required to DROP TABLE ? this will never work: " GRANT DROP TABLE TO username" because DROP is not grantable. This will work: USE dbname GRANT CREATE TABLE TO username EXECUTE AS USER = ' username ' go CREATE TABLE T1 (c1 int) go REVERT go GRANT CONTROL ON tablename TO username EXECUTE AS USER = ' username ' go DROP TABLE T1 go REVERT go hth, -Steven Gott S/DET SQL Server Tag: Job interview question
  - 12
    - Clarification on product specification http://www.microsoft.com/sql/editions/compact/sscecomparison.mspx The above link says the pros and cons of two SQL Server 2005 editions. Document says Compact Edition is not good for ‘When you need a multi-user database server ’. What is the meaning of multi-user database Does this means the database strictly will not support two database connections at a time -Thank you, Gish Tag: Job interview question
  - 13
    - SP to search on any number of characters Thank you gentleman for your assistance. I now have a number of options from with which to choose. I discovered (after days of research & testing) another method that would allow me to pull only the data I needed. I had to use a JOIN Clause in my SP and it pulls only the data I type into a textbox control. Wallace Tag: Job interview question
  - 14
    - Is there a way to parameterize lock type? Basically I want to avoid SQL code duplicates. The stored procedure needs to select some stuff before updating data. Selection can be done using other stored procedure, but to avoid deadlock I want to select data with UPDLOCK hint. I know that data are going to be updated, so locking them earlier just helps against deadlock. And if I can't parameterize it, I need to have two versions of SP with data selection: one that just selects data (for readonly purposes) and the other one that selects with update lock. Tag: Job interview question
  - 15
    - Conflicts in Merge Replication Hello, Use the processing_order parameter of sp_addmergearticle stored proc, when adding articles to the publication. [ @processing_order = ] processing_order Indicates the processing order of articles in a merge publication. processing_order is int, with a default of 0. 0 specifies that the article is unordered, and any other value represents the ordinal value of the processing order for this article. Articles are processed in order from lowest to highest value. If two articles have the same value, processing order is determined by the order of the article nickname in the sysmergearticles (Transact-SQL) system table. For more information, see Specifying the Processing Order of Merge Articles. Thanks Udaya. Tag: Job interview question
  - 16
    - cluster install 2nd node unavailable Can you check thru this http://msdn2.microsoft.com/en-us/library/ms179530.aspx link and confirm whether you have following in same fashion. Tag: Job interview question
- Next
  - 1
    - Setting multi-value parameters using ReportExecutionService Does anyone know how to set multi-value parameters using ReportExecutionService in C# If I have rsExec = new ReportExecutionService2005. ReportExecutionService (); . . . ReportExecutionService2005. ParameterValue [] parameters = new ReportExecutionService2005. ParameterValue [2]; parameters[0] = new ReportExecutionService2005. ParameterValue (); parameters[0].Label = "Report_Begin_Date" ; parameters[0].Name = "Report_Begin_Date" ; parameters[0].Value = "4/15/2007" ; parameters[1] = new ReportExecutionService2005. ParameterValue (); parameters[1].Label = "SalesID" ; parameters[1].Name = "SalesID" ; parameters[1].Value = //Here, this parameter should accept multiple values like 200, 201, 202, etc. rsExec.SetExecutionParameters(parameters, "en-us" ); How would I set the SalesID to take multiple values Tag: Job interview question
  - 2
    - Calculated Fields in the report Why are you trying to substitute COUNT(*) for 1 The point of SUM(CASE ... 1 ELSE 0 END) is to do a conditional count *for* you. You are summing 1 (not an expression) for each row that fits your condition. See Nothing to substitute and no reason to use COUNT() <s>. >L< Tag: Job interview question
  - 3
    - Performance is degraded drastically after migrating to SQL Express 2005 from MSDE 2000 Hi, in sql2005 express you can use the same connectionstrings like in all other sql2005 editions. The following i use in a webproject and it works very fine: <connectionStrings> <clear/> <add name= "Sup" connectionString= "Server=.\SQLEXPRESS;Database=Support;Trusted_Connection=True; Asynchronous Processing=True;MultipleActiveResultsets=True;" providerName="System.Data.SqlClient"/> ... </connectionStrings> The "Server=.\" means the local machine. Here you can say every name where you will connect to. The "SQLEXPRESS" is the instance of the sql Server installed on the machine. Hope this helps Servus Klaus Tag: Job interview question
  - 4
    - extract information from tables Hello Guys, my collegue left the job and I have been chosen to work on his assignments. He posted this question before and got the answer but I couldn't find a way to implement it in the program. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1726638&SiteID=1 I changed the database a bit as I couldn't understand his logic of putting both PayID and TransNo as this would be a linked table and should have many to many relationship Code Snippet TransactionID int Unchecked TransNo varchar(50) Checked RefNo nvarchar(50) Checked FundCodeID smallint Checked TransAmount decimal(18, 2) Checked Description varchar(100) Checked TransPayID (from TransPayLnk Table as foreign key) Tbl_TransPayLnk Code Snippet TransPayID int Unchecked TransNo varchar(50) Checked TransDate datetime Checked Operator char(5) Checked TerminalID tinyint Checked Flagged char(1) Unchecked Remarks text Checked RemarksDate datetime Checked TPayment decimal(18, 2) Checked Tbl_Payment Code Snippet PaymentID int Unchecked PayType varchar(50) Checked Amount decimal(18, 2) Checked TransPayID (Foreign Key from Tbl_TransPayLnk) My requirement would stay the same, I would need to put the data from these 3 tables into a single line without duplicating the records and I would need to display them in a DataGridView. P.S: Would it be possible to have Mixed when a TransPayID is matched in Tbl_payment with more then one record rather then brining cash and cheque. Thank you all for your help. Bye Gemma Tag: Job interview question
  - 5
    - AWE working? Hi all, This is a question related to AWE settings. I am on windows 2003 ent version with SQL Server 2005 std version. I have configured SQL Server to use AWE and min memery as 22G and max as 26G (I have 32G in total as physical memory). I do see the message in log as "Windows Address ... Enabled", but when I am using performance monitor to view total memory in kb for SQL Server, it never starts at 22G (usually at 1G). And I doubt why The account I am running SQL Server is an admin account, so it can definitely locked down the pages in memory. Also, I do think AWE is working somehow, after several hours in running, the total memory will up to 8, 9 or 11G. So, apparently, it is over 2G per process limitation. I still want to know. 1. Is my AWE setting working 2. If not, how to fix that 3. How to confirm how many memory is actaully using by SQL Server Thanks, NIng Tag: Job interview question
  - 6
    - Problem with ID 17981 Hello, I’m trying to do an update through a system but this message display a problem that I didn’t get to identify exactly the problem to looking for a solution. "Table error: Object ID 17981, index ID 1, page (0:871674153). Test (offset + len < PAGESIZE) failed. Slot 10, offset 0x1a8 is i Error while undoing logged operation in database " Could anyone help me please Thanks, Mauricio Tag: Job interview question
  - 7
    - After restoring MASTER database, can't start SQLServer Service: Configuration block version 0 is not a valid version number Thanks. Anyway, I tried rebuilding and that DID work. But when I restored the master database, I was back where I started. I KNOW the database installations are the same version as I did SELECT @@VERSION on both and they match. So I don't understand why restoring a tape from one server to the other causes the other server to throw this error when the versions of the server do appear to be the same. Tag: Job interview question
  - 8
    - error: Could not find SP upd.sp_MSrepl_xxx_xxxxxx_1 The plot thickens... If I create a subscriber on the same box as the publisher (i.e. publisher & subscriber are both SQL2000) it all works fine. If the subscriber is SQL2005 it errors looking for SPs owned by 'upd'... Tag: Job interview question
  - 9
    - Plz do evaluate this SP Aravind: I think that for step #3 that you might be able to simplify this: Code Snippet Insert into @ResponseList (DynamicQuestionID , Response , SortOrder) select a.DynamicQuestionID , b.Response , a.SortOrder From DynamicRegistration_QuestionOption a left outer join DynamicRegistration_QuestionResponse b on a. DynamicQuestionID = b.DynamicQuestionID And a.QuestionOption = b.Response Where a.DynamicQuestionID = @DynamicQuestionID --'B440AC87-FC53-4735-A6D8-EB4DBFD9D447' And b.UserID = @userID And a.Inactive = 0 order by a.SortOrder Select @count = count(*) From @ResponseList IF (@count > 0 ) Begin While (@loop < 3) Begin if Exists(Select * from @ResponseList Where Pos = @loop) Begin Insert into @ResultSet (ResultValue) values(1) End else Begin Insert into @ResultSet (ResultValue) values(0) End Set @count = @count + 1 Set @loop = @loop + 1 End End Else begin Insert into @ResultSet (ResultValue) values(0) Insert into @ResultSet (ResultValue) values(0) Insert into @ResultSet (ResultValue) values(0) end Select case ResultValue When 0 Then 'False' Else 'True' End as ResultValue from @ResultSet return END to something like this: Code Snippet select case when y.Seq is not null then 'True' else 'False' end as ResultValue from ( select 1 as Seq union all select 2 union all select 3) x left join ( select row_number() over ( order by a.SortOrder, a.DynamicQuestionId ) as Seq, a.DynamicQuestionID, b.Response, a.SortOrder From DynamicRegistration_QuestionOption a left outer join DynamicRegistration_QuestionResponse b on a. DynamicQuestionID = b.DynamicQuestionID And a.QuestionOption = b.Response Where a.DynamicQuestionID = @DynamicQuestionID --'B440AC87-FC53-4735-A6D8-EB4DBFD9D447' And b.UserID = @userID And a.Inactive = 0 order by a.SortOrder ) y on x.Seq = y.Seq and y.Seq <= 3 The final thing that I cannot stress enough is to continue to ask for another set of eyes to look over your work! It is for that reason that I really would like for some of the other more senior members of this forum to also add their comments. I frequently miss something and sometimes just flat out get something wrong. My main motivation to joining this forum was to learn and YOUR question today has helped me to continue to learn. I hope you will continue to contribute. Kent Tag: Job interview question
  - 10
    - Hide parameter if other paramter is null What I have is a report using Reporting Services 2005 that will take in a parameter through the URL called RepID, so the parameter is hidden inside the report because it's passed through the URL. This will run the report for the specified Rep. However, I'd like to have another paramater (Or also using RepID) just as Admin which would be a boolean and when Admin='N', the RepID parameter should not be displayed on the screen and just be accepted through the URL paramater RepID. However if Admin='Y' is the URL paramater passed, I want the RepID parameter to be displayed in the report so that the Admin can enter whatever RepID they want to run the report. Is there anyway to do this without creating a separate Admin version of the report Tag: Job interview question
  - 11
    - Stored procedure vs. query From a security perspective , I would never allow an application to directly access data tables. From my experience, all data access 'should' be done using Stored Procedures. The code base is centrally managed, and can easily be changed as system and business needs evolve. For example, imagine the impact on the application if data tables have to be re-organized for storage or speed issues. With stored procedures, it is only necessary to change the procedure code so that the same resultset is produced -the application doesn't care where the data comes from as long as it gets what is needed. But when using inline queries, any changes to the data stores can cause catastrophic failure of the application until all queries are located and changed. (From experience, believe me, over the life span of a project, there will be businss needs to change where/how the data is stored .) Also stored procedures can be easily changed to allow auditing. There are a lot of applications that are currently being re-written because of HIPPA and SarBox requirements. In addition to logging changes to data, HIPPA requires logging EVEN a data read operation that touches medical data. You can't do that with an inline query. And in a few occassions, after project roll-out, it was discovered that the application 'should have' done a better job of validating data before sending it to the data server. With a stored procedure, it was quick and easy to add validation code without having to trace out all locations in the application code where a query may have inserted data into a table. (Time from discovery, solution, testing, and 'fix': 45 minutes -no application re-deployement to 500+ desktops.) But from a 'purely performance' perspective, with SQL 2005, there is little difference in most situations. (Though there 'can' be large differences in certain situations.) Tag: Job interview question
  - 12
    - data access to large tables in sql 2005 hi all, i have a large table in sql server 2005 (it has about 6 columns and 10 million records). i need to work in a linear way on all the records (i know it sounds dumb but i need to work on all records). now, obviously when trying to work on this table sql server get stuck for timeout or something like that... i've noticed that a simple function like "select top 100 * from ExportTable" still works. is there any way to have sql send me the data when it access it so that i'll still be able to proccess it on the same time, i basically work using dataset so that fixing the timeout wont be helpfull since windows probably wont allow me to load this amount of data into memory. can any1 help Z Tag: Job interview question
  - 13
    - SQL Server on Windows CE 5 - I read somwhere that the CAB files needed for installing SQL Server CE on a WinCE OS can be obtained with SQL Server 2005. Does Express edition have those files - I also read that same files are also distributed with VS2005. Since VS2005 is a development product, what are distribution for those CAB files when packaged with VS2005 - Additionally, there is SQL Server CE 1.7MB separate download but I found that the desired CAB files are not distributed with it. Does that mean that that edition is intended to mimic behavior of SQL server running on WinCE Thanks, Jaydutt Tag: Job interview question
  - 14
    - Upgrading SQL Server 2000 Enterprise Edition to SQL Server 2005 Standard Edition does this mean I can attach msdb from a SQL2000 (ent) to SQL2005 (std) install No you cannot attach/restore the system dbs as it is different edition and version as well ! your only option is to script the jobs and logins ! you can only attach the user dbs and similarly restore the user dbs ! - Deepak Tag: Job interview question
  - 15
    - Should SQL 2005's BPool reservation size vary with "-g" startup parameter? Hello, all We are trying to work out a memory problem associated with a SQLCLR procedure we have developed. This procedure will run properly on a SQLExpress box, but fails with an Insufficient Memory error (701) when run on our 32-bit enterprise edition server on W2K3 Enterprise Server. The server has 3.25 GB of RAM, and does *not* have the /3GB switch enabled; AWE is *not* enabled on SQL Server. I initially suspected the problem was due to the idiosyncracies of how the BPool is allocated on SqlExpress and its 1GB buffer pool limitation, giving a 1GB MemToLeave region for SQLCLR allocations -- substantially larger than the default available on the server with it's default 256MB allocation (+128MB for thread stacks). That seemed to explain why a memory problem might not manifest itself on the client, but would on the server. I then altered the server to include an explicit "-g" parameter at startup, reserving 512MB for MemToLeave, but the query still fails with the same memory errors. I've tried values as high as 1GB (-g1024), but none have worked Our DBA has installed a recent hotfix associated with certain memory errors, to no avail. It appears that the server will max out the CLR allocations at 102MB, regardless of the presence of the -g parameter. Could it be that the MemToLeave region really is that severely fragmented There are still log messages indicating failures to reserve virtual memory... One thing I notice is that the buffer's VM Reserved value never seems to change regardless of the value of the "-g" option. I would expect to see it decrease by the amount specified as reserved, eg -g 768 should leave, for example, something like 1.2GB VM Reserved for buffer pool allocation, but it doesn't. That tells me I'm not really establishing a larger MemToLeave area. Is this expectation incorrect Bottom line, we don't know why this procedure is running on the server, but not in SqlExpress. It is a procedure that connects to a remote Oracle database and collects about 14,000 records, but dies after sending about 7,000 or so records when run on the server. Again, the same query running against the same code on a SqlExpress box works perfectly. Any thoughts or suggestions welcomed and greatly appreciated. David Tag: Job interview question
  - 16
    - Trouble with Workflow DTS (SQL 2000) Thank you Phil Brammer Tag: Job interview question

SiBown

I have been asked by a person who is going to interview me to supply this informationl;

'Come prepared to be able to talk me through how to set up an SQL driven .NET website on a server.

You are given a webroot folder containing root files such as the web.config and all the files for a .NET website and a data folder which contains an .mdf and .ldf files.

Talk me through what each of these folders contain and what you would do with them in order to set up the website on a server such that you would be able to open a browser type the URL you have configured and visit that website.'

I come from a Cisco background and no nothing about what she is asking. Is it unreasonable of me to expect to be able to gain this information in 2 days Can you tell me the best place to look for this knowledge

Thanks for any help.

Top

Re: Job interview question

Arnie Rowland

This might help:

Data -.NET Tutorials for SQL Data
http://dotnetjunkies.com/QuickStartv20/howto/doc/adoplus/xmlfromsqlsrv.aspx

Top

Re: Job interview question

mrdenny

What title is this position that you are interviewing for

Top

Job interview question

Re: Job interview question

Data -.NET Tutorials for SQL Datahttp://dotnetjunkies.com/QuickStartv20/howto/doc/adoplus/xmlfromsqlsrv.aspx

Re: Job interview question

Data -.NET Tutorials for SQL Data
http://dotnetjunkies.com/QuickStartv20/howto/doc/adoplus/xmlfromsqlsrv.aspx