How can delete duplicate records in cte in sql server?
What are various aggregate functions that are available?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
Which command using Query Analyzer will give you the version of SQL server and operating system?
What are differences in between sql server 2012 and sql server 2016?
What do you understand by recursive stored procedure?
Do you know what are the restrictions that views have to follow?
A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
Why do we use stored procedures in sql server?
What is the stored procedure?
Does order by actually change the order of the data in the tables or does it just change the output?
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,