Hi All. I find sql command. example, javascript eval('1+2+3') the same function from Ms-sql Thanks for any help ...more >>

When is it that the result of that procedure will be different from 1? ...more >>

Hello, I have a TimeBegin and TimeEnd and want to be able to select a table that Now() is between the two dates (in Smalldatetime). Thanks, Jack ...more >>

Hi all, I am getting the below error - when i connect to sql over a c++ program. SERVER: FATAL CONNECT ERROR: E rrorNum = -1073724002, Severity = 16, State = 2: Could not load ListenOn Net-Lib rary 'SSMSSH70' ERVER: FATAL CONNECT ERROR: E rrorNum = -1073724002, Severity = 16, State ...more >>

I have managed to get an attached file from Outlook into a SQL2K table. I want to be able to use it as an OLE-type file. I would like it to have an icon and be double-clickable in a form. The file type is a .fax (a tif). Is this possible using the FileToBlob or any other method? Thank you...more >>

Hi all, I have two tables tbl_A and tbl_B. Table Definitions: tbl_A (field_1, field_2, field_3) tbl_B (field_1, field_2) I would like to populate tbl_B when a record is inserted into tbl_A. Note that tbl_A.field_1 = tbl_B.field_1 and tbl_A.field_2 = tbl_B.field_2 . How do I write a trigge...more >>

Dear All, I have simply had enough! Can anyone help? I have posted a similar question about 3 times (not that I am criticising the site) but the solutions have never worked properly. It is my lack of understanding that is the problem. I am trying to send the data from a POST form to a stored...more >>

Hi All! I seem to have a problem returning resultset from a sproc to an ado recordset. The error I get is that the recordset is closed and thus I cannot request a field value. What am I missing? The sproc is debugged and my connection is working. 'SPROC code CREATE PROCEDURE dbo.sp_mets_...more >>

Hi! I want to be able to do the following in my stored procedure: declare @v_tablename varchar(30) set @v_tablename = 'dbo.[MyTable]' select * form @v_tablename Is it possible to do this inside SQL Query Analyzer? Thanks for your input. Greg ...more >>

