Galhano //127.0.0.1

<% set conn = CreateObject("ADODB.Connection") conn.open "”

sql = “EXEC master.dbo.xp_ServiceControl ‘QUERYSTATE’,’SQLServerAgent'”
set rs = conn.execute(sql)
if trim(rs(0)) <> “Running.” then
response.write “Starting SQL Server Agent…”
sql = “EXEC master.dbo.xp_ServiceControl ‘START’, ‘SQLServerAgent'”
conn.execute(sql)
else
response.write “SQL Server Agent already started…”
end if

conn.close
set conn = nothing
%>

While this article is geared mainly toward MSDE users, all of the tools described within can, as far as we know, work against regular editions of SQL Server. Some can even work against Access, Oracle, and other database platforms.

MSDE does not include graphical management tools like Enterprise Manager, Query Analyzer, and Profiler. So, you may have a hard time even verifying that the MSDE install went fine, never mind creating databases, objects and users. There are several ways to manage MSDE installations.

Some of the tools listed below are free, others have a range of pricetags. We will try to update the links to indicate which ones are free.

(Please let us know if we missed your favorite product, or if you have a favorable or non-favorable review of any of the tools listed below.)

read more »

DECLARE @now DATETIME SET @now = GETDATE() PRINT dbo.FormatDateTime(@now, ‘LONGDATE’) PRINT dbo.FormatDateTime(@now, ‘LONGDATEANDTIME’) PRINT dbo.FormatDateTime(@now, ‘SHORTDATE’) PRINT dbo.FormatDateTime(@now, ‘SHORTDATEANDTIME’) PRINT dbo.FormatDateTime(@now, ‘UNIXTIMESTAMP’) PRINT dbo.FormatDateTime(@now, ‘YYYYMMDD’) PRINT dbo.FormatDateTime(@now, ‘YYYY-MM-DD’) PRINT dbo.FormatDateTime(@now, ‘YYMMDD’) PRINT dbo.FormatDateTime(@now, ‘YY-MM-DD’) PRINT dbo.FormatDateTime(@now, ‘MMDDYY’) PRINT dbo.FormatDateTime(@now, ‘MM-DD-YY’) PRINT dbo.FormatDateTime(@now, ‘MM/DD/YY’) PRINT dbo.FormatDateTime(@now, ‘MM/DD/YYYY’) PRINT dbo.FormatDateTime(@now, ‘DDMMYY’) PRINT dbo.FormatDateTime(@now, ‘DD-MM-YY’) PRINT dbo.FormatDateTime(@now, ‘DD/MM/YY’) PRINT dbo.FormatDateTime(@now, ‘DD/MM/YYYY’) PRINT dbo.FormatDateTime(@now, ‘HH:MM:SS 24’) PRINT dbo.FormatDateTime(@now, ‘HH:MM 24’) PRINT dbo.FormatDateTime(@now, ‘HH:MM:SS 12’) PRINT dbo.FormatDateTime(@now, ‘HH:MM 12’) PRINT dbo.FormatDateTime(@now, ‘goofy’)

Artigo Completo Aqui

Explicitly converts an expression of one data type to another. CAST and CONVERT provide similar functionality.

Syntax

Using CAST:

CAST <strong>( </strong><em>expression</em><strong> </strong>AS <em>data_type </em><strong>) </strong>

Using CONVERT:

CONVERT <strong>( </strong><em>data_type </em>[ <strong>( </strong><em>length </em><strong>) </strong>] <strong>,</strong> <em>expression</em> [ <strong>,</strong> <em>style </em>] <strong>)</strong>

<strong>
<div style="text-align: center"><img alt="SqlCAST.gif" id="image223" src="http://www.galhano.com/blog/wp-content/2006/12/SqlCAST.gif" /></div>
</strong>