[T-SQL] deny execute permissions on sp_linkedservers for particular login |
- deny execute permissions on sp_linkedservers for particular login
- Need help with T-SQL to combine email addresses
- Date Parse Help
| deny execute permissions on sp_linkedservers for particular login Posted: 02 Aug 2013 03:32 AM PDT Hi friends,Is there any way to deny execute permission on sp_linkedservers for particular sql login.Thanks in advance. |
| Need help with T-SQL to combine email addresses Posted: 02 Aug 2013 05:04 AM PDT Hello,I am trying to get email addresses in column and concatenate them into a long string, separated by semi-column ";". So, the results would be like:bob@company.com; mary@company.org;paul@company.com;susan@company.netI have this T-SQL below and I am using a while loop that does not work, but I am wondering if I a cursor would work better. I am not sure, as what is below is not working. Can you help me with this query to get the results?declare @emails as varchar(5000) while exists (select People.cEmail from dbo.People)begin set @emails = cEmail + ';' + @emailsend Thanks. |
| Posted: 02 Aug 2013 03:12 AM PDT Hi Guys, Here is my Date Column, sample data below201308011730092013080117300920130801173009201308011730092013080117300920130801173009Is someone can help me to parse in Year,Month, Day and rest are time?Thanks in advance. |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / T-SQL (SS2K8) To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment