sql-server Archives - Page 11 of 16

I need to search a SQL server 2008 for stored procedures containing where maybe the name of a database field or variable name. ...

I need a different random number for each row in my table. The following seemingly obvious code uses the same random value for ...

What query can return the names of all the stored procedures in a SQL Server database If the query could exclude system stored ...

I am trying to change a column from a varchar(50) to a nvarchar(200). What is the SQL command to alter this table? 10 ...

How do I get a list of all index & index columns in SQL Server 2005+? The closest I could get is: select ...

I am attempting to create a Stored Procedure for a newly created database. However the SSMS intellisense does not recognize more than half ...

Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be ...

What is the best practice for creating a yes/no i.e. Boolean field when converting from an access database or in general? 11 Answers ...

Is there to way write a T-SQL command to just make it sleep for a period of time? I am writing a web ...

How to remove a column from an existing table? I have a table MEN with Fname and Lname I need to remove the ...