When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?
What are the OS services that the SQL Server installation adds?
What is the difference between UNIQUE and DISTINCT keywords in DBMS?
Can a table be created inside a trigger?
Does hive support indexing?
How to find the date and time of last updated table?
After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )
3 Answers CarrizalSoft Technologies, iGate,
What is RAID and what are different types of RAID configurations?
Is foreign key a primary key?
What is the difference between substr and charindex in the sql server?
WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,...
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?