If you are Deleting All the rows in that table the simplest option is to Truncate table, something like TRUNCATE TABLE LargeTable GO Truncate table will simply empty the table, you cannot use WHERE clause to limit the rows being deleted and no triggers will be fired. On the other hand if you are deleting … Read more
Open SQL Server Management Studio Go to Tools > Options > Query Results > SQL Server > Results To Text On the far right, there is a drop down box called Output Format Choose Comma Delimited and click OK Here’s a full screen version of that image, below This will show your query results as … Read more
It doesn’t. There’s a vague equivalent: mycol VARCHAR(10) NOT NULL CHECK (mycol IN(‘Useful’, ‘Useless’, ‘Unknown’))
You will want to use the YYYYMMDD for unambiguous date determination in SQL Server. insert into table1(approvaldate)values(‘20120618 10:34:09 AM’); If you are married to the dd-mm-yy hh:mm:ss xm format, you will need to use CONVERT with the specific style. insert into table1 (approvaldate) values (convert(datetime,’18-06-12 10:34:09 PM’,5)); 5 here is the style for Italian dates. … Read more
Yeah I just scored this one. Look in Windows Services. Start > Administration > Services Find the Service in the list called: SQL Server (MSSQLSERVER) look for the “Log On As” column (need to add it if it doesn’t exist in the list). This is the account you need to give permissions to the directory, … Read more
Use the CAST to the new DATE data type in SQL Server 2008 to compare just the date portion: IF CAST(DateField1 AS DATE) = CAST(DateField2 AS DATE)
Try SELECT LTRIM(RTRIM(‘Amit Tech Corp ‘)) LTRIM – removes any leading spaces from left side of string RTRIM – removes any spaces from right Ex: update table set CompanyName = LTRIM(RTRIM(CompanyName))
SQL Server 2008 and Above: /* CREATE A NEW ROLE */ CREATE ROLE db_executor /* GRANT EXECUTE TO THE ROLE */ GRANT EXECUTE TO db_executor For just a user (not a role): USE [DBName] GO GRANT EXECUTE TO [user]
Set the path to restore the file. Click “Options” on the left hand side. Uncheck “Take tail-log backup before restoring” Tick the check box – “Close existing connections to destination database”. Click OK.
using(SqlDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { var myString = rdr.GetString(0); //The 0 stands for “the 0’th column”, so the first column of the result. // Do somthing with this rows string, for example to put them in to a list listDeclaredElsewhere.Add(myString); } }