 Related Questions Latest Answer : Data objects are basic runtime entities. ... Latest Answer : Just replace "[your-schema-name-here]" in the following query with your schema name. Hope it comes handy to some of you out there. Select OBJECT_TYPE,OBJECT_NAME FROM(Select 'TABLE' as OBJECT_TYPE, TABLE_NAME as OBJECT_NAME, TABLE_SCHEMA ... Latest Answer : We can copy the Table structure also from one table to another tableExample: CREATE table emp1 as ... Read Answers (3) | Asked by : penchal Latest Answer : select * into new table name from old table name where 1=0 ... Read Answers (2) | Asked by : mvkrishna It's working in MySQL but not in SQL-Server. Latest Answer : Use a procedure which will delete record from child table first and then it will delete the same record from parent tableSame thing can be achieved using cascade delete and cascade update, this feature was not there in sql server 7.0 ... Read Answers (3) | Asked by : kathir How to display list of tables from a particular database in MS-SQLHow to display description of that particular table? Latest Answer : To Display list of tables in the database:SELECT * FROM INFROMATION_SCHEMA.TABLES WHERE TYPE='basetable'To describe the structure of a particular tableSP_HELP table_name; ... How to deny insert, update, delete, update permissions for a specific user of a specific user database? Latest Answer : So what context is the user in? A role a datareader? Datawriter?You want no permissions?USE Drop USER In a role?EXEC sp_droprolemember 'rolename' , 'Member'single objects?Revoke SELECT, ... How to join same fields of four tables at SQL Server? Latest Answer : There are 5 types of join in sqlservercross joininner joinleft outer joinright outer joinfull outer joincross joinselect * from table1cross join table2cross join table3cross join table4inner joinselect * from table1 inner join table2on table1 .c1=table2.c1 ... How to transfer data from a text file to SQL table, Which is the best method to do that? Latest Answer : By using OPENROWSET commandExample: INSERT INTO dbo.ImportTestSELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:ImportData.xls', ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 
1