Showing posts with label Sqlserver. Show all posts
Showing posts with label Sqlserver. Show all posts
Monday, June 20, 2016

Easily Improve Any SQL Server Audit with IDERA

›
Audit Sensitive Data - see who did what, when, where, and how Track and Detect - monitor and alert on suspicious act...
Thursday, April 17, 2008

Paging In Sqlserver 2005

›
SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY person) AS rownum, person, income FROM Salaries) AS Salaries1 WHERE rownum >= ...
Thursday, April 10, 2008

Cross Joins Using sqlserver

›
Using Cross Joins A cross join that does not have a WHERE clause produces the Cartesian product of the tables involved in the join. The size...
Monday, April 7, 2008

Importan queries using Sqlserver

›
http://www.dotnetspider.com/kb/Article4097.aspx

Check if a date is a valid date in Sql Server 2005

›
Use the ISDATE() function The ISDATE() function determines whether the variable or the expression contains a valid date. It returns 1(true) ...

COALESCE using Sqlserver

›
I want get employeelist in one single string. now in new pl/sql version having the COALESCE function, The magic of function is, it will auto...
Wednesday, October 17, 2007

Alternate method for renaming a Database in Sql server 2005

›
Alternate method for renaming a Database in Sql server 2005 To rename database it is very common to use for SQL Server 2000 user : EXEC sp_r...

Heap table in sqlserver

›
Introduction What is a table called, if it does not have neither Cluster nor Non-cluster Index? What is it used for? Unindexed table or Heap...

NULLIF function in Sql server

›
the use of NULLIF function in Sql server Syntax: NULLIF ( expression , expression ) Paragraph Heading N Returns a null value if the two spe...

If you execute this in SQL Server 2005's standard AdventureWorks database, what happens?

›
If you execute this in SQL Server 2005's standard AdventureWorks database, what happens? select Identity(smallint, 100,1) as ReportID , ...