Database

Blue_Boy12-Jun-09 1:08

Blue_Boy

12-Jun-09 1:08

Take a look this google result,there are some good examples.[^]

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Jerry Hammond12-Jun-09 4:32

Jerry Hammond

12-Jun-09 4:32

Sharma Dinesh Kumar wrote:
i want encrypt data inside the table of database .

This is very different from your original stated problem. Are you sure this is now correct, or do you want to encrypt only a column, or Store Proc?

"My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering

Isaac Gordon14-Jun-09 21:38

Isaac Gordon

14-Jun-09 21:38

Yes

Storge Of Data in Database

Luc Pattyn12-Jun-09 3:07

Luc Pattyn

12-Jun-09 3:07

Hi,

encrypting the data will slow down all operations, especially search operations.

anyway, isn't username-and-password protection enough?

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

DISCLAIMER: this message may have been modified by others; it may no longer reflect what I intended, and may contain bad advice; use at your own risk and with extreme care.

Isaac Gordon11-Jun-09 23:40

Isaac Gordon

11-Jun-09 23:40

hi Experts
I am Creating A Application using C#.NET and SQL Server 2005.
In my Database their is a Table Having 9 Fields But in Out of 9 fields Their
is one Field where We Have To Store Large Text File Data like 2,3 or more page data
then Suggest Me Which Data type i am using To Store this Fields i have Also Search Record in this Large Field if i am Taking Text Then It Does Not Provide Me Search in text Data Type in SQL Server Express Version. I am also Find The Result with Fast Speed. and Record in My Table is 1 Lakes or more then Suggest Me How I can Handle This Suit ions.

Mycroft Holmes12-Jun-09 0:24

Mycroft Holmes

12-Jun-09 0:24

Kumar
I know that English is not your first language, it is so obvious it hurts, but you need to address the problem of communication, your post is VERY difficult to understand and painful to read.

I suggest you get someone more skilled in English to help you with your message construction because your current efforts are BLOODY IMPOSSIBLE TO UNDERSTAND.

Never underestimate the power of human stupidity
RAH

Niladri_Biswas24-Jun-09 21:11

Niladri_Biswas

24-Jun-09 21:11

Hi,

May be your mother tongue is English or you know English better than the

original poster.

Instead of conveying your pain to him in a different fashion, do you think you made a justification by abusing him when you are here to answer a technical question?
Smile | :)

Niladri Biswas

Mycroft Holmes24-Jun-09 23:16

Mycroft Holmes

24-Jun-09 23:16

Hmm I thought I was reasonably polite, I pointed out there was a communication issue and tried to convey the difficulty in reading his post. If the last statement was offensive, put it down to MY communication problem, there is nothing offensive about it where I come from (Oz);

Was I just supposed to ignore the poor bugger because I could not understand him.

Never underestimate the power of human stupidity
RAH

Aman Bhullar12-Jun-09 0:29

Aman Bhullar

12-Jun-09 0:29

try using nText data type.... Smile | :)

Regards
Aman Bhullar
www.arlivesupport.com[^]

Isaac Gordon14-Jun-09 21:41

Isaac Gordon

14-Jun-09 21:41

is nText Provide Search in Database..

Niladri_Biswas24-Jun-09 21:08

Niladri_Biswas

24-Jun-09 21:08

Use Text data type.

For searching use Patindex or Full text search..

Please let me know in case of doubt.
Smile | :)

Niladri Biswas

Dbf.Net

Pascal Ganaye11-Jun-09 13:44

Pascal Ganaye

11-Jun-09 13:44

I posted recently a little Dbf.Net library.
I support all the .DBF files I could find so far.
I can't find good .mdx samples or clipper extensions.
Any clipperhead here would like to help?

dbfdotnet.codeplex.com

Diagram Database.

VisualLive11-Jun-09 7:25

VisualLive

11-Jun-09 7:25

HI all,
within several days i will finish to develop a database with SqlServer 2005 ,this database is so big with a lot of tables and so on .Now i wish create a diagram(schema) for it that show all table with fields and respective datatype but i don't know how create it,i have not idea if i need a tool to create or else.
I create a diagram with VisualStudio 2008 Sp1 but the diagram is without datatype, so do you have any idea how create e diagram (schema) of a database?Do i need a particular tool to create it?
All advice will be useful and nice.
Thanks.

Nice Regards Smile | :)

AlexeiXX311-Jun-09 14:42

AlexeiXX3

11-Jun-09 14:42

Using VS, connnect to your DB, expand it, just above the tables there is an option of diagrams, right click it and choose new diagram, then add all your tables
You an also do the same from sql server management studio

Alexei Rodriguez

VisualLive11-Jun-09 15:33

VisualLive

11-Jun-09 15:33

Hi Mr.Alexei,
thanks to reply me, i knew how make the diagram with VS but i don't know how make the diagram with Data Type or better i wish display in the Diagram for each field the kind of Data Type for example:

COLUMN NAME__________________DATA TYPE
- CustomerID___________________ int
- Name_______________________nvarchar(20)
- Address_____________________nvarchar(30)
....and so on.

Is it possible to create this kind of Diagram?

Thanks so much.

AlexeiXX311-Jun-09 19:07

AlexeiXX3

11-Jun-09 19:07

Piece of cake dude
Once you have the diagram:
Select all your tables (in the diagram
Right click over one table
Select Table View
Choose Standard or custom (You can also modify custom and define the info you want to show)

Alexei Rodriguez

AlexeiXX311-Jun-09 14:43

AlexeiXX3

11-Jun-09 14:43

Also, i cant beleive you just finished designing a big DB and you dont know how to create a diagram :p

Alexei Rodriguez

SQL2005 Stored Procedure Conditional Statement

Mycroft Holmes11-Jun-09 22:25

Mycroft Holmes

11-Jun-09 22:25

Next question will be "Why can't I save the diagram, I get a foriengn key violation" Dead | X|

And then what is a clustered index.

Never underestimate the power of human stupidity
RAH

munklefish11-Jun-09 5:07

11-Jun-09 5:07

Hi,

Im still fairly new to stored procedures but have reached a point where i need to use a conditional statement. At present i have to code below which will not compile due to various errors.
Please can you help me understand how i can make this work. Thanks;

CREATE PROCEDURE web.InsertManualAddressBook
          (
          @tmp_custID bigint
          )
AS
BEGIN
   IF EXISTS (SELECT * FROM tbl_AddressBookMaster WHERE addMaster_UserId = @tmp_custID AND addMaster_Title = 'Default')=1
       SELECT * FROM tbl_AddressBookMaster WHERE addMaster_UserId = @tmp_custID
       DELETE FROM tbl_AddressBookAddresses WHERE tbl_AddressBookAddresses.adds_ABMId = tbl_AddressBookMaster.addMaster_Key;
   ELSE
         'Do something else
END

Essentially what i want to do is;

1)Check if a record exists based on the input @tmp_custID(bigint) value.

2)If a record exists check a second table for records where the 'addMaster_UserID' column matches the 'addMaster_Key' of the initial table queried. Delete this records.

3)If the condition in item 1 isnt met, do something else.

Any help is correcting the above statement would be really appreciated.

Thanks.

Rob Philpott11-Jun-09 6:16

Rob Philpott

11-Jun-09 6:16

Ok dude, let's have a shot.

in step 1, I presume you're checking for a unique record, in which case:

declare @key [datatype of key]
select @key = [key field] from tbl_addressBookMaster where .....

will get the key if ones exists. It will either contain your key or will be null, so to see if a record did match we can just do

if @key is not null

to do the delete is straightforward

delete from tbl_AddressBookAddresses where Key = @key

so, all together you'd have something like this

declare @key [datatype of key]
select @key = [key field] from tbl_addressBookMaster where .....
if @key is not null
    delete from tbl_AddressBookAddresses where Key = @key
else
    -- do your other thing here

Make any sense?

Regards,
Rob Philpott.

munklefish11-Jun-09 6:47

11-Jun-09 6:47

Hey Rob,

Looks like that should be what im after.

It'll probably be morning before i test it though.

Ill let you know how i get on.

Thanks!!!!

munklefish11-Jun-09 23:44

11-Jun-09 23:44

Rob,

Ive adapted my SP to the following but it wont compile as it says there is a syntax error near the 'else' bit;

CREATE PROCEDURE web.InsertManualAddressBook
       (
       @tmp_custID bigint
       )
AS
       declare @key bigint
       SELECT @key = addMaster_Key FROM tbl_AddressBookMaster WHERE addMaster_UserId = @tmp_custID AND addMaster_Title = 'Default'
       IF @key IS NOT null
       DELETE FROM tbl_AddressBookAddresses WHERE adds_ABMId = @key;
       ELSE
       -- do your other thing here

munklefish11-Jun-09 23:48

11-Jun-09 23:48

Ok,

SO ive updated at, and it seems to be working ok although not fully tested. Does this look correct?

CREATE PROCEDURE web.InsertManualAddressBook
       (
       @tmp_custID bigint
       )
AS
BEGIN
       declare @key bigint
       SELECT @key = addMaster_Key FROM tbl_AddressBookMaster WHERE addMaster_UserId = @tmp_custID AND addMaster_Title = 'Default'
       IF @key IS NOT null
       DELETE FROM tbl_AddressBookAddresses WHERE adds_ABMId = @key;
       ELSE
       -- do your other thing here
       SELECT @@ROWCOUNT
END

Thanks!!!!!!!!

Rob Philpott12-Jun-09 1:55

Rob Philpott

12-Jun-09 1:55

Looks good! Not sure the point of the @@rowcount, but I'm sure these is one.

Regards,
Rob Philpott.

munklefish12-Jun-09 2:00