In SqlServer 2005 and up, do this: CREATE PROCEDURE GetResults ( @ResultCount int ) AS SELECT top(@ResultCount) FROM table where x = y For earlier versions, use: CREATE PROCEDURE GetResults ( @ResultCount int ) AS SET ROWCOUNT @ResultCount SELECT * FROM table where x = y https://web.archive.org/web/20210417081325/http://www.4guysfromrolla.com/webtech/070605-1.shtml for more information.
UPDATE YourTable SET columnName = null WHERE YourCondition
Date now midnight time: Select DATEADD(d,0,DATEDIFF(d,0,GETDATE())) ADD 600 Minutes: Select DATEADD(mi,600,DATEDIFF(d,0,GETDATE()))
One useful trick in SQL is the ability use @var = function(…) to assign a value. If you have multiple records in your record set, your var is assigned multiple times with side-effects: declare @badStrings table (item varchar(50)) INSERT INTO @badStrings(item) SELECT ‘>’ UNION ALL SELECT ‘<‘ UNION ALL SELECT ‘(‘ UNION ALL SELECT ‘)’ … Read more
If by ‘description’ you mean ‘Description’ displayed in SQL Management Studio in design mode, here it is: select st.name [Table], sc.name [Column], sep.value [Description] from sys.tables st inner join sys.columns sc on st.object_id = sc.object_id left join sys.extended_properties sep on st.object_id = sep.major_id and sc.column_id = sep.minor_id and sep.name=”MS_Description” where st.name = @TableName and sc.name … Read more
There is a solution for this in SSMS 2012 that worked for me. Microsoft now provides a mechanism for removing a server from the list of remembered servers, and removing the offending server from the list will allow you to save the password the next time you connect to it: In the Connect to Database … Read more
Late entry that handles negative ISNUMERIC(zipcode + ‘.0e0’) –integer ISNUMERIC(zipcode + ‘e0’) –decimal For more see this
Try to open the file in the browser and then copy the needed lines in the editor. That worked for me.
Starting from .NET 6 MaxBy LINQ method is available. var result = items.MaxBy(i => i.Date); Prior to .NET 6: O(n): var result = items.Aggregate((x, y) => x.Date > y.Date ? x : y); O(n log n): var result = items.OrderByDescending(i => i.Date).First(); O(n) – but iterates over the sequence twice: var max = items.Max(i => … Read more
Try adding this line to the beginning of your stored procedure: SET FMTONLY OFF You can remove this after you have finished importing.