[Huper]-Bay: sql server 2008 R2

Results for sql server 2008 R2

How to add New column to table using sql query

(C#) Csharp examples 11:24 PM

ALTER TABLE Your_Table_Name ADD Column_Name datatype Read More

How to add New column to table using sql query

Reviewed by (C#) Csharp examples on 11:24 PM Rating: 5

(C#) Csharp examples 11:10 PM

In this example am gonna replace empty space with _ here is the code to do that : UPDATE your_Table_Name SET Column_Name = REPLACE(Colu...Read More

SQL Server find and replace specific word in all rows of specific column

Reviewed by (C#) Csharp examples on 11:10 PM Rating: 5

(C#) Csharp examples 2:23 AM

Error Msg : System.ComponentModel.Win32Exception: The wait operation timed out Answer : Run sql command on " exec sp_updatestats ...Read More

System.ComponentModel.Win32Exception: The wait operation timed out

Reviewed by (C#) Csharp examples on 2:23 AM Rating: 5

(C#) Csharp examples 11:25 PM

How to determine total number of open/active connections in sql server 2008 R2 sql code : SELECT DB_NAME(dbid) as DataBase_Names, C...Read More

How to determine total number of open/active connections in sql server 2008 R2

Reviewed by (C#) Csharp examples on 11:25 PM Rating: 5

(C#) Csharp examples 11:19 PM

SQL Code : ALTER DATABASE Your_DataBase_Name SET MULTI_USER Read More

Remove SQL Server database from single-user mode

Reviewed by (C#) Csharp examples on 11:19 PM Rating: 5