Viewing 15 posts - 241 through 255 (of 314 total)
Roger (9/24/2008)
Please can someone help.I am trying to write SQL that will create a table name with a date stamp (mmyy) derived from getdate().
Any suggestions?
Ta
Are you trying to create tables...
September 24, 2008 at 1:36 am
shobhitmishra (9/24/2008)
I want to use array in sql server 2000 but i don't know how tio impliment...
September 24, 2008 at 1:24 am
September 24, 2008 at 1:18 am
September 24, 2008 at 1:18 am
Try
Create proc pUpdateCust(@RecToUpdate AS INT)
As
BEGIN
declare @output table(customerid int)
UPDATE TOP(@RecToUpdate) CustomerTransact
SET STATUS = 'D'
OUTPUT INSERTED.customerid into...
September 24, 2008 at 1:14 am
Suresh B. (9/23/2008)
select o.name from sys.indexes iinner join sys.objects o
on o.object_id = i.object_id
where i.index_id = 0
Why do you think it is neccessary to join sys.indexes?
September 23, 2008 at 3:19 am
pri.amin (9/23/2008)
I want to swap data around from one column to another.
I have a table called 'PandL' and Im looking at the following data:
SELECT *
FROM PandL
WHERE Currency...
September 23, 2008 at 3:16 am
Scott Thornton (9/23/2008)
I need to return a row number in a query result set eg:
if there were three rows in the table with one column eg species( type )
1 cat
2...
September 23, 2008 at 12:59 am
Also refer http://sqlblogcasts.com/blogs/madhivanan/archive/2007/08/27/multipurpose-row-number-function.aspx
September 23, 2008 at 12:53 am
Jeff Moden (9/22/2008)
Madhivanan (9/22/2008)
My reply "Yes it is" is to your reply "Heh... not exactly true..."Actually I agreed with your reply 🙂
Heh... pretty bad misunderstanding on my part. Thanks,...
September 23, 2008 at 12:44 am
Vivien Xing (9/22/2008)
The script must exist somewhere, I believe. Anyone would like to share?Thank you in advance.
1 EXEC sp_tables
2 select * from sys.tables
3 select * from sysobjects where xtype='u'
4...
September 23, 2008 at 12:40 am
mpeters (9/23/2008)
[LOGDATETIMESTAMP] [datetime] NULL ,
which basically contains the date and time that the row was inserted
I want to return all of values...
September 23, 2008 at 12:35 am
This may be interesting to read
http://sqlblogcasts.com/blogs/madhivanan/archive/2008/09/05/fun-with-go.aspx
September 22, 2008 at 1:04 am
Kerrie Jones (9/22/2008)
That works like a bought one. Thankyou for the quick response.:D
You are welcome 🙂
September 22, 2008 at 12:59 am
Jeff Moden (9/20/2008)
Madhivanan (9/19/2008)
Jeff Moden (9/18/2008)
Ninja's_RGR'us (9/18/2008)
Yes you need to create it first, including column definitions.
Heh... not exactly true...
SELECT *
INTO #MyHead
FROM OPENROWSET('SQLOLEDB','Server=(local);Trusted_Connection=Yes;Database=Master',...
September 22, 2008 at 12:42 am
Viewing 15 posts - 241 through 255 (of 314 total)