Re: i know jest the first later how can i write my sql - Database Discussion Boards

Re: Yes, ....

asha_s2-May-08 23:40

asha_s

2-May-08 23:40

thanks

Re: i know jest the first later how can i write my sql

Blue_Boy2-May-08 12:08

Blue_Boy

2-May-08 12:08

If you want to get all values which starts with letter b then use that query.

I Love T-SQL

Don't torture yourself,let the life do it for you.

Re: i know jest the first later how can i write my sql

asha_s2-May-08 23:40

asha_s

2-May-08 23:40

thanks

Re: i know jest the first later how can i write my sql

Christian Graus2-May-08 16:15

Christian Graus

2-May-08 16:15

Why would you ask this and not just try it ?

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Re: i know jest the first later how can i write my sql

asha_s2-May-08 23:43

asha_s

2-May-08 23:43

hi because my program not ready

Re: i know jest the first later how can i write my sql

Adeel Chaudhry3-May-08 0:37

Adeel Chaudhry

3-May-08 0:37

Are you coding Management Studio? Unsure | :~

Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.

Re: i know jest the first later how can i write my sql

Christian Graus3-May-08 1:41

Christian Graus

3-May-08 1:41

OK - so why worry about SQL if you're incapable of running any ? I guess you need to wait until you can test your code. Or use a database with client tools.

Re: i know jest the first later how can i write my sql

Adeel Chaudhry3-May-08 0:34

Adeel Chaudhry

3-May-08 0:34

May be because its complex and time taking Wink | ;)

Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.

Adventurework Database Downloading problem

ManiMughal2-May-08 9:09

ManiMughal

2-May-08 9:09

i want to download adventureworks database but i have slow internet connection. I tried to download from codeplex site but when i click on the link a dialogbox appears asking "i agree" and "i disagree". i want to use flashget for downloading it but that requires direct link and in presence of that link i can't download that. Can somebody tell me that is there any other site from where i can download this with direct link using any download manager.

Re: Adventurework Database Downloading problem

Blue_Boy2-May-08 12:12

Blue_Boy

2-May-08 12:12

You should make a google search...[^] , and you will find any direct link to download it.

I Love T-SQL

Don't torture yourself,let the life do it for you.

The indicator opening session of user instant is not supported in this version of SQL Server??

jerome_data2-May-08 7:57

jerome_data

2-May-08 7:57

Hello,

I try to implement a WSE 3.0(webservice) in database in SQL server 2005 Standard. The scenario is :

- 1) Winform that call a webservice(send a token to webservice).
- 2) The Webservice call a Custom UsernameTokenManager (using the protected override string AuthenticateToken( UsernameToken token ))
- 3)Sql Server version is Standard version on my Server, but this database is configured by aspnet_regsql.exe to allow Membership functionnalities.

