Hai, Im suresh, how do i insert a string with single quotation into a field in sqlserver via stored procedure. eg. ' ' im using frontend as vb. ...more >>

I created the procedure below in a SQLServer 2000 environment to export a SQL query to a log file. The procedure exports all of the records correctly but the procedure is executing 'someproc' twice. Any help will be much appreciated. Thanks, Mark CREATE PROCEDURE sp_queryToFile @...more >>

Hi, I have to make a query like that the row number should be there in everyrow in the resultset. we have to use only the "select" query without using any updates. Can any one help me. Regards, Ramnadh....more >>

Hi, I use cursors in one SP an it's my first time. I use the SP for checking logging. I have tbale Users ------------- id username userpass userrole 1 kalo lako admin 2 kiko koki user ............. The Sp looks like that: CREA...more >>

What is 'parameter sniffing' ?...more >>

When I execute: declare @sql nvarchar(200) set @sql = N'create table #tmp_table(guarid int)' exec sp_executesql @sql select * from #tmp_table I get: "Invalid object name '#tmp_table'." and there is no entry in tempdb However; if I change the temp table to a global table (##tmp_table) i...more >>

Are there any loan amortizer programs written in TSQL or c#. we need it desperately. TIA ...more >>

If I include just the scripts to create the tables and the stored procedures in my app distribution, will that be enough to recreate a database structure enough to get the user up and running? It should go without saying that I'm going to include the MSDE install, but just in case ... ...more >>

Join members of the Microsoft development team as they chat about what's new in SQL Server 2005 Beta 2. One major new feature that's been announced in Beta 2 is data encryption. Come chat about other new features and changes that exist in this highly anticipated beta of the next version of SQL S...more >>

how to find out if any of procedures contain optional parameter? logic is , if there is a "=" sign before first "AS", then I think there will be at least one optional parameter. WELL, this query will not solved my problem. is there a way? SELECT ROUTINE_NAME FROM INFORMATION_SCH...more >>

I know how to get around this but I was wondering when you use the gui to attach a database you have an option for database owner but when you use the sp_attach_db datatbase owner is not an option I was wondering why? thanks...more >>

Hello I want to know how I can get the id of the deleted row in a table inside a trigger ? simo ...more >>

I have a field in my databas that has a charactertype of Float. This field is stroing time values from my helpdesk app. If I change the chartype to datetime will I have time values without deleting any existing data....more >>

I developed this stored procedure which enable user to enter a table name, column name and column value and return all null or empty columns ( top 1 ). Is there a function I can use to check the column data type? What I need is to be able to convert any date column to 101 (ie. convert(va...more >>

Hi I have created an SQL trigger to round numbers on a table. As the table updated can have more than one row, I have had to create a cursor to cycle through it. It seems that I can only cycle through the table after having processed the first instance. Is this correct? Thanks Tim Cowan Co...more >>

Thanks in advance to anyone whom can help :) I have a stored procedure that has parameter of type VARCHAR. I have confirmed that it in fact passes my desired value '1950-01-01' (including the single quotes) I'm trying to convert this value to one of type SMALLDATETIME. I did the following: SP p...more >>

I suppose any mssql database has a unique identity which one can obtain from one of the system tables, but I don't know where to look. Can anybody help me out? Regards, Richard ...more >>

I need to add extra column in my table named 'description' and it is combined of two existing columns I know my syntax is wrong but don't know to correct it... Update mytable set description = custaccount & "-" & custname btw, I am newbie in SQL server, any tutorial web site can provide suc...more >>

is it true when you specify FAST HINT for a query, it's usually faster than the original query without FAST Hint? ...more >>

I put this one in the clustering news group section as well but no one responded. Can someone from this section be help?? Thanks in advance - Nitin ======================================================== I am planning about either setting up Cluseting on SQL Server or follow log shipping...more >>

create function SamFunc(@units int) returns @tb table( CustomerID char(5) not null primary key ,SalesInfo money not null ) as begin insert into @tb select o.customerid,od.quantity * od.unitprice from orders o inner join [order details] od on...more >>

i create the stored procedure as following :- However, I don't know how to test it in sql analyzer declare @resultid int exec dbo.sea_keyid @keytype ='EXHBL' input , @resultid =@resultid output The above code seems wrong.. Please help ~~ ------------------------------------- CREATE PROCEDURE ...more >>

Hi all, I am returning multiple Tables from one Stored Procedure into a .Net DataSet. I specify the Tablename for each SELECT statement at "FROM employees AS Employees" but the alias is not returned in the DataSet. From the DataSet I get names such as Table1, Table2 etc. Hope someone can ...more >>

Hello people! :O) i've got two related questions 1. Is there a way to get the targeted table to be created automatically as in a select into query ? because for now, i need to create the table manually before the call, it's not as usefull as i wish <g> : --- create procedure dbo.p as ...more >>

