I have this cursor, it is fired when new records are inserted into a table through a stored procedure (multiple records at the same time).
The trigger is fired and I receive notification ema...
I have an SP that uses a cursor to transpose records into one line. We're trying to avoid using cursors, but it's all I could come up with at the time. Is it possible to transpose data using...
What is the easiest way to strip out the time in a sql server db datetime field?
Front end is ASP.Net/VB.Net...would prefer to do it in SQL Server?
I am looking for code to return yesterday and today regardless of time of time code runs, in other words, if getdate when I execute returns 6/27/05 11:09 am, I want to be able to return 6/26...
if sp returns resultset with variable column count, how can i insert it into #temp?
for each name, there is a column in recordset from myproc.
----
create table #temp ( id int, val varchar...
Hi,
I am facing an error while using openxml in sql server 2000. I am getting a xml string as a text parameter of stored procedure.
The xml string that I am getting in paramter is:
<Order...
Hi all,
got a problem with returning scopeidentity of type uniqueidentifier
-- tableScript
-- Creating a table using NEWID for uniqueidentifier data type.
CREATE TABLE cust
(
c...
Hi,
I want to know is there any command in T-SQL have the same function like VB5;
Do until resultset.EOF
.......
resultset.movenext
Loop
I have declare a cursor for a ...
in Access, you can use the following sql statement to format a number:
format(number,"0000") as result
An example of result could be 0023, rather than 23
WHen doing in SQL Server, I am advi...
Hi Guys,
Consider the follwoing scenario:
SELECT 'I am renjith'+'I am from India'
Result will be: I am renjithI am from India
SELECT 'I am renjith
I am from India'
Result will be: I ...
Hi guys 'n gals,
Is there a way I can convert this:
SELECT * INTO tblName FROM qryName
into something that drops the returned values of a Stored Procedure into a table?
EG:
SELE...
When I check in Activity Monitor of SQL Server 2005 I also see few connections in sleeping status. I understand if C#.NET application is using Pooling, for performance reason SQL Server does n...
How do you write a FOR EACH loop in t-sql?
-ws
Hi,
I got this error on my server,
windows 2000 server, sp4
1,5 Gb Ram
P2.0 xeon
SQL2000 server with sp3
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][O...
Using Group Policy, I have assigned a shutdown script to domain computers, that will let me know when computers are off or on, and if they need Windows Updates, so I can use WoL to power up th...
Window Server 2003 Service Pack 4
SQL 2005 Service Pack 2
I can create foreign key through sql code like
alter table table_name
add constraint constraint_name
foreign key (column_name)
...
Hi,
When we run sp_who2, there will be status column available and results with few status..Can someone explian means of suspended status?
I run the dbcc opentran and found the insert sta...
How's the best way to deal with a multi-row insert which minimises overhead?
I have a table that would need to be updated with 100's of rows at any one time. I want to restrict the user to ...
I need command or script to convert rows into columns or vice-versa in MS SQL 2000. Any one has ideas or commands?
Hi,
Is there a better way of writting this stored proc?
CREATE FUNCTION fn_getDayofWeek(@dayNbr Int)
RETURNS varchar(5)
AS
BEGIN
DECLARE @dayStr varchar(3)
If @dayNb...
Hi experts
I got the following error when I tested emailing to the operator in Sql Server Agent.
"Error 22022 : SQLServerAgent Error. The SQLServerAgent mail session is
not running; che...
hello guys, I'm desperately need your help immediately.
i have issued a statement on my sql query analyzer that change all other record on a table. how do i undo this statement?
e.g.
...
hi all
i restored a database called db1
owner of the tables in this database is "owner1" but in my sqlserver "owner1" doesn't
exist.=20 so i create a user "owner1"
when i check the b...
Hello Experts
I am new in Sql triggers and i would like some help
I have a Table called SITE and another callded SITELANG
[SITE]
Siteid,Title,Active
[SiteLang]
LangID,SiteID,Titlle
...
Hi there,
can anyone help, I am receiving an error in my Windows 2003 Eventlog.. it refers to a copy of SQL Server Express 2005 i have installed on Windows 2003 server.
This is the event...
