1. I have written a simple select procedure which retrieves data from several tables using joins. 2. One of the tables has a wrong value in one of the columns....
SELECT A.studentid,A.studentname,b.age,CASE WHEN c.department = 'ZOOLOGY' THEN 'SCIENCE' ELSE c.department END from studentdetails A inner join studentage B ...
Hello every body, I am in a trouble to set password to a SQLServer 7.0 on to my database, please provide me the steps or guide me to do it. Regards, Jogesh. ...
Thanks Roji and Rajan!!!! But instead of CASE I used IF EXISTS.....ELSE because in the actual environment there will be a huge amount of data and using CASE...
Hi Jogesh, Can you please elaborate what exactly is the issue you are facing and the exact error you are getting. Your below query is unclear. Thanks, jogesh...
how do u did that can u paste the query there? Best Regards Sunil John ... From: Techie <sqlserver1717@...> To: sqlcon@yahoogroups.com Sent: Tuesday,...
Sir, what I want is to put password on the SQL server group or one step higher level so that my users should not view the data. Sir, please see the attachment....
It was not through the query, I am using the enterprise manager. ... From: sunil john <suniljk7@...> To: sqlcon@yahoogroups.com Sent: Tuesday, 3 April,...
Case would not effect performance in this scenario and i think that is the only way how you can get the whole data in single query or you have to write more...
It was not through the query, I am using the enterprise manager. ... From: sunil john <suniljk7@...> To: sqlcon@yahoogroups.com Sent: Tuesday, 3 April,...
Please read boks online for such quick issues/solutions As a norm on this group we must elaborate the problem synopsis in Subject line. Cheers veeru ...
Yeah you can do that. In SQL 2005 it has got built in SMTP so there is no need to use outlook profiles and all those things. If it is SQL 2000 either you need...
For MS SQL Server 2000 http://support.microsoft.com/kb/263556 For MS SQL Server 2005 http://msdn2.microsoft.com/en-us/library/ms175887.aspx Write us again, if...
Hi I need something like this http://mssql-wa.leprado.com/website/ please its in php can anyone help me in finding a web client to manage MS SQL Server...
Please tell me how to provide the password on this so that user should not allow to go inside the sqlserver. ... Expecting? Get great news right away with...
Hi Jogesh, Under the SQL Server Group - Local (Windows NT)-Right Click -Edit SQL Server Properties -You will find 2 options -Windows Authentication and SQl...
Hi, Here, you need to understand the security architecture of sql server. Sql server uses two level security. One at the server level (Login) and the other at...
Thanks a lot Goswami for the first link that you have provided, but the second one does not work. I really appreciate your help. Well in the meantime I was...
Hi All, After taking the backup i want to check the backup file is corrupted or not. but without restoring the database any commands are there. Please help me...
Hi sql! Your friend Moiz from , just invited you to his/her online photo albums and journals at Zorpia.com. Moiz has a message to you: Hi Guys So what is...
Try using RESTORE VERIFYONLY,It Checks to see that the backup set is complete and that all volumes are readable. However, RESTORE VERIFYONLY does not attempt...
