|
|
Search
You searched for the word(s):
Showing page 129 of 133 (1,330 total posts)
< 1 second(s)
-
Let's take a look at the following example from Books Online:
DECLARE @price money
SET @price=2500.00SELECT CatalogDescription.query('declare namespace pd=''http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription'';
<Product ...
-
Which T-SQL predicate allows you to search columns containing character-based data types for precise or fuzzy (less precise) matches to single words and phrases?
Place the mouse cursor HERE for the answer
-
Visual Studio Team System presentations from demos and talks at TechEd 2006 (US)
Daca nu ati fost la TechEd (ca si mine) puteti sa va faceti o idee despre ce s-a intamplat acolo.
DAT312: Managing and Deploying Your SQL Server Schemas with Visual Studio Team Take a deeper look inside an exciting new addition to Visual Studio Team ...
-
Un nou document publicat pe BizTalk Server Developer Center:
Whitepaper: BizTalk Server 2006 Developer's Troubleshooting Guide
http://download.microsoft.com/download/3/7/6/376a6f6c-8c97-4ab5-9d5a-416c76793fbb/bts06developerstroubleshootingguide.doc
Abstract
This troubleshooting guide is intended to provide guidance to developers in the ...
-
Visual Studio 2005 Team Edition for Database Professionals CTP 5 Update
ATENTIE ! Cititi instructiunile de instalare !
In plus aruncati o privire si aici CTP5 Refresh Available!
-
In momentul in care procedura stocata devine foarte mare se poate sparge in mai multe proceduri stocate in functie de cazurile pe care le trateaza.
Ceva de genul:
CREATE PROCEDURE myBigProc@CASE INTASBEGINSET NOCOUNT ON;IF @CASE = 1 EXEC myCase1Proc ELSE IF @CASE = 2 EXEC myCase2ProcELSE IF @CASE = 3 EXEC myCase3ProcENDGO
-
If you want the complete answer you should take a look at the following post What are the different cached objects in the plan cache? from the SQL Programmability & API Development Team Blog.
[quote]
The following caches are included in procedure cache :
Compiled Plans
Execution plans
Algebrizer tree
Extended ...
-
Daca va intereseaza LINQ veti gasi urmatorul articol interesant:
http://blogs.msdn.com/wriju/archive/2006/09/16/757181.aspx
-
http://www.codeplex.com/Wiki/View.aspx?ProjectName=Nquery
Mi se pare interesant subiectul mai ales pentru programatori:
NQuery is a relational query engine written in C#. It allows you to execute a SELECT query against .NET objects. It can use arrays, data sets, data tables or any other custom table binding. NQuery is completely extensible so ...
-
http://www.codeplex.com/Wiki/View.aspx?ProjectName=SQLWebTools
SQL Server Web Tools is a Web-based Administration tool to manage SQL Server databases. With SSWT, you can administer accounts, manage databases and tables, write and run queries and Stored Procedures, and much more.
... 129 ...
|
|
|