Database

greekius@hotmail.com wrote:

;User ID=SA;

<br />
update alarm_log set timestamp = dateadd(d,430,timestamp) <br />

DECLARE @cSQL varchar(100)
DECLARE @cTableName varchar(100)

SELECT @cSQL = ''

DECLARE  TableNames CURSOR FOR 
SELECT DISTINCT table_name 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE column_name = 'timestamp'

OPEN TableNames
FETCH NEXT FROM TableNames INTO @cTableName 
WHILE @@FETCH_STATUS = 0
BEGIN
	EXEC('UPDATE ' + @cTableName + ' SET timestamp = DATEADD(d,430,timestamp)')

	FETCH NEXT FROM TableNames INTO @cTableName 
END

CLOSE TableNames
DEALLOCATE TableNames 

kozu wrote:

How can I print the names and the number of times they show up?

SELECT Name, COUNT(*) AS Counter
FROM MyTable
GROUP BY Name

kozu wrote:

second question, how can i print the following?

CREATE FUNCTION GetData (@cName varchar(100))  
RETURNS varchar(100) AS  
BEGIN 

DECLARE @nData int
DECLARE @cDataHold varchar(100)
SELECT @cDataHold = ''

DECLARE  DataCursor CURSOR FOR 
SELECT Data 
FROM TestTable
WHERE Name = @cName

OPEN DataCursor
FETCH NEXT FROM DataCursor INTO @nData 
WHILE @@FETCH_STATUS = 0
BEGIN
	select @cDataHold = @cDataHold + case when len(@cDataHold) > 0 then ', ' else '' end + CAST(@nData as varchar(100))
	FETCH NEXT FROM DataCursor INTO @nData 
END

CLOSE DataCursor
DEALLOCATE DataCursor
RETURN(@cDataHold)
END

select name, dbo.getdata(name) as Data from (select distinct name from TestTable) as tbl

TheJudeDude wrote:

I have tried SELECT * From Table Where x = NULL...that doesn't work.

SELECT * FROM Table WHERE x IS NULL

Jethro63 wrote:

But what if the table does not yet exist? What if the purpose of the procedure in question is to check for existence of a certain table and create it if its not there?

IF EXISTS (SELECT * FROM INFORMATION_SCHEME.TABLES WHERE TABLE_NAME = 'MyTableName')
BEGIN
    -- Do stuff based on the existance of the table
END
ELSE
BEGIN
    -- Do stuff based on the nonexistance of the table
END

Jethro63 wrote:

First of all, it is not clear to me if I can indeed execute a "CREATE TABLE" SQL statement using SqlCommand. Can I?

Jethro63 wrote:

Which method should I use? "ExecuteNonQuery", "ExecuteScalar"?

Jethro63 wrote:

So, at this point, I don't know if it is simply, my SQL syntax, or I am miss-using SqlCommand object, or if I simply cannot do this with an SqlCommand object.