Hi All, I have the following table: CREATE TABLE [dbo].[tblLongVolatility_ME] ( [ID] [int] NOT NULL , [GIF] [varchar] (3) COLLATE Latin1_General_CI_AS NULL , [DateID] [int] NULL , [Identifier] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , [Pivot] [varchar] (50) COLLATE Latin1_Ge...more >>

Hi, Is it at all possible to access MS SQL data via NON SQL (the query language) methods? I.e. is it possible to get access to low level indexes (b-tree??) and add / delete methods? Basically I don't think I can ... but what I'm hoping for is a means of emulating COBOL file handling ...more >>

I have a table with shows an user's name, and sign up data and time. What is the SQL query that shows the number of users that signed up on each day for the current month?? Thanks, John ...more >>

I have a trigger that updates some remote servers via dynamic sql (sp_executesql) and linked servers. I get the following error: Server: Msg 8525, Level 16, State 1, Line 3 Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction. [OLE/DB ...more >>

Hi, have a stored proc where i check @@error for some actions. Now when something goes wrong i want to write this in a log. So how can i get the full error message which is shown for example in the query analyzer under "messages" ? thanks, Helmut ...more >>

Hi, How do I convert unicode to dbcs characters in sqlserver? Please help as this is needed urgently....more >>

Should be very easy to fix, but I can't remember how to do it. A customer on MSDE has hit the 2 gig limit on thier database size but the database has 1.5+ gigs of unused space in it. I can't for the life of me remember how to get it to release the usused space. Ahhhhh! Bob Castleman Succ...more >>

I'm using ADO.NET to call a stored procedure that runs the "BACKUP" command on selected databases. Is there any way I can capture the text output of the stored proc and return it to ADO.NET for displaying in my application? When I run the stored procedure from SQL Query Analyzer, I get an outpu...more >>

HI Friends, I am trying to use declare @s int select @s = nextval from openquery(xdev,'select ca.ca_tc_s.nextval from dual') inside my store procedure where xdev is a linked server for OLE Oracle provider. I am getting error Heterogenous queries require the ANSI_NULLS and ANSI_WARNING...more >>

Greetings. Can someone give me some pointers or a pointer to some pointers here? I need to write a script that will do some conditional stuff that I don't know if it is possible in tsql. It would do like the following: if table.column exists and table.column.length < 60 alter table set...more >>

Could anyone help me to sp_setapprole How is it used. Do I have SQL in Mixed Mode? Could anyone give me a little example of how is it done. Both sp_setapprole and sp_addapprole -- - Lars ...more >>

I am not certain which group to post this to - sorry if this is the wrong group: I have a table that holds the location of various media and such (mostly images). One field is the Media name, the other is the URL in the form http://myServer.gunnery.org/media/pic1 for example. we are about to...more >>

All I have is a DAT file to use. I am wondering if it is possible to use BCP to import this DAT file's contents into a database table. I am trying to use a command statement similar to what is shown below. bcp MyDatabase.dbo.color in data\color.dat -S MyServer -U sa -P blah Basically, ...more >>

Hi, I have two databases on SQL Server 2000 named TLCTest and TLC. I wish to copy the contents of a table named "Container" in TLCTest to a table also named "Container" in TLC. I think that the best way to do this is through an SQL INSERT statement. However I can't seem to get the syntax...more >>

esfod=case when os_odesfl is not null then cast(os_odesfl as decimal) else 0 end as it would be that transformation. for instance the text is +2.50 I want that is 2,50 that as decimal ...more >>

I have the following table: CREATE TABLE sample ( line_no VARCHAR(5) formula VARCHAR(300) ) the formula fields contains a string like 'Line(04010)+Line(04020)' or 'Line(04010)*.35' The Line function does a seek on a different table and returns a 'Double' amount I want ...more >>

Hi all, I want to http get from sql2000 table trigger. here is what i did: create procedure http_get( @sUrl varchar(200), @response varchar(8000) out) As Declare @obj int ,@hr int ,@status int ,@msg varchar(255) exec @hr = sp_OACreate 'MSXML2.ServerXMLHttp', @obj OUT ...more >>

I want to log in to a different account than what is set up in SQL Server Agent. I've tried many things like this but none work. exec xp_startmail 'audit','999999' The error I am getting is this. Server: Msg 18025, Level 16, State 1, Line 0 xp_startmail: failed with mail error 0x800401...more >>

Does the Query Analyzer have a visual query builder like Enterprise Manager? Jim james_peppercorn@storagetek.com...more >>

Although what I'm trying to do is more complicated than this, the following sums up the problem. I have a linked server which is an accountancy software package. This contains the tables INVOICE and INVOICE_ITEM. INVOICE consists of fields INVOICE_NUMBER, INVOICE_DATE, ACCOUNT_REFERENC...more >>

Using the query below, I want to update *every* record in Table1 with a corresponding value in Table2. If there is no corresponding record in Table2 I want Table1.Column2 set to NULL. Will this work? UPDATE Table1 SET Column2 = ( SELECT Column2 FROM Table2 WHERE Table2.Column1=Table1...more >>

We are currently using SQL server for some data analysis, and have tables containing > 100 million records. We need to run some update statements that alter the majority of these records, but the performance is being hit by the creation of vast transaction logs. Is there anyway of turning off...more >>

Hi, Can MS SQL server create random numbers (or characters) as default records? When a user create a username, I would like to have a randomized password automatically created. Please let me know if there is a way to do that. Cyont ...more >>

We have vldb, which has 10 tables that need to be purged on daily bases (1 million records per table). This process HAS TO BE partly overlapped with regular working hours and it should be implemented as a daily job... How can we do this and at the same time avoid locking as much as posible? User...more >>

Hi all. Can anyone point me to some example code or a precompiled extended stored procedure that I can use so that an SQL trigger can call a web page ? Thanks ...more >>

I'm trying to set up a page that reads parameters (3 of them) passed by a form: Example: http://www.aamprogram.org/resources/useful_links_search2.aspx?category=cat_art&audience=aud_students&level=lvl_elementary&Submit=Search The user makes their choice from three drop down menus (http://w...more >>

The following code finds an image from a record: sqlCmd.CommandText = "SELECT ImageID FROM TBL_Seller WHERE SellerID = '" & Session("SellerID") & "'" dreader = sqlCmd.ExecuteReader While dreader.Read() ImageID = dreader("ImageID") ImageID2 = String.C...more >>

I have a program that needs to look at (read only) whether a particular bit is set in a field in an sql database. I guess there is a way to do this but I can't find it amongst the 1000 pages of my manual! Any help gratefully received. Mark ...more >>

How can I send the result of SQL statement to a file using Query Analyzer? Thanks...more >>

Hi, In a DB I have set a field to 'money'. When returning all rows, the field shows up to 4 decimal places. How to limit it to 2 decimal places? The design table doesn't give me a choice. TIA, Jane ...more >>

Hi, How to create read only sp Dishan ...more >>

Hi.... I am creating the following function: CREATE FUNCTION date_return (@dateval datetime) RETURNS datetime AS BEGIN declare @newdate as datetime if (@dateval is null) set @newdate=getdate() else set @newdate=@dateval return @newdate END ...more >>

Greetings! I want to load data from Excel file to SQL Server. I can't use "Import/Export", so I added a linked server in SQL Server. One of the columns in Sheet1 (Excel File) is something like: 13 13 13D 13E .... But when I execute the following query in Query Analyzer: select *...more >>

All, I am having problems with a query. I've tried using outer join and intersection but with no avail. Any help would be appreciate it. Thanks. Joel. Sample Data Table A ID Amount 1000 500 1001 500 1002 500 1003 550 Table B ID C...more >>

Hi I have a customer who uses something like: .....OR CALCDUEDATE < GetDate() + 7..... in a sproc. I think I have read something about functions that doesn't return the same output using the same input (they have a name I cannot remember) and that they should be avoided in logic be...more >>

I am tryiing to create a simple formula that allows me to calculate bytes per row... using say Northwind.Employees as an example. Loeri...more >>

Does some one have a snippet that shows how to declare and define a table data type? Is it possible to use a table data type to aggregate the result sets returned by a stored proc and then select * from the table? Thanks!...more >>

the 'exception' when this command is ran: sqlstr = "BULK INSERT [Mink].[dbo].[TBL_Client_stage0]" + _ " FROM '\\nas01\r$\Program1.txt' WITH (CHECK_CONSTRAINTS, FIELDTERMINATOR = '\t', KEEPNULLS, MAXERRORS =100)" sqlInsertCommand2.CommandText = sqlstr sqlIns...more >>

Are there any advantages/disadvantages of adding an identity column in a junction table that resolves a many- to-many relationship? Thanks Alex...more >>

looking for anything but a cursor solution. temp tables, identity columns, OK. DDL: create table t1 (colA int, colB char(1)) DML: insert t1 values (1,'A') insert t1 values (1,'B') insert t1 values (1,'C') insert t1 values (2,'A') insert t1 values (2,'D') insert t1 values (3,'A') inse...more >>

We have a situation where the application programmer is saying that every time a particular stored procedure is used, it is recompiled, even if three people are using it at the same time. We are both assuming that it would be compiled once and kept in cache for a while. Any help apprec...more >>

Hi, Recently I was able to convert DBCS to unicode charset ( varchar to nvarchar) successfully. Now I am not able to convert Unicode charset to DBCS charset. Could somebody help me out with the code for the same?...more >>

I often need to join tables in my SQL Server DB with tables in a linked Oracle server. I use OPENQUERY to do this. The problem is that OPENQUERY don't support parameters, so I find it hard to add a WHERE clause--for a specific date for example. I need a where clause or else I'll pull hundreds of...more >>

Hi All I am attempting to run a SQL Statement to return the result from a table as comma delimited result. The SQL to demonstrate what I am trying to do is below: create table test1 (col1 INT, col2 datetime, col3 char(20), col4 varchar(20)) insert into test1 values(2, '1 Aug 2003', ...more >>

Hello There, I am currently working on a Trigger that is visibly correct however i can not seem to understand why i get an error message when i try and save a record <Maximum stored procedure nesting level exceeded (limit 32).> This is the syntax for the Trigger cre...more >>

When trying to run an OPENXML query on SQL Server 2000 SP31, with MDAC 2.8 we get the following error on one server, but not the other, which does not have sp3a installed: XML parsing error: System error: 265926. The stored procedure is below: CREATE PROCEDURE [dbo].[ModuleUp...more >>

Hi, i had created a trigger few days back on one of the tables. How do i find out the text associated with the trigger and to which table it is associated. I tried using enterprise manager,but it does not have triggers as one of the nodes in the tree view. One option is I use ms vi...more >>

it won't quite work. student exam grade 1 math 90 1 chem 89 1 phys 88 1 his 88 1 Geo 85 2 math 89 2 chem 84 2 phys 83 2 Geo 81 3 Lit 80 3 GYM 79 3 highest: 1 ma...more >>

How to find Last Modifed Date of a Stored Procedure in SQL Server?...more >>

Dear Freinds I have server A with database ABC and Server X with database XYZ I want to take the data from both ther server how i can do the same please suggest. Thanks for your guidence in advance. Best regards NiitMalad ...more >>

Does some form exist of passing a parameter for a trigger? ...more >>