Forum Replies Created
Viewing 15 posts - 46 through 60 (of 112 total)
-
RE: rowtype in sqlserver
I don't think it exists.
Here the link to the Microsoft article Migrating Oracle Databases to SQL Server 2000
Look at the User-Defined Integrity section with example
-
RE: NOT IN with subquery
Thanks, Greg, for posting the link - I was suspected it was something to do with nulls, but the article got complete explanation of it.
-
RE: get a sorted query into a temp table
Just add Order By to your query, like:
CREATE TABLE #tbltest
(ROW_ID INTEGER IDENTITY(1,1)
,Client_Code int
,Client_name varchar(100)
)
insert #tbltest
select Client_code,Client_name
from tblClient where Date_Created >'05/01/2002'
order by Client_Code
-
RE: Self joined update statement
Change your statement
quote:
update emp
set data = b.data
from
emp a join emp b on a.parent_key = b.emp_pkey
where b.data is null
-
RE: Can Sproc return values be used in a query (update
quote:
Hi:This may be a reach, but here goes:
I have a stored procedure that returns a list of values as an output parameter:
@strLicenseSNHistory...
-
RE: syscolumns xtype
quote:
Is there a function which decodes the xypte idDo you mean xtype?
-
RE: User Interface
You can pass all your parameters to the back end and process them there.
There are different ways to process multiple sets of parameters, one of them
I showed in the...
-
RE: Stored Procedures information
Jo,
You've got me on this one!
I've created a stored procedure, that will give you exactly what you are looking for:
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=315
Let me know, please, if it worked for you.
Eva
-
RE: Miscrosoft not supporting language
I don't believe it could happen, may be the ansi standard could be adjusted to Microsoft standard
-
RE: ID Field
Your ID column have to be designated as Identity column.
Usually it created automatically when you insert all other values.
If you want to insert an explicit value into identity column...
-
RE: sa password not working!
BOL has following info:
A sort order ...determines the sequence of rows in the result set of a query.
The sort orders available depend on the character set you chose....
-
RE: Are you a "hunt and pecker" or a "typist"?
I'm a "hunt'n'pecker" but trying to use as many fingers in a time as I can (usually 2-3 on each hand).I have to see the keyboard. Tried to learn to...
-
RE: Stored Procedures information
I think that this script from another forum could help you out or at least push you in the right direction:
-
RE: xp_sendmail vs. xp_send_mail
I found it while looking for smthng on Microsoft web site .
Will avoid to use it!
Thanks,guys, problem solved!
Edited by - EPol29 on 04/30/2002 2:49:40 PM
Viewing 15 posts - 46 through 60 (of 112 total)