How do I list all tables / columns in my database that have a full-text index?
I’ve got two tables in MS SQL Server: dailyt – which contains daily data: date val ——————— 2014-05-22 10 2014-05-21 9.5 2014-05-20 9 2014-05-19 8 2014-05-18 7.5 etc… And periodt – which contains data coming in at irregular periods: date val ——————— 2014-05-21 2 2014-05-18 1 Given a row in dailyt, I want to adjust […]
I have just installed Sql Server Compact Edition. To my surprise, we can’t use stored procedure in sql server CE. Do I have any alternative of Stored Procedure in Sql Server CE. I am strongly obsessed with stored procedure, I can’nt think of an application without stored procedures. Please help, Thanks in advance. Edit: Can […]
I have a script to delete all tables in my database that looks like this: — Disable all constraints EXEC sp_MSForEachTable ‘ALTER TABLE ? NOCHECK CONSTRAINT all’ — Disable all triggers EXEC EnableAllTriggers @Enable = 0 — Delete data in all tables EXEC sp_MSForEachTable ‘DELETE FROM ?’ — Dnable all constraints EXEC sp_MSForEachTable ‘ALTER TABLE […]
I have searched for the answer but haven’t been able to find anything that fits my situation. The site works completely fine when I run it locally, but when after I publish it to Azure if I try to use a page that accesses the Database it gives me the following error page: Server Error […]
I have an SQL Server 2005 database, and I tried putting indexes on the appropriate fields in order to speed up the DELETE of records from a table with millions of rows (big_table has only 3 columns), but now the DELETE execution time is even longer! (1 hour versus 13 min for example) I have […]
ive got an error to fix. its: [FreeTDS][SQL Server]Error converting characters into server’s character set. Some character(s) could not be converted when i use turkish characters to insert i get this error. my question is how can i disable that converting thing? im connecting to sql server via freetds and unixodbc. thanks..
My stored procedure returns me two outputs. I want to use one of them in another stored procedure. So trying to grab the second output in a temp table. but since the structure of both the outputs are different, there fore I always get “Column name or number of supplied values does not match table […]
I have a view vwGetData which gets data from two tables t1,t2 and has fields: t1.Field1 [ALIAS1], t1.Field2, t2.Field3, t2.Field4, t2.Field5 [ALIAS5] I will provide below input Select * from vwGetData i want to get below output in C#/SQL ALIAS1 Field2 Field3 Field4 ALIAS5 or ALIAS1, Field2, Field3, Field4, ALIAS5 I want to do this […]
I have data Table1 ID Name ———– 1 n1 2 n2 3 n4 Table2 FID YearS Val ———————- 1 2008 Up 1 2009 Down 1 2010 Up 2 2000 Up 2 2001 Down 2 2002 Up 2 2003 Up 3 2009 Down 3 2010 Up I want to return data in following format: ID Yr1 […]