Search results for query: *

SQLServer 2005 SQLServer 2000 Can sql server full-text index and apply appropriate word breakers for a unicode column? Data in the column can be in any language. if so, what are the drawbacks? would it be better to keep data separate (1 column for every language or 1 table for every...

I have 2 instances of SQL on the same server. SERVER\INSTANCE_A SERVER\INSTANCE_B I create a linked server connection 'LINKED_SERVER' on both instances (the linked server MUST have the same name on both instances... Now, I want LINKED_SERVER on SERVER\INSTANCE_A to point physically to...

hi Gurus. When you create a ERD using Enterprise Manager's diagram utility -- you are able to see column descriptions. (You can also add column description when Designing table in Enterprise Manager. Where in system tables is this value stored? (it's not in syscolumns where it would make the...

hi gurus. here is how I simulate an orphaned transaction from a query analyzer window: --create table create table xxx (i int) --initiate a transaction (do not commit or rollback) begin tran insert xxx (i) select 1 once the transaction is open, pull the network cord from the client machine...

hi. when i create procedures that select form non-existing tables, the procedure compiles without error... is there an option that would not allow creation of such procedures?

hmmmm... There has to be a good solution to this, but i can't find it. Hope you guys can help me. Application inserts rows into a table. My code has to assign a new primary key to every row. Ideally the primary key is INTEGER, and every new row gets PK = max + 1. I know i can use GUID's...

is there a command that will extract the binary components from a number? example 1 in the database: 0000 0111 (7) i need this command to output : 1,2,4 in the database: 0010 1010 (44) i need this command to output : 4,8,32

can table variable be used as an input parameter to sp? can a procedure return a table variable?

hi. Here's the code that gets executed to script objects. I've always used sql authentication for sp_OAMethod, but i'd like to change that to windows authentication... Does anyone know how to code sp_OAMethod to use local windows account? Thanks!! DECLARE @object int, @hr int, @return...

hi. i know this has been discussed before, but i can't find it. What is a good way to track object changes (tables, sps, constraints, etc). Can't have a trigger on system tables so that's not an option. does anyone currently do this? Thanks!

hi. newbie to oracle. I'm trying to log the number of records affected in a transaction. what would be oracle's equivalent to sql server's: insert...select.... insert log_table select @@rowcount, getdate() thank you.

hi. i need to perform an operation on every partition in the table. I want to make the procedure flexible, so that if more partitions are added, the procedure doesn't have to change. I'm planning to cursor through partition names, build a string and execute it for every iteration. Is there a...

hi gurus. Newbie to Oracle. I need to pass a table name as a parameter to a stored procedure and then select from that table. In sql server this would require building / executing a string (code below). What would be the equivalent syntax in pl-sql? Alternatively, can you use a variable...

hi. what is the index hint syntax in Oracle? I'm trying to: select * from table (index = INDEX_NAME) where val = xxx thanks

hi. what is the equivalent to SQL Server's case statement in Oracle? query: select case when isnull(VALUE) then 'Value is null' else VALUE end from TABLE thanks

hi. i'm having some problems using SQLServer DTS utility to transfer data from SQLServer to Oracle. Is there an oracle utility i could use to pull the data from SQL rather than push it using SQL2K DTS? thanks.

hi. i have a string date: '19981231' i need to get a date that's 1 year back from this date. what function would i use to convert this string into datetime and then minus 1 year from it? thanks!

hi, i'm working with oracle for the first time (after 5 years as sql\sybase dba). I'm being told that something called the 'Concepts Guide' is mandatory reading for beginner Oracle dbas. But i cannot track it down online anywhere. Please post a link if you know what it is. Also suggestions on...

hey all! i posted this about a year ago -- nobody replied... so, bump.... Hope someone can explain the following phenomenon: After creating a new index, running DBCC INDEXDEFRAG on this index will move ALL(????) pages in the index (Pages Scanned = Pages Moved). If DBCC indexdefrag is executed...

is there an Oracle equivalent of SQL Server's: select * into new_table from other_table where blah blah? i want to create a new table with the same schema as 'other_table' thanks.