Viewing 15 posts - 511 through 525 (of 1,478 total)
The FOR XML clause was introduced in SQL Server 2000. At that time SQL Server didn’t have the XML data type, so it returned a regular string. ...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 7, 2010 at 2:56 am
Can you make sure that your user can actually work with those tables? Maybe the user is also part of role that has deny permissions on the tables. ...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 23, 2010 at 3:49 am
As far as I know everyone has permissions on those views, but you can only see tables that you have permissions to work with. When you say that you...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 23, 2010 at 1:15 am
When you use style number 113, you get the date and time with spaces in it. When you use style 112, you don’t have spaces in the results. ...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 22, 2010 at 7:12 am
Maybe I don’t understand what you need. Maybe you don’t use the correct query. Maybe you don’t open the correct fie. In any case in the...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 22, 2010 at 6:20 am
Not sure that I understood what you want. If I understood you correctly then this is the way to do it:
DECLARE @NextString NVARCHAR(40)
DECLARE @pos INT
DECLARE @NextPos INT
DECLARE @String NVARCHAR(40)
DECLARE...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 22, 2010 at 4:40 am
The query that you got does exactly what you asked for. The element sentdate is the child of saftyreport and when you minimize the element saftyreport, you don’t...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 22, 2010 at 4:19 am
If you want to get the results that WayneS showed you, you can use the fallowing query:
SELECT
'en' AS "@lang",
messagetype AS "ichicsrmessageheader/messagetype",
messageformatversion AS "ichicsrmessageheader/messageformatversion",
messageformatrelease AS "ichicsrmessageheader/messageformatrelease",
messagenumb AS "ichicsrmessageheader/messagenumb",
messagesenderidentifier AS "ichicsrmessageheader/messagesenderidentifier",
messagereceiveridentifier...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 22, 2010 at 1:29 am
User defined functions have some limitations. One of those limitations is that you can’t use dynamic SQL in it. This is by design and there is no way...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 22, 2010 at 1:15 am
There isn’t correct and wrong way. You can work with insert select and linked servers. Another way is to work with SSIS and write your own package....
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 22, 2010 at 1:07 am
It is very hard to understand your question. Pleas fallow the URL in my signature to see how to write a question. If you’ll fallow the direction at...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 17, 2010 at 4:44 am
One way of doing it is like that:
select convert(char(8),getdate(),103) + ' ' +
CASE WHEN datepart(hh,GETDATE()) > = 12 THEN CONVERT(varchar(10), dateadd(hh,-12,getdate()),8) + 'PM'
else CONVERT(char(10),getdate(),8) + 'AM' end
Of...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 17, 2010 at 4:12 am
It’s been a while since I last worked with replication on SQL Server 2000, but as far as I remember modifying table that is published is very limited. You...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 17, 2010 at 2:14 am
I have to admit that I failed the question and I was surprised. When I saw the correct answer I couldn’t believe it. Every single option that was...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 15, 2010 at 9:26 am
If you have the password that was used when you created the database master key, you can use it to "introduce" the new master service key. You do that...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 15, 2010 at 9:08 am
Viewing 15 posts - 511 through 525 (of 1,478 total)