Database

C Sharp and Ms access is best for your project. or choose your db according to length of db.

Thank you for your reply. Group By doesn't work for my case.

Hi.. check your parameter is null or not. in stored procedure if(parameter is null or parameter ='') begin sql statements end else begin sql statements end or in single query. select * from tbl where parameter is null or parameter =''

try this........... select m.* from roles r, member m, member_roles p where r.mid = p.rid and m.rid = p.rid

Create two tables as: Item_Category {ItemID int identity(1,1) primary key, Item_CategoryName NVARCHAR(100)) AND another one is Item { ItemSrNo int identity(1,1) primary key, ItemID int, --foreign key references values from Item_Catory Table Column3, ,,,n }

Try Google for a large test database. I have seen various ones over the years but cannot remember where.

Minimizing the attack surface. You're quite right, and I stand corrected. My five. List of common misconceptions

Just a thought - I have not used SMO in many years but does the restore process drop all other connections to the database, I know if you try and restore via SSMS and there is an existing connection it fails, generates a warning but it does fail. Also the connection YOU are using may need to be to the master database not the one you are trying to restore! I love you exception, I wonder what it says :laugh: Never underestimate the power of human stupidity RAH

Buy a book, read some articles, SQL Server Central[^] is a good place to start. It is way too big a subject to get a response in a forum thread. Never underestimate the power of human stupidity RAH

Why should it be reduced? Most databases work in this way; you deleted items in the database, you didn't make the database smaller. Any deleted items aren't "physically" removed, they're just marked as being "non-existent". Imagine a database having to remove a single string from 5 trillion others, and save a concatenated form back again. Databases are fast by doing things efficiently. No real "removals", but "marks". If you want to reclaim the space, you'll have to "shrink" your database. Access has it's way, as mentioned, and Sql Server has some sprocs. Bastard Programmer from Hell :suss:

There are many versions, for modest projects I prefer SQL Server 2008R2 Express Edition, here[^]. For others, search the Microsoft site, or google. :) Luc Pattyn [My Articles] Nil Volentibus Arduum

See my answer I posted in the Q&A[^] you created. 0100000101101110011001000111001011101001

sir this project is running from past 1 year where we can fetch date and time wise report through crystal report but now the task is to fetch using time frame like 6hrs or 24hrs...

Hear hear! But it's not really a matter of Identity versus GUID, it's a problem with the keys being auto-generated by the engine rather than the application. You can use either an integer or a GUID and set it yourself; there's nothing magical about GUIDs here.

If OP had used Google, he would have got more than this.....:lol anyways thanks Prasad..... I quit being afraid when my first venture failed and the sky didn't fall down.

identity automatically increment your column values from seed property specified in identify clause. exam create table tbl ( i int identity(1000,1), name varchar(100)) output 1000 ;P 1001 1002 Ganu Sharma

try this query.......... select distinct voyage_no,vessel_code from D4A_RAW_BLP where vessel_code in (select distinct vessel_code from D4A_RAW_BLP where vessel_code is not null) order by vessel_code Regards: Ganu Sharma ;)

Thanks for your help , but i need a little detailed answer with steps Preferred for SYBASE. Iam new to both SYBASE and MYSQL :D

Mycroft Holmes wrote: and needs to cope with a long running stored procedure. And changing the connection timeout is going to impact that?

Blue-Boy you took me to Google. Well I have already googled and didn't find a clear solution. But I will keep trying.