All works correctly to create user thru the webservice, but when i try to validate the user with (Membership.ValidateUser(login,password)i have this error:

The indicator opening session of instant user is not supported in this version of SQL Server.

Can you help me??

Thanks

Hot to deploy my db to mssql136.win-servers.com ?

kindman_nb2-May-08 1:11

kindman_nb

2-May-08 1:11

hi I tried to add my db to the server mssql136.win-servers.com ,
and I didn't know how do it ?

jooooo

Re: Hot to deploy my db to mssql136.win-servers.com ?

Vasudevan Deepak Kumar2-May-08 3:26

Vasudevan Deepak Kumar

2-May-08 3:26

Your host should be the best bet contact for this query. Wouldn't it be the case?

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

How to shred rows from XML in SQL server 2005

okdeshpande2-May-08 0:37

okdeshpande

2-May-08 0:37

Hi,
I am trying to shred values of ModuleTorulemapid,selecteditemid and customvalue from following xml in SQL server 2005. For this purpose, I have written following code, but not able to shred it properly

----------------------------------------------------------------------
EXEC sp_xml_preparedocument @IDoc OUTPUT, @RollForwardRuleXML
SELECT DISTINCT
ModuleToRuleMapId 'ModuleToRuleMapGUID',SelectedItemId 'SelectedItemGUID',[UniqueIdentifier] 'OperationGUID',
CustomValue
FROM
OPENXML(@IDOC,'/ROOT/RuleBuilderModule/RuleBuilderRule/RuleBuilderOperation /RuleBuilderItem ',2)
WITH(ModuleToRuleMapId UNIQUEIDENTIFIER '/ROOT/RuleBuilderModule/RuleBuilderRule/@ModuleToRuleMapId',
SelectedItemId UNIQUEIDENTIFIER '../@SelectedItemId',
[UniqueIdentifier] UNIQUEIDENTIFIER '../@UniqueIdentifier',
CustomValue NVARCHAR(50) '@CustomValue'
)

EXEC sp_xml_removedocument @IDOC
-----------------------------------------------------------------------

Following is the XML which I am using
-----------------------------------------------------------------------
<ROOT>
<RuleBuilderModule Name="RollForwardMethod" UniqueIdentifier="6d6800a6-9006-4d65-a579-731872b16004" Timestamp="0">
<RuleBuilderRule Expression="Which method, automatic or manual, do you want to use for roll forward? <38fc8c42-c1ba-4843-81a4-69d8b9b21b98>" LockedStatus="3" ModuleToRuleMapId="93d552ea-5d8b-4cbd-b936-030ea4fca60a" RuleType="Question" IsBubbleHelpRequired="False" UniqueIdentifier="b88e94f3-48dc-4ce8-ae0c-be17c1133486" Timestamp="0">
<RuleBuilderOperation Name="RBuildMthdAutoManual" ValueSource="Internal" DisplayStyle="Multiple" SelectedItemId="45d72595-c7b7-41e4-bea3-1ffefa9bbfae" SelectedItem="Cch.WorkFlow.BusinessEntities.RuleBuilder.RuleBuilderItem" DialogType="ComboStyle" UniqueIdentifier="38fc8c42-c1ba-4843-81a4-69d8b9b21b98" Timestamp="0">
<RuleBuilderItem Name="Automatic" IsDefault="True" CustomValue="" UniqueIdentifier="45d72595-c7b7-41e4-bea3-1ffefa9bbfae" Timestamp="0" />
<RuleBuilderItem Name="Manual" IsDefault="False" CustomValue="" UniqueIdentifier="b0e4538f-8dc0-46d0-925e-f4a52e0ffdc6" Timestamp="0" />
</RuleBuilderOperation>
</RuleBuilderRule>
<RuleBuilderRule Expression="Rule: Automatically roll the project <363afba8-df04-4af2-a661-dc458bb55f5d>" LockedStatus="3" ModuleToRuleMapId="d5aeeaa7-09d9-4b33-aff9-74cedef43814" RuleType="Rule" IsBubbleHelpRequired="True" UniqueIdentifier="6ee47614-4632-498e-a619-7cacf3c547c4" Timestamp="0">
<RuleBuilderOperation Name="RBuildMthdAutoDuration" ValueSource="Internal" DisplayStyle="Link" SelectedItemId="8cc2752a-575f-484e-be83-1aa79fe1b45d" SelectedItem="Cch.WorkFlow.BusinessEntities.RuleBuilder.RuleBuilderItem" DialogType="ComboStyle" UniqueIdentifier="363afba8-df04-4af2-a661-dc458bb55f5d" Timestamp="0">
<RuleBuilderItem Name="after the client's fiscal year end" IsDefault="False" CustomValue="" UniqueIdentifier="38c5f62d-4859-4f1d-bcd2-807c9d81bf53" Timestamp="0" />
<RuleBuilderItem Name="when the project is completed" IsDefault="False" CustomValue="" UniqueIdentifier="3c66e057-baf2-4c81-a85e-1d4120ab8da2" Timestamp="0" />
<RuleBuilderItem Name="when the first linked work object is rolled" IsDefault="True" CustomValue="" UniqueIdentifier="8cc2752a-575f-484e-be83-1aa79fe1b45d" Timestamp="0" />
</RuleBuilderOperation>
</RuleBuilderRule>
<RuleBuilderRule Expression="How do you want to define who should approve the roll forward? <39d49d0f-6811-4286-8b7e-e75ee9abbdb5>" LockedStatus="3" ModuleToRuleMapId="992f66bb-d84e-4e4c-ba54-c8684b7aa4ae" RuleType="Question" IsBubbleHelpRequired="False" UniqueIdentifier="06b80a58-a700-4f2d-8d8d-e3ce1b752eaa" Timestamp="0">
<RuleBuilderOperation Name="RBuildMthdApprover" ValueSource="Internal" DisplayStyle="Multiple" SelectedItemId="18dca662-6713-4a5e-a3ea-375d48a68afc" SelectedItem="Cch.WorkFlow.BusinessEntities.RuleBuilder.RuleBuilderItem" DialogType="ComboStyle" UniqueIdentifier="39d49d0f-6811-4286-8b7e-e75ee9abbdb5" Timestamp="0">
<RuleBuilderItem Name="Individual" IsDefault="True" CustomValue="" UniqueIdentifier="18dca662-6713-4a5e-a3ea-375d48a68afc" Timestamp="0" />
<RuleBuilderItem Name="Role" IsDefault="False" CustomValue="" UniqueIdentifier="93aa037c-efb0-4038-b4ab-8d3f0da43f2d" Timestamp="0" />
<RuleBuilderItem Name="Team" IsDefault="False" CustomValue="" UniqueIdentifier="7984fc62-ad68-47ea-9b25-4ea9e97945b2" Timestamp="0" />
<RuleBuilderItem Name="Client Responsible Staff" IsDefault="False" CustomValue="" UniqueIdentifier="367fc7ee-f547-4fb2-bd8e-18b126e7da27" Timestamp="0" />
</RuleBuilderOperation>
</RuleBuilderRule>
<RuleBuilderRule Expression="Rule: <2346cf95-6281-4710-9a0a-ef743b50960d> should approve the automatic roll forward." LockedStatus="3" ModuleToRuleMapId="175b4326-eb2e-4a96-8930-06081070d471" RuleType="Rule" IsBubbleHelpRequired="False" UniqueIdentifier="f3b9104f-994c-46a7-82d4-7b85b71e4a23" Timestamp="0">
<RuleBuilderOperation Name="RBuildIndividgual" ValueSource="External" DisplayStyle="Link" SelectedItemId="739f5023-62f2-4ac0-a977-c6d074b4b0fd" SelectedItem="Cch.WorkFlow.BusinessEntities.RuleBuilder.RuleBuilderItem" DialogType="ComboStyle" UniqueIdentifier="2346cf95-6281-4710-9a0a-ef743b50960d" Timestamp="0">
<RuleBuilderItem Name="Unassigned" IsDefault="True" UniqueIdentifier="739f5023-62f2-4ac0-a977-c6d074b4b0fd" Timestamp="0" />
<RuleBuilderItem Name="Roger Fedrer" IsDefault="False" UniqueIdentifier="b5c3d0d2-d58e-4211-abdd-361ad729e309" Timestamp="0" />
<RuleBuilderItem Name="Martina Hinggis" IsDefault="False" UniqueIdentifier="0866c3b8-58ba-45fe-9135-3823f84ded31" Timestamp="0" />
<RuleBuilderItem Name="Jennifer Justin" IsDefault="False" UniqueIdentifier="ebac3d11-0b31-4266-a6c5-a04494397312" Timestamp="0" />
<RuleBuilderItem Name="Wilson Danial" IsDefault="False" UniqueIdentifier="c9b17eb4-7915-47ff-801d-90c7ae7abd91" Timestamp="0" />
<RuleBuilderItem Name="John Thomas" IsDefault="False" UniqueIdentifier="48876e2e-899e-4d1a-be00-eeadc744c481" Timestamp="0" />
</RuleBuilderOperation>
</RuleBuilderRule>
</RuleBuilderModule>
</ROOT>
------------------------------------------------------------------

Could anyone please help me out to shred those values properly?

Thanks In Advance
OmPrakash

Calling a CLR assembly in SQL Server

Member 39190491-May-08 14:31

Member 3919049

1-May-08 14:31

I have created the following assembly:

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Server;

namespace ClrBusinessObjects
{
public class Person
{
[SqlProcedure]
public static string GetPersonName()
{
return "John Smith";
}
}
}
-------------------------------------------
I have attached the assembly in SQL Server as follows:

CREATE ASSEMBLY
ClrBusinessObjects
FROM 'C:\DLL_TEST\ClrBusinessObjects.dll'
WITH PERMISSION_SET = UNSAFE;
GO
--------------------------------------------
I have tried to associate the assembly to a stored proc as follows:

CREATE PROCEDURE TestSqlClrExample
AS EXTERNAL NAME ClrBusinessObjects.Person.GetPersonName

but the SQL Server compiler returns:

Msg 6505, Level 16, State 1, Procedure TestSqlClrExample, Line 1
Could not find Type 'Person' in assembly 'ClrBusinessObjects'.

--------------------------------------------------------------------

What am I doing wrong?

Re: Calling a CLR assembly in SQL Server

Vasudevan Deepak Kumar2-May-08 3:29

Vasudevan Deepak Kumar

2-May-08 3:29

Check out this step-by-step tutorial:

http://www.sqlteam.com/article/writing-clr-stored-procedures-in-charp-introduction-to-charp-part-1[^]

Re: Calling a CLR assembly in SQL Server

Member 39190492-May-08 7:23

Member 3919049

2-May-08 7:23

I am still not clear on what the problem is.

Is there anyone on this forum with expertise in this area who could look at the code that I posted in my first post and troubleshoot what the problem may be?

Since all of the code is in the post then you should be able to easily reproduce this scenario. If the example works successfully for you then maybe it's my database configuration....

Re: Calling a CLR assembly in SQL Server

Member 39190492-May-08 9:00

Member 3919049

2-May-08 9:00

I figured out that the namespace needed to be updated and the method should return an int:

[ClrBusinessObjects].[ClrBusinessObjects.Person].[GetPersonID]

Problem with DataView.RowFilter

dergunnar1-May-08 10:58

dergunnar

1-May-08 10:58

Hello there,

i have the following problem with the DataView RowFilter:

In my Dataset there is a table that contains my friends and among others there´s a column Nick containing their nickname.

when I use for example

<br />
ds.Tables["tblfriends"].DefaultView.RowFilter = "Nick = 'Alex'";<br />

to filter for Nicknames Alex everything works fine. But when I afterwards change the nickname in this row to let´s say xx, the row is still displayed everytime I set the Rowfilter back to show Alex. When I set it to show xx no line is displayed.

It seems like the DataView somehow remembers the rows connected to a certain RowFilter and does not check if something has changed in the rows such that they don´t match the filter anymore.

Does anyone know if there is some sort of workaround for this problem?? Thanks for your help!

der gunnar

Re: Problem with DataView.RowFilter

CodingYoshi1-May-08 13:45

CodingYoshi

1-May-08 13:45

This might be because of your design. Where are you setting the filter? Is the filter executed again after you change the row? If not then the program is doing what it is supposed to do. Just debug and see if it hits the filter again after changing the value.

Re: Problem with DataView.RowFilter

dergunnar2-May-08 12:26

dergunnar

2-May-08 12:26

What do you mean with "where are you setting the flter"? Well I set the filter. then the value is changed. Afterwards the row still is displayed, but that´s not what bothers me. When I set the filter to something else and afterwards set it back to the iriginal filter the row with the changed value still shows up, even though it doesn´t match the filter anymore.

any ideas?

Computing a field value in SQL server 7.0

VardhiniKanaks1-May-08 10:37

VardhiniKanaks

1-May-08 10:37

Hi,

In SQL 2005 we have Formula Dialog Box [Model Designer] to compute field values in a table.

How to perform the same operation (computing a field value in table) using SQL server 7.0 ? I didn't find any option to compute during designing the table. Have I to write explicit triggers/function for it ?

Please help me ....

Thank you in advance !

Vardhini Kanakarajan

how to populate empty ms access database from dataset

Shreyas Ganesh1-May-08 6:01

Shreyas Ganesh

1-May-08 6:01

Hi!

I thought i was heading somewhere with those links Blue_Boy had sent.. but i've been stuck for quite a while now. So let me describe my problem in more detail: Plese help me Frown | :(

I have 2 datasets, with identical schema. Now i have merged them using the dataset1.merge(dataset2) method. So my dataset1 is a merge of the two datasets. Now when i try to update the database of dataset1 using dataadapter.update().. method, i dont see the database getting updated.This is the code snippet...

<br />
            OleDbCommand accessCommandDB1 = new OleDbCommand(strAccessSelect, accessConnDb1);<br />
            OleDbDataAdapter dataAdapterDB1 = new OleDbDataAdapter(accessCommandDB1);<br />
            OleDbCommandBuilder commandBuilder = new OleDbCommandBuilder(dataAdapterDB1);<br />
<br />
            dataSetDB1.Merge(dataSetDB2);<br />
<br />
            n = dataAdapterDB1.Update(dataSetDB1, "Customers");<br />
<br />

I see that no records are updated, from the value of n(n =0 after the call)
What could be the reason? Note that i dont have any primay keys to any table in my database

Also wanted to know how to polpulate a fresh empty ACCESS database, with my dataset.. Again no primary keys for any table.. i would prefer this over the update method..

Please help me at the earliest.. Confused | :confused:

Awaiting your replies.... Confused | :confused:

Shreyas

Re: how to populate empty ms access database from dataset

Kschuler1-May-08 7:34

Kschuler

1-May-08 7:34

I've never used the merge and there isn't very clear info on it on msdn. But I did notice that it is overloaded. What happens when you try to use dataSetDB1.Merge(dataSetDB2, True) instead?

Re: how to populate empty ms access database from dataset

Shreyas Ganesh1-May-08 8:30

Shreyas Ganesh

1-May-08 8:30

I have tried that as well. It doesnt work.
But i am sure the merge has worked because i am printing certain values to confirm it.. Si i guess its some update issue.. Right?

Btw, how do i populate an empty access database with my dataset?

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.