-
Expert Performance Indexing for SQL Server 2012
If you are looking for expert performance indexing for SQL Server 2012, you may try to download SQL Server 2012…
-
SQL Server 2005 Service Pack Downloads
SQL Server 2005 Service Pack Downloads This is a page of SQL’s featured download references. Get service packs, add-ins, tools,…
-
Microsoft SQL Server Management Studio Express
Microsoft SQL Server Management Studio Express (SSMSE) is a free, easy-to-use graphical management tool for managing SQL Server 2005 Express…
-
Sql : Database Unknown Owner
SELECT Name AS DBName,suser_sname(sid) AS Owner FROM master.dbo.sysdatabases WHERE suser_sname(sid) IS NULL If you get any results, you can set…
-
SQL : Clone Table
This is short articel – Clone Table Script, we have seen how we can backup or create clone via using…
-
SQL: ALTER Columns Statement to update NULLs to Not NULLs
SQL: This example updates allow NULLs to Not Nulls. ALTER TABLE dbo.tbl_temp ALTER COLUMN UserName VARCHAR(256) NOT NULL
-
SQL – Server – Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “Chinese_PRC_CI_AS”
Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “Chinese_PRC_CI_AS” in the equal to operation. Check YourFieldName NVARCHAR(20) in Create Table…
-
SQL Server – finding duplicate records in sql
The col1 in a table that exist more than once. SELECT Col1, COUNT (Col1) AS NumOccurrences FROM TBL GROUP BY Col1…
-
CHARINDEX (Transact-SQL)
Syntax: CHARINDEX ( expressionToFind ,expressionToSearch [ , start_location ] ) A. Returning the starting position of an expression The following…
-
Add new columns to existing table. Using by Alter Table.
Add new columns to existing table ALTER TABLE [YOURDATABASENAME].[dbo].[YOURTABLE] ADD NEWCol1 NVARCHAR(20); ALTER TABLE [YOURDATABASENAME].[dbo].[YOURTABLE] ADD NEWCol2 DATETIME; ALTER TABLE…
