can you instantiate a com object by using t-sql? : Sql server database administration
Answer / Indresh Kumar
No, T-SQL (Transact-SQL) is the query language for Microsoft SQL Server and it does not support creating COM objects. To interact with other components or automation, use stored procedures or CLR Integration.
| Is This Answer Correct ? | 0 Yes | 0 No |
sql database suspect We have a sql database that is showing as suspect. How can we recover?
What are pessimistic lock and optimistic lock?
what is the disadvantage of SQL Loder?
Do you know what are the restrictions that views have to follow?
How to convert binary strings into integers in ms sql server?
What are the steps need to be take improve the speed of a SQLDATA Server?
What are various aggregate functions that are available?
Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name
How sql server enhances scalability of the database system?
What is xml datatype?
How to view existing indexes on an given table using sys.indexes?
Explain mixed authentication mode of sql server?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)