Showing posts with label convert. Show all posts
Showing posts with label convert. Show all posts

Wednesday, March 21, 2012

i want to convert sql stored procedures to dll

can anyone help me and excuse my terrible english. i want to convert sql stored procedures to dll.

If i got you correctly then I don't think you can do so (convert stored procedure to dll) - the stored procedures reside in your database as its objects. Perhaps a little detail with what you want to achieve actually would have been of more help.

sql

I want to convert datetime value into MonthName.

In Page Body, there is a textbox whose value is in "mm/dd/yyyy" form. So I want it in "dd MonthName yy" format. How to do it.

Suppose the field name is field1 which has date in dd/mm/yyyy format, use this in the value expression

DatePart("dd", field1) & " " & MonthName(field1) & " " & DatePart("yy", field1)

|||

It's acually even simpler than that.

In the format properties of the textbox enter in the Format Code: box (top left of tab)

dd MMMM yyyy to return a date such as 03 Novermber 2006

or

dd MMM yyyy to return a date such as 03 Nov 2006

Monday, March 19, 2012

i want ot convert xml data format into the general data format

hi sir
i have table hh .it has two columns
one is hhno is integer datatype another hhdoc is xml data type like
hh table
hhno hhdoc
----
------------------------
100
<suresh>sfjfjfjfjf</suresh>...........................
101
<ramesh>hhfhfhf</ramesh>..........................

how to convert the xml data format into the general data format pls
help me with examples> how to convert the xml data format into the general data format pls
> help me with examples

What do you mean by 'general format'? The following example shows one
method to return the root element text:

CREATE TABLE Table1
(
hhno int NOT NULL
CONSTRAINT PK_Table1 PRIMARY KEY,
hhdoc xml
);

INSERT INTO Table1
SELECT 100, '<suresh>sfjfjfjfjf</suresh>'
UNION ALL SELECT 101, '<ramesh>hhfhfhf</ramesh>';

SELECT hhno, hhdoc.query('*/text()')
FROM Table1;

--
Hope this helps.

Dan Guzman
SQL Server MVP

"surya" <suryaitha@.gmail.com> wrote in message
news:1149850644.769850.143640@.c74g2000cwc.googlegr oups.com...
> hi sir
> i have table hh .it has two columns
> one is hhno is integer datatype another hhdoc is xml data type like
> hh table
> hhno hhdoc
> ----
> ------------------------
> 100
> <suresh>sfjfjfjfjf</suresh>...........................
> 101
> <ramesh>hhfhfhf</ramesh>..........................
>
> how to convert the xml data format into the general data format pls
> help me with examples