Comments by Rakshith Kumar (Top 65 by date)

Good one 5+ :)

5+ . Nice one

Could you provide me with the details of the table structure

I dont think this will give desired result

Nice one 5+

Well tough requirement. SHould give A TRY atleast :). Possible

If there's any error in the link then iam open for a debate. Iam least concerned about the reputation points. All what i need is the reason for my downvote

It hurts when u r giving a proper solution and ur article is downvoted by a minnow just because he/she did not understand or do not have any other work

I have been observing that u r constantly downvoting my solutions. If there is any problem regarding the link that i have posted then please do reply. If u have time only for downvoting stuff then better learn some programming language rather than just coming here and downvoting the post

Downvoter please commment

perfect . 5+

you are welcome

u can try using ssis tool

re-installed the sql server. The problem was there was a setting wherein i needed to include an option for enabling all the ports and services after reboot. Now working fine. Thanks again codestar007

I think thats the best thing to do now. Anyway thank you for your help and time

sql server browser is working

for enabling the named pipes or any protocols all the services must be enabled right? In my configuration manager iam getting a message saying that no services are enabled . If i try enabling any service i get an error saying that "request failed or service did not respond in the timely fashion"

Iam trying. Nothing seems working :(

names pipe is enabled . Still iam getting the same error

@krishna : u can grant or revoke the permission from the back end. That would be much easier. U can grant or deny permission for a user.

Dear,
What do you want to ask?

try using in instead of =

@krishna: If you still have doubt you can send me your queries to rks0191@gmail.com

ohk if the status is set inactive then only there should be insert?
Fine
try this code
create procedure getval(@status varchar(6),@name varchar(max))
as
set @status=(select status from cus where name=@name)
if(@status='Inactive')
begin
insert into cus values(whichever values u need to insert)
end

If you want it in single table then wats the problem?

do you want the status column to remain inactive always and u want it to remain unupdated?

Its only for a single table named cus. If you want it in multiple tables then just use the same criterion in all the tables where you need enddate

ohk end date should not be greater than systems' current date?
not an issue
u can just use
enddate date constraint chk_date check(enddate>getdate())

if you are using that particular table structure then it will never allow end date to be lesser than the start date

well i still dint get ur entire point. If u want enddate to be greater than start date then you will need to use check constraint
create table cus(
name varchar(max),
address varchar(max),
startdate date,
enddate date constraint chk_date check(enddate>startdate),
status varchar(6) default'Active'
);
this will make sure that end date is greater than the start date

what do you want to know?@krishna97

try a book from kogent publications. Its really good. Even try out thenewboston.com

it will not work i think

perfect :)

this may not work for all the criterion. This does not meet upto the requirement

perfect

Thank you a lot tejas

If that is the case it will only deny the permission to the users of the database. My question however was to deny the users present in the table to deny the update permission. It will not work for my requirement. But thank you for the letting me know the use of granting and denying the permission. Thanks again :)

nice one :)

My dear i guess its only for the sql server users ? Correct me if iam wrong. The thing is i have a table customer and i need to set the username as un editable. denying the update previlege will mean that you are denying the sql server user the previlege to edit.

@Tejas Vaishnav: My dear i guess its only for the sql server users ? Correct me if iam wrong. The thing is i have a table customer and i need to set the username as un editable. denying the update previlege will mean that you are denying the sql server user the previlege to edit.

Nice one tejas :).

Its working :). Thanks a ton

Thank you Rohan. It was helpful

Thanks Madhu.

u can use html5 calander controll also u can try in ajax. Ajax has inbuilt calender controll which allows you to use a better interfaced calender

can u please explain me how this works?
Regards
Rakshith

Can we insert a record from microsoft excel and update it in sql server?

Thanks sergey. It was helpful :)

Can you share your code? Without it it would be tough to tell

thanxk you thatraja

Thank you Phil

even If u use truncate table u will not be able to reset . I tried it. It dint work.

It will not return a proper answer

Thanks For ur solution Madhu.

Agreed with the points that you have told.
I can use
rowguid int identity(1,1) primary key.

Can you please tell me a scenario wherein i can use rowguid

Thank you madhu. It is working perfectly. I forgot those 2 things :(

the question seems a bit void of data. Which database are u using? Do u want to update the value entered in the textbox to the database?
i Have a solution to what you have asked and what i have percieved from the question. according to me i can do it in this way
Import microsoft.applicationblocks.Data
In your main program
u can use
sqlhelper.executenonquery(name of ur connection,name of ur stored procedure,parameters to be passed);
this will update the entered values onto the database