benzzon.se
Published on benzzon.se (http://www.benzzon.se)

Home > MS SQL Server Tips

2 posts / 0 new
Log in [1] to post comments
Last post [2]
Fri, 10/13/2006 - 08:57
#1 [3]
benzzon
benzzon's picture
MS SQL Server Tips

SQL Server System Functions: http://msdn2.microsoft.com/en-us/library/ms187786.aspx [4]

 
Bra SQL-FAQ: http://sqlserver2000.databases.aspfaq.com [5]
Swedish SQL User Group: http://www.sqlug.se/ [6]
SQL naming conventions: http://www.sqlservercentral.com/columnists/bknight/2687.asp [7]
 
Intro to User Defined Functions (Updated)
http://www.sqlteam.com/item.asp?ItemID=1955 [8]
 
 
Formatera sql-kod till andra format, ex.vis vb-sträng: http://www.sqlinform.com/ [9]
Free database info tool (query analyzer m.m): http://www.innovmgtsys.com/imssqlutil1.htm [10]
(verkar tyvärr ej gå att kopiera resultat i query fönster..)
 
Workaround för att i SQL 2000 få "getdate()" att fungera i en udf (user defined function) (i SQL2005 kan getdate användas direkt..)

CREATE FUNCTION f() RETURNS datetime
AS
BEGIN
DECLARE @a datetime
SET @a = (SELECT * FROM OPENROWSET('SQLOLEDB', 'localhost';'sa';'password', 'SELECT GETDATE()'))
RETURN @a
END
 
How to share data between stored procedurs (info about user defined functions also..)
http://www.sommarskog.se/share_data.html [11]
 
Torskat på följande när det gäller user defined functions:
 
"EXECUTE cannot be used as a source when inserting into a table variable.
Msg 197, Level 15, State 1, Procedure fnDYF_Criteria_A1, Line 49"
 
"Only functions and extended stored procedures can be executed from within a function."
 
 
openquery syntax: http://msdn2.microsoft.com/en-us/library/ms188427.aspx [12]
 
SQL Reference & examples: http://fluffycat.com/sql/ [13]
 
 
MSDTC (Oracle, MTS, Error 7391..)

You receive error 7391 when you run a distributed transaction:
http://support.microsoft.com/default.aspx?scid=kb;en-us;329332 [14]

How to troubleshoot error 7391:
http://support.microsoft.com/default.aspx?scid=kb;en-us;306212 [15]
 
You may recieve a 7391 error:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;839279 [16]
(denna länk gjorde att proc-anrop "stpDYF_Drawing_SPSYS_Get" hoppade igång hos LEB.
Proceduren innehåller oracle-anrop, och gav fel vid försök att göra insert av resultatet till temp-tabell i sql server.)


 
Top

Source URL: http://www.benzzon.se/?q=node/132

Links
[1] http://www.benzzon.se/?q=user/login&destination=node/132%23comment-form
[2] http://www.benzzon.se/?q=node/132#comment-647
[3] http://www.benzzon.se/?q=node/132
[4] http://msdn2.microsoft.com/en-us/library/ms187786.aspx
[5] http://sqlserver2000.databases.aspfaq.com
[6] http://www.sqlug.se/
[7] http://www.sqlservercentral.com/columnists/bknight/2687.asp
[8] http://www.sqlteam.com/item.asp?ItemID=1955
[9] http://www.sqlinform.com/
[10] http://www.innovmgtsys.com/imssqlutil1.htm
[11] http://www.sommarskog.se/share_data.html
[12] http://msdn2.microsoft.com/en-us/library/ms188427.aspx
[13] http://fluffycat.com/sql/
[14] http://support.microsoft.com/default.aspx?scid=kb;en-us;329332
[15] http://support.microsoft.com/default.aspx?scid=kb;en-us;306212
[16] http://support.microsoft.com/default.aspx?scid=kb;EN-US;839279