Consider the following WHERE clause: ...WHERE (Col = 1) OR (Col IN (SELECT OtherCol FROM OtherTable)) Would it be different performance-wise from the following: ...WHERE Col IN (SELECT 1 UNION SELECT OtherCol FROM OtherTable) Thank you....more >>

I have a table with hundreds of thousands of records. I don't want to get into why, however I need to take all this data and save it to file. Now I can do this fine with Query Analyzer saving to file, however every 15,000 records I need to continue writing to the "next" file. Is there a way t...more >>

I am new to TSQL and cannot find anything in my reference book or on the internet about how this can be done. If so, can you let me know how. Many thanks Tom...more >>

I am connecting to my SQL Server 2000 database with a Windows NT security login. Several of my tables require a timestamp and user id for row added. I use getdate() for the former default and user_name() for the latter. This works great if I'm using any SQL logins-- however, neither of the f...more >>

I wrote a stored proccedure with nested cursors. If one condition failed in the first child cursor, break that child fetch, and should go to the parent cursor and continue looping to next row. My problem is when a condition falis in CHILD 1, then the PARENT FETCH also exiting. It is not going ...more >>

I have an exiting database which I'd rather not manually recreate that I'd like get a backup file from that I can restore to a 2000 database. Is this in principle possible? Paul ...more >>

I’m trying to key the syntax for replacing the Apostrophe with double Apostrophe and update table. Example: Programmer’s with Programmer’’s Here code for finding occurrences: SELECT DEALNAME FROM DLWKTABLE20060609 where dealname like '%['']%' BUT how do I update: Update dlwktabl...more >>

I'd like to return a NULL value from a mssql function, but i can't get it to. here's my sample: CREATE FUNCTION dbo.FixVarChar (@val nvarchar(30) ) RETURNS nvarchar(30) AS BEGIN declare @retval as varchar (30) select @retval = case when len(@val)>0 then @val else null end return (nul...more >>

I have a simple view something like "SELECT * from <table_name> order by field1,field2,field3 I have a program that needs to read these values in by the order I have ordered them in the database however it needs an incremental numeric value to do so. Is there any way to add to the view, a fiel...more >>

Folks, I am wondering if there is workaround for distributed transaction query in loopback linked server. Thanks ...more >>

Hi all i need to write script that check if there is any 'Startup stored procedures ' , how i write it? Thanks ...more >>

an existing application sends server an sql string like insert into dbo.test (c1, c2) values (1, '22.1.2006 10:10:10') where c1 is an int, and c2 is a datetime field. This command returns an error. Server: Msg 242, Level 16, State 3, Line 1 The conversion of a char data type to a datetime ...more >>

Given a column id/name and table name/id I need to find out if the column is a primary key. I have checked all the SYS* tables and could not find the information I was after. Can you point me in the right direction please. Thanks. ...more >>

Any help would be appreciated. I am trying to return a recordset to a worksheet using ADO. I want to go dsn-less. I confident that my recordset returns data, I've tested this in Access and can return records there. I am a new excel programmer. I am trying to use CopyFromRecordset to ret...more >>

Hi! I have the following field: e.g this field is called admit 60124 varchar 255 (type length) I want to convert it to a date. e.g 20060124 How can I achieve this? I tried using update special set admit_date = convert(varchar(5),admit,101) Thank you! ...more >>

Can someone please tell me why this doesn't work??? I am trying to loop through a table and populate a column called LocalIDNumber with random numbers... But there must not be any duplicates! This runs perfectly but only populates the first record and not the other 5000 records in the data...more >>

Hi There, How can i use go on multiline statement, I would like to create job step which contains go in it. But i can not create. I try to use something like this EXEC sp_add_jobstep @job_name = N'Audit_Log Truncate', @step_name = N'AG Audit Log Truncate', @subsystem = N'TSQ...more >>

I've got a dynamic SQL query that is generated inside a SP, and is run using the EXEC (@SQL) or EXEC sp_executesql @SQL This has worked fine until now, where we are now using a database for unicode charachters to support Japanese language. All fixed code stored procedures return d...more >>

Hi, The following stored procedure (SP) is using a dynamic sql to build the query. How can this be written using a standard sql. i.e. NOT dynamically being built. Initially I thought I can have something like the following query but it does not seem to be working for when the where caluse par...more >>

Had a look on the site but haven`t really found an answer so hope someone can point me in the right direction. Should the calling application kill a SQL process once it has finished. If not what are the implications in terms of the memory available to the server. Thanks Si ...more >>

Hi, I have one table called sequence_number with two columns Seq_name nvarchar(50) last_num bigint. I have one function, in that i am calling extended stored procedure. this XP has to return the next seq number based on the sequence name we have given. My intension is I have get the db co...more >>

Is it possible to install SQLXML on Win 2003 with SQL 2000??? ...more >>

Sorry about the crosspost; not sure in which it belongs. I tried making a simple UDT comprising of a few integers that are closely related, and the user designed type seemed perfect (using visual studio 2005). Easily made and easily installed, and from T-SQL it works as expected. However...more >>

In SQL Server 2005 it is possible to set a compatibility level. Prior to this server we were running SQL 2000. Wil still have one linked server running SQL 2000. What I'm confused about: what does this comp. level actually do? When is it an advantage - and when not? Regards /Snedker...more >>

I've google'd like a crazy, tried a lot of stuff, but still can't get it to work: When run on our old SQL 2000 it worked fine. Now, running SQL 2005 it doesn't: An UPDATE-trigger on a table calls a stored procedure that selects data and send them to a linked server. 1. When running the...more >>

Hello I need to calculate the number of days in the previous quarter relative to 'today'. I thought it would be as simple as the number of days between today and one quarter earlier: datediff(dd,dateadd(qq,-1,getdate()),getdate()) but that gives 92 (it should be 31+28+31=90 today). Subtra...more >>

Hi, I am writing a vb.net2005 program that needs to create a stored procedure with SqlServerProject Template. Now, I have two questions for this stored procedure. 1) How can I import and execute the .dll in this Stored Procedures? 2) How can I connect the Web Service and get the result in ...more >>

Coud someone please tell me what is wrong at the line marked xxxxxx ? Adrian. using System; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data; using System.Data.SqlClient; namespace WindowsApplication2 { public ...more >>

Hi! I want to design a database that is compatible with SQL-92 standard. Does anybody know what the SQL-92 standard says about the maximal length of the varchar datatype? Thanx in advance /Svenne ...more >>

(1)select * from tmp_gltransaction where tmp_gltransaction.reportid = 'MGR-6530234110' (2)UPDATE tmp_gltransaction SET acctname = (select acctname from chartofaccount where chartofaccount.acctcode = tmp_gltransaction.acctcode and tmp_gltransaction.reportid = 'MGR-6530234110') For Sta...more >>