hi, a long time ago i have to create this : create table temp ( .... description_long varchar(4000) ... ) now i have to change type to TEXT (>8000 characters) but i already have 2000 records inserted. if i change the type? i would lose the data? ...more >>

Hi All, I'm programming databases since some years. I use lowercase to name the columns (iduser, idbasket, zipcode...). I think it's more compatible to be exported to other databases and more or to work with any languaje.. But I'm not sure about it, I don't really know how necessary is. C...more >>

Hello everyone, I am not sure if this is the right place to post this question but here it is. In Access 2000 I use to concatenate 2 numeric fields to update with the result a 6 character text field using the following function: Format([YearId] & Format(Right[IssueId],2),"00"),"000000")...more >>

I have the following query: SELECT dbo.tSymExch.exCode, dbo.tSymGrp.sgCode, dbo.tSymMain.smCode FROM dbo.tSymExch FULL OUTER JOIN dbo.tSymGrp ON dbo.tSymExch.exID = dbo.tSymGrp.sgexID FULL OUTER JOIN dbo.tSymMain ON dbo.tSymGrp.sgID = db...more >>

I am curious if people use Enterprise Manager to manager their SQL Server or do they use third party tools. What are some of the good tools that are in the market that can be used to administer SQL Server, May be job scheduling, setting up alerts w/o installing Outlook on the SQL machine, ...more >>

Hi all, I've created a stored procedure that makes output into a temporary table. Here is a simplified version of it (the actual table has many more rows and columns): use Import go create proc dbo.sp1 as create table #t (i int) insert #t values (3) select * from #t go I'm trying t...more >>

Is it possible to pass a recordset to a stored procedure and that stored procedure will enter the data into a table? Ra an an . ...more >>

Hi, Is it possible to connect to AS400 from SQL Server 2000 via a Trigger. OLE DB Connection only. Thanks Vijay I will persist till I win....more >>

Hi All, I have downloaded a table from a different server. I have a date field defined as varchar. There are some data which looks like the following: 07/21/2004 (mm/dd/yyyy) format some are 2003-09-12 (yyyy-mm-dd format). I want all dates to be in yyyy-mm-dd format. How can I update...more >>

DTS Environment Control =20 What solutions have other worked up to handle DTS packages and = promotions through their different environments? =20 In our scenario we have a 4 tier environment (Dev/Test/PreProd/Prod). = The challenge is when you promote your packages up; the connections...more >>

Hi, I need to use RESTORE HEADERONLY for a lot of transaction log.Is there somebody who knows, how to keep the "result set" of RESTORE HEADERONLY, in a table? Many thanks....more >>

Hi, I'd like to access to a sage data base with a sql server stored procedure, anybody knows how to do this ? Thanx....more >>

I have a form which stores 5 email address per client. Can I make the user will not enter data in the 2nd, 3rd, 4th or 5th email address without first entering data in the 1st email address field?...more >>

Is there any way to transfer procedures from central server(master server) to multiple servers (target server)? We can use osql, but that needs the sql to be copied to all servers which may not possible with 'multi server jobs'. Any ideas please share. Thanks...more >>

Hello, I have a table containing select statements in each of it's columns. Inside a stored procedure I want to set the value of the column i.e the statement into a variable and then execute it using the command EXEC sp_executesql @QUERY If I print the value of the variable containing...more >>

When I insert japanese data into SQL Server2000 using ASP, certain Kanjis which are rarely used get stored as unicode.. For eg. a certain kanji gets stored as &#31055; But display of this kanji on IE is fine as I use SHIF_JIS encoding...But the problem is while retrieving this data on Cr...more >>