Create table

Can I create table doing a copy of another one who already exist?
thank youYou can use
SELECT * INTO NEWTABLE FROM OLDTABLE
"Alberto" <alberto@.nospam.com> wrote in message
news:%23BBFMmMtDHA.2360@.TK2MSFTNGP10.phx.gbl...
> Can I create table doing a copy of another one who already exist?
> thank you
>|||I don't mean insert data. I want create the new table like the old table.
Thank you.
"»Æɽ¹âÃ÷¶¥" <leimin@.fujitsu.sh.cn> escribió en el mensaje
news:OK08etMtDHA.3144@.tk2msftngp13.phx.gbl...
> You can use
> SELECT * INTO NEWTABLE FROM OLDTABLE
>
> "Alberto" <alberto@.nospam.com> wrote in message
> news:%23BBFMmMtDHA.2360@.TK2MSFTNGP10.phx.gbl...
> > Can I create table doing a copy of another one who already exist?
> >
> > thank you
> >
> >
>|||1.YOU CAN TRY:
select * into new table from oldtable where 0=1
2.you try open MSSQLSERVER ENTERPRISE MANAGERMENT
select the oletable mouse right key--generate script--save the
script.then you can run the script in Query Analyzer to create new
table.(just change the table name)
"Alberto" <alberto@.nospam.com> wrote in message
news:%23BBFMmMtDHA.2360@.TK2MSFTNGP10.phx.gbl...
> Can I create table doing a copy of another one who already exist?
> thank you
>|||Actually I'm doing it as you say in the point 2 but in others DBMS like
Informix you can do something like "Create newTable like oldTable".
Thank you.
"»Æɽ¹âÃ÷¶¥" <leimin@.fujitsu.sh.cn> escribió en el mensaje
news:uJtW9BNtDHA.3536@.tk2msftngp13.phx.gbl...
> 1.YOU CAN TRY:
> select * into new table from oldtable where 0=1
> 2.you try open MSSQLSERVER ENTERPRISE MANAGERMENT
> select the oletable mouse right key--generate script--save the
> script.then you can run the script in Query Analyzer to create new
> table.(just change the table name)
>
> "Alberto" <alberto@.nospam.com> wrote in message
> news:%23BBFMmMtDHA.2360@.TK2MSFTNGP10.phx.gbl...
> > Can I create table doing a copy of another one who already exist?
> >
> > thank you
> >
> >
>|||Closest to that is SELECT INTO. It will not copy over constraint, indexes etc, though.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Alberto" <alberto@.nospam.com> wrote in message news:ea38LFNtDHA.2088@.TK2MSFTNGP09.phx.gbl...
> Actually I'm doing it as you say in the point 2 but in others DBMS like
> Informix you can do something like "Create newTable like oldTable".
> Thank you.
> "»Æɽ¹âÃ÷¶¥" <leimin@.fujitsu.sh.cn> escribió en el mensaje
> news:uJtW9BNtDHA.3536@.tk2msftngp13.phx.gbl...
> > 1.YOU CAN TRY:
> > select * into new table from oldtable where 0=1
> >
> > 2.you try open MSSQLSERVER ENTERPRISE MANAGERMENT
> > select the oletable mouse right key--generate script--save the
> > script.then you can run the script in Query Analyzer to create new
> > table.(just change the table name)
> >
> >
> >
> > "Alberto" <alberto@.nospam.com> wrote in message
> > news:%23BBFMmMtDHA.2360@.TK2MSFTNGP10.phx.gbl...
> > > Can I create table doing a copy of another one who already exist?
> > >
> > > thank you
> > >
> > >
> >
> >
>

Create or update with updategram

Without knowing whether a row already exists in a table, is it possible to
construct an updategram that would create the row it does not exist or
update it if it does?No.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Xerox" <info@.thinkscape.com> wrote in message
news:O1aI5TWIFHA.580@.TK2MSFTNGP15.phx.gbl...
> Without knowing whether a row already exists in a table, is it possible to
> construct an updategram that would create the row it does not exist or
> update it if it does?
>

Create or update with updategram

Without knowing whether a row already exists in a table, is it possible to
construct an updategram that would create the row it does not exist or
update it if it does?
No.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Xerox" <info@.thinkscape.com> wrote in message
news:O1aI5TWIFHA.580@.TK2MSFTNGP15.phx.gbl...
> Without knowing whether a row already exists in a table, is it possible to
> construct an updategram that would create the row it does not exist or
> update it if it does?
>

Create file if does not exist but use if it does

I have the following SQL code. How can I put a check in here to see
if the file already exists and create it if not but insert the data
into it if it does? Thanks for your help
--[ Declare Variables ]--
DECLARE @.ThisWeek as smallDatetime
DECLARE @.ThisQtr as Integer
DECLARE @.ThisYear as Integer
DECLARE @.ThisYrQtr as Varchar(4)
DECLARE @.CmdStr as Varchar(1000)
--[ Populate the Variable with Month/Quarter/Year info ]--
Select @.ThisWeek = Mondate, @.ThisQtr = Qtr, @.ThisYear = [Year],
@.ThisYrQtr = Cast( (SubString( Cast([Year] as Char(4)), 3, 2) +
'Q' + Cast([Qtr] as Char(1)) ) AS varChar(4))
>From dbHistory.dbo.tbQtrNdx
Where Mondate = fn_Mondate(GetDate())
--[ Build the SQL script to execute ZZZ123 archive ]--
Select @.CmdStr = Select * Into dbHistory.dbo.tbZZZ123_' + @.ThisYrQtr +
' ' +
'From dbHostdata.dbo.tbZZZ123 ' +
'Where Mondate = ''' + master.dbo.fn_formatDate(@.ThisWeek, 'mm/dd/
yy') + ''''
Exec (@.CmdStr)
--[ Build the SQL script to execute Bills archive ]--
Select @.CmdStr = 'Select * Into dbHistory.dbo.tbBills_' + @.ThisYrQtr +
' ' +
'From dbMetrics.dbo.tbBills ' +
'Where Mondate = ''' + master.dbo.fn_formatDate(@.ThisWeek, 'mm/dd/
yy') + ''''
Exec (@.CmdStr)Why not use
if EXISTS (SELECT ...)
BEGIN
-- Update record
END
ELSE
BEGIN
-- create new record
END
-- End Else
taxidermist@.cableone.net wrote:
> I have the following SQL code. How can I put a check in here to see
> if the file already exists and create it if not but insert the data
> into it if it does? Thanks for your help
> --[ Declare Variables ]--
> DECLARE @.ThisWeek as smallDatetime
> DECLARE @.ThisQtr as Integer
> DECLARE @.ThisYear as Integer
> DECLARE @.ThisYrQtr as Varchar(4)
> DECLARE @.CmdStr as Varchar(1000)
>
> --[ Populate the Variable with Month/Quarter/Year info ]--
> Select @.ThisWeek = Mondate, @.ThisQtr = Qtr, @.ThisYear = [Year],
> @.ThisYrQtr = Cast( (SubString( Cast([Year] as Char(4)), 3, 2) +
> 'Q' + Cast([Qtr] as Char(1)) ) AS varChar(4))
>>From dbHistory.dbo.tbQtrNdx
> Where Mondate = fn_Mondate(GetDate())
>
> --[ Build the SQL script to execute ZZZ123 archive ]--
> Select @.CmdStr = Select * Into dbHistory.dbo.tbZZZ123_' + @.ThisYrQtr +
> ' ' +
> 'From dbHostdata.dbo.tbZZZ123 ' +
> 'Where Mondate = ''' + master.dbo.fn_formatDate(@.ThisWeek, 'mm/dd/
> yy') + ''''
> Exec (@.CmdStr)
>
> --[ Build the SQL script to execute Bills archive ]--
> Select @.CmdStr = 'Select * Into dbHistory.dbo.tbBills_' + @.ThisYrQtr +
> ' ' +
> 'From dbMetrics.dbo.tbBills ' +
> 'Where Mondate = ''' + master.dbo.fn_formatDate(@.ThisWeek, 'mm/dd/
> yy') + ''''
> Exec (@.CmdStr)
>