|
Search
You searched for the word(s):
Showing page 133 of 133 (1,330 total posts)
< 1 second(s)
-
It depends on the case, it can be a method, however 0 <> NULL, and <firstname xsi:nil=''true''></firstname> is different from <fname></fname>.
-
You have a FOR XML query using ELEMENTS directive. You query ignores columns having NULL value and you want to include them. What should you do ?
Place the mouse cursor HERE for the answer
-
''SQL Server 2005 Update from Paul Flessner'' http://www.microsoft.com/sql/letter.mspx
Noua editie este bazata pe SQL Server 2005 Mobile Edition si va rula pe Windows Mobile, Windows CE, si Windows desktops. SQL Server Everywhere Edition elimina cateva din limitarile editiei SQL Server 2005 Mobile ca de exemplu rularea pe desktop-uri cu ...
-
You have a SQL Server 2005 computer using TCP/IP with default settings. The server is protected by a firewall. You want to allow clients to connect to your SQL Server. What port should you open ?Place the mouse cursor HERE for the answer
-
http://support.microsoft.com/?kbid=914277&SD=tech
-
http://support.microsoft.com/?kbid=913089&SD=tech
-
Or to answer on a different thread on the forum, there are lots of options
-
What tool can be used to enable, disable, start, or stop the features, services, and remote connectivity of your SQL Server 2005 installations ?
Place the mouse cursor HERE for the answer
-
Using OBJECTPROPERTY function and TableHasActiveFulltextIndex parameter. OBJECTPROPERTY(table_id, 'TableHasActiveFulltextIndex') will return a value of 1 when at least one column of a table is added for indexing. CODE:
SELECT OBJECTPROPERTY(OBJECT_ID('MySchema.MyTable'), 'TableHasActiveFulltextIndex');
GO
REFERENCE: ''Obtaining Full-Text ...
-
Using DATABASEPROPERTY function and IsFullTextEnabled parameter. CODE:
USE AdventureWorks;
GO
SELECT DATABASEPROPERTY('AdventureWorks', 'IsFullTextEnabled');
GO
REFERENCE: ''Obtaining Full-Text Property Values using Transact-SQL Functions'' http://msdn2.microsoft.com/ms142579.aspx
... 133
|
|
|