|
Home > Archive > MS SQL Server > November 2005 > TRIGGER
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| -00Eric Clapton 2005-11-04, 3:23 am |
| Can I implement trigger with visual basic or other programming language and
how is it? Thanks.
| |
| Tibor Karaszi 2005-11-04, 3:23 am |
| Do you want to write the trigger code using some other language than TSQL? If so, you need to use
SQL Server 2005, which hosts CLR in the database engine. You can now write triggers using VB.NET or
C#.NET. But you should analyze first whether it is a good idea to do such or not.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
" -00Eric Clapton" <a@b.com> wrote in message news:%23nuffmQ4FHA.472@TK2MSFTNGP15.phx.gbl...
> Can I implement trigger with visual basic or other programming language and
> how is it? Thanks.
>
>
| |
| -00Eric Clapton 2005-11-08, 9:23 am |
| Tibor,
What is CLR? I reason I want to use other language is that TSQL
is very hard to debug and maintain? Or I don't know the correct way to do
it. Any suggestion. Thanks.
E
"Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com> wrote in
message news:u4Vrf$Q4FHA.476@TK2MSFTNGP15.phx.gbl...
> Do you want to write the trigger code using some other language than TSQL?
> If so, you need to use SQL Server 2005, which hosts CLR in the database
> engine. You can now write triggers using VB.NET or C#.NET. But you should
> analyze first whether it is a good idea to do such or not.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
>
>
> " -00Eric Clapton" <a@b.com> wrote in message
> news:%23nuffmQ4FHA.472@TK2MSFTNGP15.phx.gbl...
>
>
| |
| Gail Erickson [MS] 2005-11-08, 9:23 am |
| > What is CLR? I reason I want to use other language is that TSQL
> is very hard to debug and maintain? Or I don't know the correct way to do
> it.
CLR is Common Language Runtime. There are some good information here:
http://msdn.microsoft.com/sql/learn...lr/default.aspx
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
" -00Eric Clapton" <a@b.com> wrote in message
news:OCVrYJ04FHA.2888@tk2msftngp13.phx.gbl...
> Tibor,
>
> What is CLR? I reason I want to use other language is that TSQL
> is very hard to debug and maintain? Or I don't know the correct way to do
> it. Any suggestion. Thanks.
>
> E
>
> "Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com> wrote
> in message news:u4Vrf$Q4FHA.476@TK2MSFTNGP15.phx.gbl...
>
>
|
|
|
|
|