|
|
|
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 trigger to skip double entries? Posted by Daves at 2/7/2006 8:07:16 PM hi
I'm using a INSERT ... SELECT statement to insert UserID values into a
table. I need some function to make sure that no double entries are created
with the UserID but a trigger I guess would create an error and halt the
procedure - is there some way to have a trigger simply skip/delete row...more >>
UDF Help Posted by Nat Johnson at 2/7/2006 5:49:31 PM Totally new to writing UDF's and not sure how to go about it. Just need
pointing in the right direction.
Senario:
User enters into a field on webpage either a Premise No or a Person Id.
Then clicks on a search. System does a check to see whether the number
entered has any alpha charac...more >>
SPRoc question Posted by Gary Wardell at 2/6/2006 10:10:29 AM Hi,
I'm sort of new to SQL and SQL Server.
In Query Analyzer; Is there a way to call a stored procedure from a select
statement so that I can filter and sort the output with where and ordered by
clauses to see what the stored procedure is returning for troubleshooting
purposes?
The store...more >>
Change authentication mode SQL server 2005 Standard Posted by Christian Ista at 2/5/2006 6:56:12 PM Hello,
Could you tell me how to change the authentification mode for SQL Serv 2005
Std ?
I found (no tried yet) via the registry but no other way (via GUI) ?
Thanks,
...more >>
import .sql dump file into Access or MSSQL? Posted by Nathon Jones at 2/4/2006 5:12:03 PM Hi,
I have a .sql txt file, provided as a back up of a MySQL database from our
ISP.
When I open this in Notepad, the first line begins:
DROP TABLE IF EXISTS store_category;CREATE TABLE store_category...
Which, to me, appears to be SQL code for creating new tables, and
populating them.
...more >>
Last inserted ID in MSSQL Posted by Tom at 2/4/2006 2:41:28 PM Is there any solution? Do you know some and would like to share? Please
Tom
...more >>
Database Mirroring Posted by Randy at 2/3/2006 6:44:54 PM Has anyone in this group been able to get database mirroring to work yet in
SQL 2005? Having been working on it off and on for a couple of days now
using the AdventureWorks database. Got my two endpoints established without
any issues but after I configure security for this mirroring session...more >>
Help with merging 2 queries Posted by Denise at 2/3/2006 12:00:00 AM Hello
I'm using SQL Server 2000, and am trying to produce a report using data
from 2 queries. I haven't had any success with this, and am wondering if I
can instead merge the 2 queries into 1.
The queries are as follows:-
Query1
SELECT tblanswers.questionid, subtopicid, description, ans...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
calculating 2nd highest Posted by Amit Mohod at 2/3/2006 12:00:00 AM Hi All,
Can anybody tell me what will be the SQL Query for finding the employee
with second highest salaray in the company. There may be several employees.
ur help will be of gr8 help
Regards
...more >>
indexing Posted by Troy at 2/2/2006 8:35:41 AM hello,
If i reindex a db in simple mode will the log file grow the same size as the
database?
thx
...more >>
sql query question Posted by mattmerc NO[at]SPAM bellsouth.net at 2/2/2006 6:12:53 AM Hi all,
I'm looking for some sql code to query a database, and what I want
returned is a description of a specific table or all tables in the
database. I'd like to run a query that returns:
table name
fields
field data types
etc...
Like a summary of the table(s).
How can I do this...more >>
SQL 2000: Extra padding (whitespace) in char column... Posted by Andrew Wilcox at 2/1/2006 7:53:21 PM Hello,
I have a suppliers table in my database, with the 'name' column defined as
char(35). My problem is that SQL seems to add padding to make it 35 chars,
for example, "Office Depot ". I have tried Googling
and looking on the SQL newsgroups to no avail. This also hap...more >>
SQL 2005: Row-Level Versioning Posted by Jane at 2/1/2006 1:00:51 PM Is there a way to see if a database has row-level versioning on/off from the
Management Studio window, or do in need to run a T-SQL statement?...more >>
Calculate percentage based on another field Posted by Denise at 2/1/2006 12:00:00 AM Hello
I am using SQL Server 2000.
I need to calculate percentages in one field, based on the grouping of
another field. To explain, I have a table that lists questionid, answer1,
answer2, & answer3. For each questionid, I need to calculate the
percentages of each value in the answer1 fi...more >>
How to lock a table? Posted by Xmas at 2/1/2006 12:00:00 AM I have a table that I need to do a whole lot of manipulations to in a
stored procedure, including copying a whole bunch of it elsewhere,
dropping the original table and then recreating it.
The process takes about three minutes. During this time, I want to stop
any other users attempting to...more >>
convert date to string Posted by Senthilkumar at 2/1/2006 12:00:00 AM Hi,
I am designing a query in MS Sql in which i want to transform the Date value
to Mar' 06. How can i do this. Based on an earlier question, i tried using
the
convert() function w/o any luck.
Help will be very much appreciated
Senthilkumar
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |