Database

Henry Minute18-Feb-11 3:17

Henry Minute

18-Feb-11 3:17

It's a pleasure

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
I wouldn't let CG touch my Abacus!
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.

Brady Kelly18-Feb-11 2:46

Brady Kelly

18-Feb-11 2:46

The RedGate tools could probably help you, and if it's an immediate problem, you can use their evaluation period.

Tomz_KV18-Feb-11 2:50

Tomz_KV

18-Feb-11 2:50

Thanks for the info.

TOMZ_KV

The answer

Ennis Ray Lynch, Jr.18-Feb-11 3:23

Ennis Ray Lynch, Jr.

18-Feb-11 3:23

I use the script below to create auto gen scripts for crud. Mix and match to suit your needs. Once you have what you want save it as an sp with
the table name as a parameter and you are good to go.

SELECT * FROM sysColumns WHERE id = (select id from sysObjects where name = 'myTable');

Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. I also do Android Programming as I find it a refreshing break from the MS.

"And they, since they Were not the one dead, turned to their affairs" -- Robert Frost

Re: The answer

Tomz_KV18-Feb-11 3:58

Tomz_KV

18-Feb-11 3:58

Thanks for your help!

TOMZ_KV

Steve Wellens18-Feb-11 3:40

Steve Wellens

18-Feb-11 3:40

You can also do it with Visual Studio.

http://weblogs.asp.net/stevewellens/archive/2009/12/11/automatically-generate-stored-procedures-with-visual-studio.aspx[^]

Steve Wellens

Tomz_KV18-Feb-11 3:59

Tomz_KV

18-Feb-11 3:59

A great trick. Wish sql server have this functionality natively. Thanks,

TOMZ_KV

PIEBALDconsult18-Feb-11 4:26

PIEBALDconsult

18-Feb-11 4:26

I'm glad you got answers you like.

But... Personally I don't see the point in writing stored procedures that simply do those tasks -- especially update; update what? -- database tasks depend on the needs of business requirements which often don't include simple inserts, updates, and deletes on individual tables. Most database tables don't exist all on their own and several operations need to be executed at one time. It's well known that I don't like stored procedures at all, but at least they should be written to perform a higher-level operation than one simple operation.

fjdiewornncalwe18-Feb-11 4:43

fjdiewornncalwe

18-Feb-11 4:43

I've seen lots of tools make attempts at using sql, but in response to your question all you have to do is wrap the generated sql in a create procedure call, add parameters and voila, you have your skeleton procedure. Of course I believe that all procedures should do whatever they can to protect the data so I insist that any procedures written on my watch contain validation of whatever can be validated.

I wasn't, now I am, then I won't be anymore.

query problem

Dhyanga17-Feb-11 5:47

Dhyanga

17-Feb-11 5:47

hi
I am trying to run this query

select Name from data where id='67' and file like '[pdfrtfdoc]%'

and it didn't give any data.

well if my query is
either

select Name from data where file like '[pdfrtfdoc]%'

select Name from data where id='67'

it runs.

and also in the database it has record having id = 67 and file = *.pdf file.

Need quick help.

suchita

Chris Meech17-Feb-11 6:05

Chris Meech

17-Feb-11 6:05

Try this

where file in ('%pdf', '%rtf', '%doc')

Chris Meech
I am Canadian. [heard in a local bar]

In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]

posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]

Dhyanga17-Feb-11 7:35

Dhyanga

17-Feb-11 7:35

Sorry that wasn't my question.

I have two conditions
one is id check and another is file check.

If i put one of those conditions, it runs but if i put two conditions , then its not running.

suchita

Chris Meech17-Feb-11 8:24

Chris Meech

17-Feb-11 8:24

If by "not running" you mean that no rows are returned, then that means that the rows returned from running the id check are different than the rows returned from running with the file check. Smile | :)

Luc Pattyn17-Feb-11 8:29

Luc Pattyn

17-Feb-11 8:29

why is 67 in quotes? ID fields normally are numeric, for maximum performance, and numeric literals don't take quotes.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.

Dhyanga17-Feb-11 9:53

Dhyanga

17-Feb-11 9:53

no i tried both. actually is it possible to have sql conditions where there is LIKE condtion and other normal condition in the same statement. I can't find that example either.
something like

select Name from data where id=67 and file like '[pdfrtfdoc]%'

select Name from Grapp1L where Name='suchita' and file like '[pdfrtfdoc]%'

the above both statements didn't run though i have data in both fields on the same row.

when i run with only one condition, it runs. I have never tried LIKE condition with any other conditions. well I am familiar with multiple conditions though.

suchita

Luc Pattyn17-Feb-11 10:36

Luc Pattyn

17-Feb-11 10:36

SayamiSuchi wrote:
no i tried both

only string literals need quotes. numeric literals don't.

SayamiSuchi wrote:
is it possible to ...

yes, of course.
add a record that has id=67 and file="pqr", then try

select Name from data where id=67 and file like 'p%'

Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.

Wendelius17-Feb-11 10:09

Wendelius

17-Feb-11 10:09

Since you have AND between the conditions both conditions must be true on the same row. So if you don't get any results with those two conditions but you do get results when using the conditions separately, you don't have a row in the table that satisfies both conditions at the same time.

Also when you use LIKE operator like that, you select all rows that start with letters P, D, F, R, T, F (again), D(again), O or C. For example if the field file contains a value 'test.abc', this will satisfy the condition since it start with the letter T. Is this what you really want?

The need to optimize rises from a bad design.My articles[^]

Which Database to Use

Anubhava Dimri16-Feb-11 23:41

16-Feb-11 23:41

Hello everybody,

I am developing an Application in which have a data base which i can share in different machines(more then 2).
So I wanna use any database which support sharing.

Because the application is download from web and it is small application.So i want to use the Fee and Small Size database.
My Application is like as billing.

So please suggest me what database to use for my application.

Thanks

If you can think then I Can.

Richard MacCutchan17-Feb-11 0:17

Richard MacCutchan

17-Feb-11 0:17

SQL server Express[^] or SQL Compact Edition would probably fit the bill.

I must get a clever new signature for 2011.

Anubhava Dimri17-Feb-11 0:18

17-Feb-11 0:18

It is free or not?

If you can think then I Can.

WoutL17-Feb-11 0:26

WoutL

17-Feb-11 0:26

If you look at the page in the link it says: A free and feature-rich database for developing and deploying
desktop, web, and small server applications

So yeah, I think it is free...

Wout Louwers

Richard MacCutchan17-Feb-11 1:11

Richard MacCutchan

17-Feb-11 1:11

eg_Anubhava wrote:
It is free or not?

Go and look at the link; I cannot do everything for you!

I must get a clever new signature for 2011.

Anubhava Dimri17-Feb-11 1:15

17-Feb-11 1:15

Thanks sir

If you can think then I Can.

Eddy Vluggen17-Feb-11 7:17

Eddy Vluggen

17-Feb-11 7:17

Sql Compact isn't a database-server, it's a file-based system. It's not recommended in a multi-user environment.

I are Troll Suspicious | :suss:

Anubhava Dimri17-Feb-11 17:24