Just a small clarification. Every user and role (including the user guest) will get the permissions that are...

Variables that are declared outside of the dynamic SQL are not known in the dynamic SQL. You’ll have to change your code to work with temporary table instead of...

STR function works with three parameters. The first parameter is the number with the decimal point. The second parameter is the total length of the string. The...

As far as I know you can't use alter index statement to modify the columns that the index is referencing. You'll have to create a new index with the...

declare @st char(6)

declare @dt datetime

set @st = '145010'

set @dt = left(@st,2) + ':' + substring(@st,3,2) + ':' + right(@st,2)

select @dt

Adi

I think that you got it. I'm sorry but I thought that you know what nodes method is doing. The method is returning a table that has one...

GilaMonster (6/10/2009)

Jeff Moden (6/9/2009)

Yowch! I have some pretty strong feelings about...

Since the node method is creating a table, when your original data comes from a column in a table and not with a variable, you need to do a...

declare @xml xml

set @xml =

'

abc

pqr

'

select tab.col.value('.[1]','varchar(30)')

from @xml.nodes('BOOKS/BOOK/NAME') tab (col)

Adi

EDIT - In my original code the values in the ID tags were surrounded by quotation marks...

This is because you are working with integers. You need to work with types that work with decimal point. See the example bellow:

--using numbers that are treated as...

There are some third party tools (for example log explorer) that can get the data from the database's log. I'm not aware of a way to get understandable data...

The XML can not be seen. Can you upload a small XML file that has the same structure as the one that you work with? In any case...

Can you upload a small version of the text file (that will contain just few records) and a script for creating the table? Also if you'll post...

I never put it on my resume, but if the subject of favorite sites/forums comes up during the interview, I tell them which forums I use and I let them...

You can do it with BCP utility that works with a query that has the for xml extention:

bcp "select * from tempdb.dbo.Customers for xml raw, root('Root')" queryout c:\Temp\Customers.xml -T -c...