Hi, I need to audit a column with Text datatype. SQL Server does not allowing me to use Text datatype with inserted/Deleted tables. I know this can be accomplished by using instead of trigger. But I need to update the base table and insert old 'n' new values (Text datatype) in Audit table....more >>

I requested the help to do a replication of a database. We consulted Books Online, and other books, and we began to set up her replies. We are coming across the following situation: in all the read examples several servers exist, and in our case we want to create her he/she replies inside of th...more >>

Hi.. I have been asked many times the following question... "HOW TO SEE THE TRANSACTION LOG THROUGH ENTERPRIZES MANAGER" Well i think its not possible but i m not sure. U R any help will help me getting a forture. THANKS FROM THE HEART in advance Regards Manoj ...more >>

I still not sure what is GO command. In online spec, it says "Signals the end of a batch of Transact-SQL statements to the Microsoft® SQL ServerT utilities." Please give me more clear explaination. thanks, John ...more >>

Is there a way to auto start sql service when OS starts w/out using sql server service manager? That is, via code. any help is appreciated jim...more >>

What I mean by "partial" - I need some changes to remain in database after a rollback. It shall be used in a logging system - even for a unsuccessful long transaction I need to have some info about its progress and the reason of failure to stay in a log-table, to track and analyse it later. I u...more >>

Hi, I am having a rare situation when executing this store procedure: create procedure test AS declare @pk int begin tran insert tbltest (...) values(...) if @@ERROR = 0 BEGIN COMMIT TRAN SELECT * FROM vwWorkOrder WHERE PK=@@IDENTITY END else ROLLBACK TRAN GO this store pr...more >>

Ok, I accidentally deleted a few rows. However, I do have a backup. Is there a way to restore from the backup those rows that I deleted instead of the entire database? I thought that maybe in the worst-case scenario I could use DTS. Scott...more >>

I need to create a dynamic SQL statement in a user-defined function, but the statement needs to return values back into local variables: SELECT @s = N'select @num=TheColumn FROM MyTable' to do this, I need to use sp_executesql: EXEC sp_executesql @s, N'@num int OUTPUT', @num OUTPUT but ...more >>

I recently noticed in code I'm maintaining that several queries of the form select id from table1 where idasint=10order by idasint are being sent to SQL Server. I kind of expected a parse error but maybe not. I tried various other statements to test the limits of the parser such as se...more >>

I have a table with MID PID date bcode seg 1 1 1/1/03 9 1 1 2/1/03 8 1 1 3/1/03 8 1 2 1/1/03 9 1 2 2/1/03 7 1 3 1/1/03 8 1 3 2/1/03 ...more >>

Friends, How can i get the number of lines affected by a delete command? I want to know this number, after this happened, not before with a select. Thanks Leandro Loureiro dos Santos Vitória-ES / BRAZIL ...more >>

Hi, I am a SQL newbie trying my best to learn how use, maintain and create Stored Procedures. I recently bought a SQL addin RAC that makes it simple to create Access Type CrossTab Queries. Basically RAC is a stored procedure that uses a (truly mind numbing) number of parameters. I am Singing a...more >>

Hello, I need some guidance. Ok, here goes... I created a stored proc to FETCH rows from one column in a table that are delimited with a semi-colon. Example: Codes ------- A1234;W1234;TM4545 A1234;W1234 A1234;A21234;W1234;W21234;TM4545;TM24545 The next step was to insert these r...more >>

I have a table [CAR] Guid UNIQUEIDENTIFIER NEWID() Car VARCHAR(20) I have a table [Components] Id INT Identity(1, 1) NOT NULL Component I have to build another table that will look (i think) in this way: Id INT Identity(1, 1) NOT NULL Car_Guid UNIQUEIDENTIFIER -- Foreign key of C...more >>

