Programming SQL
in [Microsoft SQL Server]
|
ado c++ ado strcpy(sqlbuf, "select a, b, c, (case when (y=2) then d else null end) as d pRS->Open(sqlbuf,vtMissing, AdoNS::adOpenKeyset, AdoNS::adLockBatchOptimistic, -1); while(pRS->adoEOF == false) { //how do i read the values a, b, c and d?. //When i try to read the value d , i get the mismatch error. ... 1 May 2010 12:04
sp_send_dbmail with @query from tampdb On Fri, 30 Apr 2010 13:31:01 -0700, jam772 <jam772(a)discussions.microsoft.com> wrote: I simply issued a create statement and specified to store the table in tempdb. After reading the info under the link you sent this may not have been the best idea. I changed my code to use the # nomenclature for temp ta... 6 May 2010 18:45
US-MD-Silver Spring: SQL VMWare TV Network DBA <http://www.filcro.com/SQL-Database.html> � Installing, configuring, troubleshooting and maintaining MS SQL environments � Experience working with VMWare (ESX 4.0 preferred) � Strong SQL / scripting skills � This position is approximately 75% Database Administration and 25% Systems � Strong Active Directory an... 30 Apr 2010 21:53
Ending a stored proc I am trying to end a stored procedure and return a value of -1 to tell the application that a check number already exists. Below is the code in my sp where I am checking but it goes right past it and continues as though the result is false. When I run this as a separate query it returns the -1 fine. Can anyon... 3 May 2010 10:57
I assume Row_Number doesn’t act only onrows of the window frame trubar a (asponmynet(a)gmail.com) writes: a) "for each row, there is a set of rows within its partition called its window frame. Many (but not all) window functions act only on the rows of the window frame, rather than of the whole partition. By default, if ORDER BY is supplied then the frame consists of a... 1 May 2010 18:43
I assume Row_Number doesn’t act only on rows of the window frame Quotes are taken from http://www.postgresql.org/docs/current/static/tutorial-window.html a) "for each row, there is a set of rows within its partition called its window frame. Many (but not all) window functions act only on the rows of the window frame, rather than of the whole partition. By default, if ORDER BY... 3 May 2010 15:23
query plan for stored procedure Hi, Is that way to get query plan for a stored procedure in stead of single statement in sql server 2008? Thanks. ... 30 Apr 2010 18:34
seeking set based solution Trying to assign registrations to colonies up to the colony maximum. Original code was a cursor, but its slow and kludgy. The problem is that the colony might already have registrations so I need to check for not exceeding the maximum registrations (numbers table maybe?). Each registration can only be in 1 colony.... 3 May 2010 13:10
<resource-list> Deadlock graph interpretation in the text of the deadlock graph i have this: <resource-list> <pagelock fileid="1" pageid="41452" dbid="30" objectname="RM_PA_Septa_74346.dbo.tblRunActual" id="lock38c95d00" mode="IX" associatedObjectId="72057601943470080"> <owner-list> <owner id="process8db978" mode="IX"/> <owner id="... 30 Apr 2010 10:36
DateTime conversion from Korean Greetings! I need to convert a number of time values that look like "1/6/2010 ¿ÀÈÄ 10:28:51" and "1/7/2010 ¿ÀÀü 7:45:00" to DateTime values. Needless to say, it's not working. I'm pretty sure that the reason is that the "¿ÀÈÄ" and "¿ÀÀü" are the Korean equivilents of "AM" and "PM". Can anyone tell me which i... 2 May 2010 04:28 |