sql-server-2008 – Page 7

How to install SQL Server Management Studio 2008 component only [closed]

February 11, 2023 by Tarik

I found some articles to be of major use: This link is an experience someone else had: http://goneale.com/2009/05/24/cant-install-microsoft-sql-server-2008-management-studio-express/ This link has the exact steps involved to install everything properly: http://www.codefrenzy.net/2011/06/03/how-to-install-sql-server-2008-management-studio/ This link confirms the previous link: https://superuser.com/questions/88244/installing-sql-server-management-studio-when-vs2010-beta-2-is-already-installed My Instructions I am not sure if my instructions will be 100% accurate, but in my instance, because … Read more

How eliminate the tab space in the column in SQL Server 2008

February 11, 2023 by Tarik

Try this code SELECT REPLACE([Column], char(9), ”) From [dbo.Table] char(9) is the TAB character

How to add hours to current date in SQL Server?

February 6, 2023 by Tarik

DATEADD (datepart , number , date ) declare @num_hours int; set @num_hours = 5; select dateadd(HOUR, @num_hours, getdate()) as time_added, getdate() as curr_date

How to create a function in SQL Server

February 4, 2023 by Tarik

How about this? CREATE FUNCTION dbo.StripWWWandCom (@input VARCHAR(250)) RETURNS VARCHAR(250) AS BEGIN DECLARE @Work VARCHAR(250) SET @Work = @Input SET @Work = REPLACE(@Work, ‘www.’, ”) SET @Work = REPLACE(@Work, ‘.com’, ”) RETURN @work END and then use: SELECT ID, dbo.StripWWWandCom (WebsiteName) FROM dbo.YourTable ….. Of course, this is severely limited in that it will only … Read more

varchar(max) everywhere?

January 31, 2023 by Tarik

By using VARCHAR(MAX) you are basically telling SQL Server “store the values in this field how you see best”, SQL Server will then choose whether to store values as a regular VARCHAR or as a LOB (Large object). In general if the values stored are less than 8,000 bytes SQL Server will treat values as … Read more

How to declare an array inside MS SQL Server Stored Procedure?

January 22, 2023 by Tarik

You could declare a table variable (Declaring a variable of type table): declare @MonthsSale table(monthnr int) insert into @MonthsSale (monthnr) values (1) insert into @MonthsSale (monthnr) values (2) …. You can add extra columns as you like: declare @MonthsSale table(monthnr int, totalsales tinyint) You can update the table variable like any other table: update m … Read more

What does “select 1 from” do?

January 14, 2023 by Tarik

select 1 from table will return a column of 1’s for every row in the table. You could use it with a where statement to check whether you have an entry for a given key, as in: if exists(select 1 from table where some_column = ‘some_value’) What your friend was probably saying is instead of … Read more

Why use the SQL Server 2008 geography data type?

January 1, 2023 by Tarik

If you plan on doing any spatial computation, EF 5.0 allows LINQ Expressions like: private Facility GetNearestFacilityToJobsite(DbGeography jobsite) { var q1 = from f in context.Facilities let distance = f.Geocode.Distance(jobsite) where distance < 500 * 1609.344 orderby distance select f; return q1.FirstOrDefault(); } Then there is a very good reason to use Geography. Explanation of … Read more

How to edit one specific row in Microsoft SQL Server Management Studio 2008?

December 25, 2022 by Tarik

Use the “Edit top 200” option, then click on “Show SQL panel”, modify your query with your WHERE clause, and execute the query. You’ll be able to edit the results.

SQL Add foreign key to existing column

December 20, 2022 by Tarik

Error indicates that there is no UserID column in your Employees table. Try adding the column first and then re-run the statement. ALTER TABLE Employees ADD CONSTRAINT FK_ActiveDirectories_UserID FOREIGN KEY (UserID) REFERENCES ActiveDirectories(id);