|
Search
You searched for the word(s):
Showing page 56 of 61 (604 total posts)
< 1 second(s)
-
Poti crea un ''linked server'' catre BD Access si apoi comanda INSERT tabela_access SELECT ... FROM tabela_sql_server:
EXEC sp_addlinkedserver @server = 'LINK_ACCESS_DB', @srvproduct = 'commandos1', @provider = 'Microsoft.Jet.OLEDB.4.0', @datasrc = 'C:\BazaDeDate.mdb' --bd AccessINSERT ...
-
Definesti parametrul procedurii de tip NVARCHAR. Cand apelezi procedura stocata ii transmiti lista de valori sub forma unei structuri in format XML.
Exemplu: <root> <parametru valoare=''111''/> <parametru valoare=''...''/> ... </root>
Procesezi datele in format XML transmise ca parametru (vezi @xml) cu ajutorul ...
-
stefangabriel:Here are the links to the performance articles I referred to earlier:
LINQ to SQL Performance Part 1
LINQ to SQL Performance Part 2
LINQ to SQL Performance Part 3
LINQ to SQL Performance Part 4
LINQ to SQL Performance Part 5
Mda, 13% / 14% din performantele unui furnizor de date ''standard'' ... Ar fi ...
-
Editoare pentru scripturi VBS care includ facilitati WMI:
VbsEdit http://www.vbsedit.com/
Script Debugger IDE http://www.script-debugger.com/
WMI Tools from MS http://www.microsoft.com/technet/scriptcenter/createit.mspx
-
Cea mai simpla solutie este un script VBS care schimba modul de start a serviciului dupa care restarteaza calculatorul (stiu, e o solutie care consuma timpul):
'Dezactivare/activare cdromcomputer = ''.'' serviciu = ''cdrom'' modstart ...
-
crestinul:hops am imresia canu e in 2000 asa ceva
SQL Server 2000 Notification Services, Standard Edition 2.0 SP1
Despre viitorul Notification Services: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2006061&SiteID=1
-
Ce valoare returneaza metoda StartService ?
Publica scriptul daca se poate.
-
Pentru a calcula diferenta dintre 2 date calendaristice poti utiliza functia DATEDIFF: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/57e0601a-9d97-4437-9be1-7efa639b39fc.htm (copy + paste in Books Online - sectiunea URL).
In cazul tau poti formula conditia din IF astfel:
IF ( DATEDIFF(dd,@DataFinalizareContract,@GETDATE()) <= 4 )
-
Diana si Razvan au subliniat problema principala: folosind doar Management Studio nu se poate !
Trebuie sa utilizati cel putin Visual Studio Prof !
[1] Configurare depanare proceduri stocate SQL Server 2005
[2] Configurare depanare proceduri stocate SQL Server 2005
+
un tutorial pentru depanarea procedurilor stocate din VS
-
Iti recomand SQL Server Compact Edition.
[1] website: http://www.microsoft.com/sql/editions/compact/default.mspx
[2] te inregistrezi si-l poti utiliza gratuit: http://www.microsoft.com/sql/editions/compact/redistribute.mspx
[3] download (database engine, books online - extensive developer documentation that explains how to create mobile ...
... 56 ...
|
|
|