| Groups | Blog | Home |
|
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 |
Filter by week: 1 2 3 4 5 SELECT STATEMENT PROBLEM Posted by Timothy Robertson at 1/7/2006 10:34:10 AM Hi,
I'm pretty new to SQL, I have created a SELECT statement that uses 'CASE' to
test a value and create a new varaible. Can I use that variable then in the
'WHERE' clause, I keep getting the error that the new 'COLUMN NAME IS
INVALID', so I'm guessing not, below is the SELECT statement, any
...more >>
Weird problem with identifiers Posted by Jack at 1/6/2006 3:33:24 PM I have made a query to a linked informix server on a sql 2000 server and the
following worked in query analyzer but not when I copy it to a view, here it
changed double quotes to [
How do I solve this ?
SET quoted_identifier OFF DECLARE @test DATETIME DECLARE @dato
nvarc...more >>
SQL Server 2005 Ports Posted by ipramod NO[at]SPAM gmail.com at 1/5/2006 3:38:19 AM Hi,
Please give me port numbers used by SQL Server 2005 or is it the same
that is used by SQL Server 2000?
Let me know ASAP.
Regards,
Pramod
...more >>
How to get triggers code for given table ? Posted by Wladimir Mutel at 1/4/2006 3:30:34 PM Hi,
In Enterprise Manager, I can open context menu for a given table,
choose "Manage Triggers" and view/edit triggers code.
Now I would like to know how to get trigger code programmatically,
f.e. by script. What query should be run on SQL server to
achieve that ?
...more >>
Selecting system_user versus defaulting it Posted by Garth Keesler at 1/3/2006 4:28:29 PM We have a column called 'userid' in each table for saving the user that
did the last update to the row. We also make the default access for NT
logins to be DBReader (or an equivalent read-only role). We also define
an App Role which the application invokes by calling sp_setapprole with
the a...more >>
REPLACE ALL Posted by Preacher Man at 1/3/2006 8:54:09 AM What is the SQL equivalent to a REPLACE ALL command in VFP?
I found this in the help section:
SELECT REPLACE('abcdefghicde','cde','xxx')
GO
Is this the full syntax and where would I use this command, I tried in the
EM but it doesn't seem to work.
...more >>
Application Roles and Current_user Posted by Garth Keesler at 1/3/2006 6:57:51 AM I would like to have all users with read-only permissions except when
they are accessing the database thru a particular application. I would
also like them to retain their current_user identity when running that
app. The docs indicate that the current-user becomes the app role login
when the...more >>
Inserting a date? Posted by David Veeneman at 1/2/2006 8:14:40 AM I've got a very simple question that I can't find in the Google archive: How
do I format a date in an INSERT query?
My query is in a .NET program, and it looks something like this:
string sqlQuery = "Insert into MyTable (SomeIntField, MyDateField,
AnotherIntField) Values (0, 01/02/...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Excel DBCC Error Posted by GarthK at 1/2/2006 4:33:32 AM I'm getting "User 'Test1' does not have permission to run DBCC TRACEON."
when trying to connect Excel to SQL Server 2005 using an ODBC System
DSN. I've discovered that this is due to Excel or, more appropriately
MSQuery, attempting to set traceflag 208 having to do with quoted names.
What I ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |