잡동사니

USE AdventureWorks2008; ------------ -- SQL Server 2008 string to datetime conversion script generator ------------ -- SQL string to datetime - t-sql varchar to datetime - sql convert -- Generated results - generator script follows SELECT convert(datetime, 'Jul 16 2015 3:03AM', 0) SELECT convert(datetime, '07/16/15', 1) SELECT convert(datetime, '15.07.16', 2) SELECT convert(datetime, '16/07/15'..

-- SQL Server string to date / datetime conversion - datetime string format sql server -- MSSQL string to datetime conversion - convert char to date - convert varchar to date -- Subtract 100 from style number (format) for yy instead yyyy (or ccyy with century) SELECT convert(datetime, 'Oct 23 2012 11:01AM', 100) -- mon dd yyyy hh:mmAM (or PM) SELECT convert(datetime, 'Oct 23 2012 11:01AM') -- 2..

ms - sql 1) 칼럼명 변경 Exec sp_rename 'tablename.column name', @newname='column name' or Exec sp_rename 'tablename.column name', 'column name' Exec sp_rename 'Page_Table.StartTime', @newname='ST' Oracle) ALTER TABLE table_nameRENAME COLUMN old_name to new_name; 2)칼럼 삭제 Alter Table TableName DROP COLUMN ColumnName 3) 칼럼 추가 ALTER TABLE {tableName} ADD {columnName} {Type} {nu..

1.SELECT table_name=sysobjects.name, column_name=syscolumns.name, datatype=systypes.name, length=syscolumns.length FROM sysobjects JOIN syscolumns ON sysobjects.id = syscolumns.id JOIN systypes ON syscolumns.xtype=systypes.xtype WHERE sysobjects.xtype='U' ORDER BY sysobjects.name,syscolumns.colid 2. SELECT * FROM INFORMATION_SCHEMA.Columns where TABLE_NAME = 'Foo' 3. SELECT count(*) FROM <tab..

SET ANSI_WARNINGS ON -- DEFAULT OPTION 임 IF OBJECT_ID('TBLX') IS NOT NULL /// 'TBLX'란 테이블이 존재하면 삭제 할것 DROP TABLE TBLX GO CREATE TABLE TBLX /// TBLX 테이블 만들기 (A VARCHAR(5) /// A칼럼 Varchar(5), B칼럼 Varchar(5) ,B VARCHAR(5)) INSERT INTO TBLX VALUES ('AAAAA','BBBBB') /// 인서트. ALTER TABLE TBLX /// TBLX 테이블에서 ALTER COLUMN A CHAR(4) /// A..