I want to preficate that I had nothing to do with coming up with this convention, but I am tasked with correcting the situation. This is where I need your help. Here is the situation. I have a table with four columns. Customer( ID int, LastName varchar(50), FirstName varchar(50), C...more >>

I have: Table1 and Table2 ID [Integer] ID[Integer] with these records in Table1: 1 2 3 4 and these records in Table2: 2 3 I'd like a select statement that retrieves record 1 and 4 out of Table1 - Can anyone enlighten me? Thank you! Dan ...more >>

I am trying to get each product ID, its description, and its category (obsolete products do not have a category) by going through an intermediate table. The following query gives an error: "The table 'ItemCategories' is an inner member of an outer join clause. This is not allowed if t...more >>

Hi, Probably a simple question but say I have a table. I wish to copy the structure of that table into a new table (in the same database). From there I wish to move certain records from the original table, for example all records before a certain date into this new table. Can anyone point...more >>

Hi The problem I want to join table1 with table2 where idTable1(indexed) = idTable2(indexed) Table2 is a "small" table 1 mill records, table1 is quite big 15 mill records. A. When I do the where on table2, using LIKE 'xxxx%' is is fast ! B. When I do the where on table2, using LIKE '%x...more >>

How do I pass a datetime paramter to linked server using OPENQUERY ? Any help is appreciated....more >>

Hi guys, If you look down below in the window there is an unanswered post. I posted it in the morning. It is a long one as it contains the DDL. First part just creates a table and next 20 lines are just plain inserts to this table so that you guys can mimic for the scenario and come up ...more >>

Hi, I know that i can store result of a stored procedure into a table with TSQL command like this: INSERT INTO tblWho EXEC sp_who The problem is INERT INTO needs a pre-created table matches with column name/type returened by stored procedure. Is there any command that create a table and ...more >>

I need to update my SQL 2K server with data from another SQL 2K server that I have been granted limited rights to. I have tried a view with the Server.Database.Table.Field and get the "contains more than the maximum number of prefixes. The maximum number is 3.' error. I did Exec sp_addlinkedser...more >>

I have need to find out the dublicate records: In Table I have [ID] and lastname and firstname. lastname and firstname may be the same, but different id. How do I found the students with the same firstname and lastname....more >>

Hi, Is there a way of stopping SQL server 2K form recording transactions in it's log when processing records in stored procedures.. I have a number of sprocs that need to process data into tables that are used for reporting. We can't use temporary tables because the software that is pick...more >>

I am looking for a sql query which can find current data page size of a given table. Any help will be greatly appreciated -Mohanjit ...more >>

I want to install MSDE service pack 3 by using: setup.exe INSTANCENAME="MYSERVER1" SAPWD="pass" but I got wrong instance name error. How to do that?...more >>

how to check which SQLServer service pack version used in each instance of SQLServer database? for example, how can I get which service pack used for SQLSERVER1,SQLSERVER2 instances that my computer installed....more >>

I have a table in which one of the fields has a value calculated based on an stored procedure. This value has to be left blank by the application and filled by the database in any way. The way I found to do this is to create a trigger for insert, in which this value is filled by issuing a...more >>

I am running a query that takes the cross product of a table against itself and uses some trigonometry functions to determine the distance between all the values. The cross product works but when I introduce the trig function only part of the result set comes back. No error is reported o...more >>

Hi there, is there an equvalent function in SQL Server like the C GMTime to convert the numbers of seconds since 01/01/1970 to a datetime value? ...more >>

Hi Is there any way when I alter a stored procedure it should automatically updated the stored procedure in different database. Thanks Balaji ...more >>

How do you configure BULK INSERT to ignore the first line of our CSV file. The first line contains column information and not the data. This is what we have so far... BULK INSERT Northwind.dbo. [ACSTest] FROM 'c:\test.csv' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' ) Th...more >>

Hi all, I want to print the values inserted or update in a Table in to a green bar printer. This is like a log . How do I achieve this. Any Idea please advice me. Thanks Naveen ...more >>

is there a way to declare an optional parameter in a stored procedure (SQL Server 2000)? i have a lot of procedures that i use repeatedly throughout our system, but they do not always require the same param values. rather than sending null values to the procedure i thought it would be ea...more >>

In an effort to facilitate code reuse, I have created a stored proc that creates a temp table. According to SQL Server documentation, this table "is deleted when you disconnect." My experience is that a temp table is deleted BEFORE I disconnect. I cannot even reference one immediately after ...more >>

Hello, I have problem: My *.txt file is like it: " 12345612345678123 abcdefabcdefghabc " etc. i want upload data into table (for example TEST) i want to sql read this file and automatically upload to table.(as job for example) but i have 3 columns and i dont know how to separate this...more >>

I have a database that has repeated measures. PatientID, BPat5mins, BPat10mins, BPat15mins,...............BPat30mins. I am telling my co-worker that instead the table design should be PatientID, BP, TimeInterval My co-worker is telling me that the first way allows for easier grouping and...more >>

Hi, is it possible to declare an array variable in tsql ? something lite Myvar1(100) and Myvar2(10,100). If, not, any workarounds to handle many variables ? (I've tried to write the code in a VB-script, but it was to slow). /J...more >>

Hi, can somone please help me with this problem. I'm parsing a text file that holds call information. I've dumped the text file into a table and parsed it the best that I know how. However, I'm having a problem getting the date on every call record because the date will only appear once a...more >>

studentID,# of exams, # of passGrades, exam, result Database is designed to return all above but it prints the exam and result part only if result < 50. select studentID,# of exams, # of passGrades, exam, result from A, B, C where C.result < 50 resulted in nothing to return if there are ...more >>

How do you get the loginname and hostname used during a proc? Semper Fi, Red ...more >>

Hello, I need an equivalent of REPLACE() function for NVARCHAR characters. Current REPLACE returns VARCHAR. I am using SQL Server 2000. Example: REPLACE('Some long non-english string','non-english string','tail') should return N'Some long tail'. Instead, it returns 'Some long ????'. ...more >>

Is there a standard or recognised / adopted document for naming conventions for SQL Server Objects...more >>