Skip to content Skip to sidebar Skip to footer
Showing posts with the label Sql Server 2005
Sql Server : How To Use An Aggregate Function Like Max In A Where Clause

Sql Server : How To Use An Aggregate Function Like Max In A Where Clause

Post a Comment
I want get the maximum value for this record. Please help me: SELECT rest.field1 FROM masterta… Read more Sql Server : How To Use An Aggregate Function Like Max In A Where Clause
Command Line To Create Data Source With Sql Authentication?

Command Line To Create Data Source With Sql Authentication?

Post a Comment
I'm looking to run a batch file on windows xp professional which creates a system odbc data sou… Read more Command Line To Create Data Source With Sql Authentication?
How Can A Table's Last Modified Date Be Returned In Sql Server 2005?

How Can A Table's Last Modified Date Be Returned In Sql Server 2005?

Post a Comment
How can a Table's Last Modified date be returned in SQL Server 2005? I did see one on the Table… Read more How Can A Table's Last Modified Date Be Returned In Sql Server 2005?
Select Top N Dynamically With N From The Same Select Statement

Select Top N Dynamically With N From The Same Select Statement

Post a Comment
I have a procedure that tries to insert samples in a table for each Agent, the # of samples for eac… Read more Select Top N Dynamically With N From The Same Select Statement
Different Ways To Generate The Latest Int Type Primary Foreign Key In Code

Different Ways To Generate The Latest Int Type Primary Foreign Key In Code

Post a Comment
I am new to sql. I have added 2 new tables in database. The primary key of first is a foreign key i… Read more Different Ways To Generate The Latest Int Type Primary Foreign Key In Code
I Still Get A "arithmetic Overflow" When I Filter On A Cast Datetime Even If I Use Isdate()

I Still Get A "arithmetic Overflow" When I Filter On A Cast Datetime Even If I Use Isdate()

Post a Comment
I have a data set that I need to filter a date that is stored as a string (changing the source colu… Read more I Still Get A "arithmetic Overflow" When I Filter On A Cast Datetime Even If I Use Isdate()