|
|
|
January 2003 March 2003 April 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 April 2008 August 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Creating triggers Posted by Dariusz Hoszowski at 9/6/2003 6:33:39 PM Hi,
I wonder how to create trigger (if it is possible) from stored
procedure - my trigger is too long to pass it from my program and i have to
create a trigger for user tables when they are creating them... Any
suggestions ??
Thanks
Dariusz Hoszowski
...more >>
how to get the list of databases a specific user has access to ? Posted by mariahzhu at 9/6/2003 4:08:21 PM I need to figure out in my C# code the list of databases a
specific SQL Server user has access to on a certain
server. Is there a system store procedure to do that? I
found sp_helplogin and sp_helpuser. But neither gives the
needed information....more >>
Sproc needed for creating DDL and some sample data for posting to newsgroup Posted by Ajit Singh at 9/6/2003 12:09:37 PM Hello Group,
As a good practice, we need to provide the table DDL and some sample data
for posting any problem to the group. Does anybody has a procedure which
accepts the following inputs and gives the DDL and sample data:
TABLE name
Number of rows of sample data to be generated
the out...more >>
PreparedStatement~ Posted by Vitamin at 9/6/2003 11:16:59 AM Hi all Professor~
Does MSSQL have something function like Oracle's PreparedStatement??
thx~~
...more >>
Basic DB Design Query! Posted by Steve Turton at 9/6/2003 10:05:50 AM Hi All, I have a DB that is only accessed from a Visual Basic App using
'TestUser'.
Is it best to Deny TestUser all permissions to all tables, but allow access
to the database through stored procedures - meaning if one of the developers
needs to have a 'select count(*) ...' on one of the tabl...more >>
Removing record affected Posted by Roy Goldhammer at 9/6/2003 9:20:56 AM Hello there
I need to remove the message of how many record affected on the query
anlyser and on the osql
How can i do this?
...more >>
C++ & SQL -- Books? Posted by AC at 9/6/2003 7:00:45 AM Hi,
Can anybody recommend a good book for programming VC++ applications using
SQL server as a data store? Any type of book for interfacing C++ with SQL.
Thanks.
...more >>
How trigger to fire only in sone occasions Posted by Gonçalo Boléo at 9/6/2003 3:28:29 AM My table has triggers to insert, update and delete to audit what happens.
I have 2 servers with that table that sincronize data between them. To
sincronize data i use my own sps because i need some tests and possible data
alteration between them.
I don't want to audit the table with the data i...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|
| home · blog · groups | Questions? Comments? Contact the dn |