| Thread | Last Post | Replies |
|
| using SQL to do a transpose (something like that) | 10 Aug 2005 22:48 GMT | 14 |
I have two tables, T and U, that look something like this:
Table T
EmpNo EmpName
---------- ---------------
|
| Help with trigger | 10 Aug 2005 22:37 GMT | 1 |
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
|
| Table Design Question | 10 Aug 2005 20:41 GMT | 1 |
I want to have a column in a table in my database to store a variable
amount of text.
The text will NEVER be null, but will often be quite short (10-50
characters).
|
| For XML: create elements using cell values | 10 Aug 2005 20:19 GMT | 12 |
If have a sql table with 2 columns and 2 rows with values
[["col1row1","col2row1"],["col1row2","col2row2"]].
Using t-SQL with "for xml"
How can i create a xml where the cell values (not column names) appear
|
| Temporarily Disable Logging | 10 Aug 2005 19:36 GMT | 1 |
Can I temporarily disable logging on a Database? I've written an
application which is moving data from another vendors DB, to MS SQL Server
2005 (Beta 2). I would like to get as much performance out of this
operation as possible, I thought maybe disabling the Log file would help,
|
| Number of rows | 10 Aug 2005 17:37 GMT | 2 |
What is the syntax to limit the number of rows returned in a result table???
I want to look at only a sample; not all 300,000 rows.
Thanks!
|
| How to know a Job Status from Stored Procedure | 10 Aug 2005 16:21 GMT | 1 |
To execute a job from VB, I use stored procedure with T-SQL :
EXEC sp_start_job @job_name = 'DTSName'
>From BOL, I know that procedure return 0 (success) or 1 (failure), but that's only to tell user that job successfully started, right?
|
| Select with aliases, please help | 10 Aug 2005 16:19 GMT | 3 |
UPDATE [TABLE1] SET Stat="T",TransferedTo=b.Store
FROM [TABLE1] a
WHERE stat = "PS"
AND EXISTS(
|
| row sumamary | 10 Aug 2005 11:28 GMT | 1 |
Hello. please help.
what is the best way to summarize rows?
I have a table like this
RowNumber col1 col2 col3 col4 col...N
|
| number format to 2 decimals | 10 Aug 2005 09:29 GMT | 4 |
How can I format my data to 2 decimal numbers in sql ?
select numericColumn from table1
ex :-
numericColumn
|
| Stored Procedure Parameters | 10 Aug 2005 06:33 GMT | 3 |
is it possible to use a Select expression as a parameter for an Stored
Procedure.
something like:
DECLARE spTest @id as NVARCHAR (4)
|
| User Defined Function Help | 10 Aug 2005 06:31 GMT | 2 |
I have a database that stores a number. I need to have a built in function
that will apply a function to the number and then return the number that
produces the largest number. How can i do this?
eg.
|
| MAC Address attribute | 10 Aug 2005 02:07 GMT | 1 |
I need to store MAC Addresses. What is the standard way of storing this
type of attribute? Datatype? I can't find any discussions about this
anywhere.
Thx for any pointers.
|
| Can't connect to Access project | 10 Aug 2005 00:53 GMT | 1 |
I've given a copy of Access project to user (win2000prof) but not able to
connect to SQL server on remote server.
SQL driver in use on client is 3.70.09.61 - this gives error DBNMPNTM
specified SQL server not found.
|
| Ansi Nulls and quoted identified | 09 Aug 2005 22:21 GMT | 17 |
SQL Server 2000. I have a database in which there are several objects
which have ansi nuls and quoted identifier turned ON. Is there a way I
can generate a script which:
(1) Can identify all objects within the database that have those two
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread