HAVING clause is used in conjunction with the SELECT clause to specify a search condition for a group or aggregate. Usually Having clause is used to specify a search condition in a SQL statement which contains group by or some other aggregate condition. However WHERE clause is applied to individual rows and not to groups. […]
It is quite simple to calculate running in SQL Server using Sub Query.
Imagine you have a collection of objects you were trying to save to database. You could do save them one-by-one which can be expensive if the count is huge, (or) you could serialize them to a xml string and pass it to sp and have the SP parse it and save it to tables. (or) […]
We could use SP_RENAME system stored procedure to rename any user created data object such as column, table, index, data type in SQL Server. Syntax: Sample Data: I have created a simple table tblTest and added a unique index on column “NAME”. Example 1: Rename table tblTest to tblTest2 Example 2: Rename column […]