You are here: Re: server version « MsSQL Server « IT news, forums, messages
Re: server version

Posted by John Bell on 12/29/06 09:11

Hi

Regarding your other thread "prompting users", as you are using SQL 2005
then you can make your script execute particular actions by setting
variables and passing them to SQLCMD. These variables can then set by
prompting the user in a batch script or WMI script and then within your SQL
script they can be tested. There is more on this in Books Online.

John

"fireball" <fireball@onet.kropka.eu> wrote in message
news:en0qnc$gf2$1@atlantis.news.tpi.pl...
> Uytkownik "John Bell" <jbellnewsposts@hotmail.com> napisa w wiadomoci
> news:4593b698$0> > IF CAST(LEFT(CAST(SERVERPROPERTY('productversion') AS
> varchar(30)),1) AS
> [...]
> I love newsgroups :-)
>
>
>
>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация