Tech-Today
Long time ago I was executing the command that I'm so used to in mysql which is:
desc tablename
This command will give you the rows, its datatype, length, description etc.
I've tried executing this in MSSQL and it's not working tried: describe, desc but failed. I also tried manually selecting the columns from information_schema.columns but it's too ugly. Luckily digging to the documentation I found the stored procedure:
sp_columns which has the same functionality as desc.
Usage:
- Database
MSSQLMSSQL equivalent of DESC in MYSQLPostgresqlChange postgresql's postgres passwordHow to install hstore in postgresql 9.1JDBC provider setting in java for postgresql, mysql and oracleHow to alter the sequence value in postgresqlOracleHow to change...
- How To Alter Bit And Date Column's Default Value In Mssql
Aside from using the SQL Designer, you can alter a bit and date column's default value. ALTER TABLE TableName ADD CONSTRAINT TableName_Disabled DEFAULT 0 FOR Disabled ALTER TABLE TableName ADD CONSTRAINT TableName_DateCreated DEFAULT getdate() FOR...
- Moving Data From A Table In One Database Into Another With The Same Table Definition
Objective: Given the same schema of database for example an active and archive, how should we move rows of data from one table in one database into the same table name in another database. Below is a java code snippet/pseudocode that I've created:...
- Operation Must Use An Updateable Query
I am currently developing a certain application in MS Access and I need to link 2 databases, select data from one and move it to the second. In access I have no problem using the TransferDatabase command. DoCmd.TransferDatabase acLink, "Microsoft Access",...
- Staxmem.dll Not Found...
Recently, I've encountered this error during IIS installation and don't know what to do or where to start. The error said it can't find the file though I can see it in the CD, I thought it was corrupted to I tried copying the i386 directory...
Tech-Today
MSSQL equivalent of DESC in MYSQL
Long time ago I was executing the command that I'm so used to in mysql which is:
desc tablename
This command will give you the rows, its datatype, length, description etc.
I've tried executing this in MSSQL and it's not working tried: describe, desc but failed. I also tried manually selecting the columns from information_schema.columns but it's too ugly. Luckily digging to the documentation I found the stored procedure:
sp_columns which has the same functionality as desc.
Usage:
sp_columns tablename
- Database
MSSQLMSSQL equivalent of DESC in MYSQLPostgresqlChange postgresql's postgres passwordHow to install hstore in postgresql 9.1JDBC provider setting in java for postgresql, mysql and oracleHow to alter the sequence value in postgresqlOracleHow to change...
- How To Alter Bit And Date Column's Default Value In Mssql
Aside from using the SQL Designer, you can alter a bit and date column's default value. ALTER TABLE TableName ADD CONSTRAINT TableName_Disabled DEFAULT 0 FOR Disabled ALTER TABLE TableName ADD CONSTRAINT TableName_DateCreated DEFAULT getdate() FOR...
- Moving Data From A Table In One Database Into Another With The Same Table Definition
Objective: Given the same schema of database for example an active and archive, how should we move rows of data from one table in one database into the same table name in another database. Below is a java code snippet/pseudocode that I've created:...
- Operation Must Use An Updateable Query
I am currently developing a certain application in MS Access and I need to link 2 databases, select data from one and move it to the second. In access I have no problem using the TransferDatabase command. DoCmd.TransferDatabase acLink, "Microsoft Access",...
- Staxmem.dll Not Found...
Recently, I've encountered this error during IIS installation and don't know what to do or where to start. The error said it can't find the file though I can see it in the CD, I thought it was corrupted to I tried copying the i386 directory...