The query i have used is insert into [customer]([Id]) values('531067')

And another one is update statement

update [customer] set [Call attnd]='ses' where Id = 531067 and (Ltrim(Rtrim(cast([Call attnd] as varchar(max)))) = ''...

ok, got it.

Thanks

But i want to check sql is installed or not through code.So registry check or some other codes will be helpful.Anyone please come with a solution?

under 'snapshot' transaction , whether the entire database snapshot is taken? (during begin transaction statement is run) or only required rows snapshot is taken ?(during select statement)

thanks.

Thanks for the reply.

Thank u all. I can use filtered index.

Importing KEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell registry changes only some settings like tools->option->designers.Other settings like tools->option->sql server object explorer not changing.. where is the registry for those changes?

Thank you

We are using sql...

Thanks for reply

I don't think importing KEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell working. Don't know about other settings but it certainly not working for edit top n rows and select top n rows...

Thanks for reply

I think "Import and Export Settings" not present in management studio 2008 And even in management studio 2012 i doubt all settings are importing. I have tried to...

Thank you

My actual doubt now is what is difference between user mapping page(which shows permission like datareader,dbowner etc) and one under database->security->any user.Right click user and click properties.Now u can...

Thank u.

But i am not clear about two security folder under server and another one under database.In both database role membership is specified.So what is difference between them?

Anyone please reply me

If i create a file group with read only then how can i insert the values to the table? What is the use of read only file group?

What if i create secondary file group as read only?

How can i import from an excel file in sql express 2008 r2?