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.
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
Try to open the file in the browser and then copy the needed lines in the editor. That worked for me.
Try adding this line to the beginning of your stored procedure: SET FMTONLY OFF You can remove this after you have finished importing.
Question: Is it possible to setup a notification email being sent to multiple operators for that specific job? I don’t believe this is possible. Certainly looking at the structure of [msdb].[dbo].[sysjobs] the various operator_id columns are in this table itself which would support the idea that 1 to many is not possible. But some alternatives … Read more
If I recall correctly, it should be something like: ALTER TABLE table_name ADD extra REAL DEFAULT 0 See: http://msdn.microsoft.com/en-us/library/ms190273.aspx See: Add a column with a default value to an existing table in SQL Server
yes it does. See this
Background: I develop a system that has almost 2000 stored procedures. The critical thing I have found is to treat the database as an application. You would never open an EXE with a hex editor directly and edit it. The same with a database; just because you can edit the stored procedures from the database … Read more
datetime2 [ (fractional seconds precision) ] It’s the fractional seconds precision according to the MSDN documentation. http://msdn.microsoft.com/en-us/library/bb677335.aspx This is the microsoft example of 4: DECLARE @datetime2 datetime2(4) = ’12-10-25 12:32:10.1234′; So I would assume that 7 would be: DECLARE @datetime2 datetime2(7) = ’12-10-25 12:32:10.1234567′;