Search Results

Search found 27530 results on 1102 pages for 'sql truncate'.

Page 156/1102 | < Previous Page | 152 153 154 155 156 157 158 159 160 161 162 163  | Next Page >

• Which user account is running SQLCMD in T-SQL Script without -U and -P option?

  - by niteshg

  I am using sqlcmd in a T-SQl script to write a text file to a network location. However SQLCMD is failing to write to that location due to access permission to the network folder. SP is being run under my user account which has access to the network folder. Could you please help me under which account sqlcmd will run if I do not specify -U and -P option in TSQL Script?

  Read the article

• How to include the total number of returned rows in the resultset from SELECT T-SQL command?

  - by quarkX

  I would like to ask if there is a way to include the total number of rows, as an additional column, in the returned result sets from a TSQL query using also the Row_Number (SQL 2005) command. For example, getting the results set from a query against Book table in a form similar to this: RowNum BookId BookTitle TotalRows -------------------------------------------- 1 1056 Title1 5 2 1467 Title2 5 3 121 Title3 5 4 1789 Title4 5 5 789 Title5 5

  Read the article

• SQL Server - how to set (nolock) hint as a default?

  - by opensas

  is there some way to tell sql server to use the (nolock) hint or every select in a stored procedure? is pretty tiresome to add it to each an every select....

  Read the article

• Odd SQL behavior, I'm wondering why this works the way it does.

  - by Matthew Vines

  Consider the following Transact sql. DECLARE @table TABLE(val VARCHAR(255) NULL) INSERT INTO @table (val) VALUES('a') INSERT INTO @table (val) VALUES('b') INSERT INTO @table (val) VALUES('c') INSERT INTO @table (val) VALUES('d') INSERT INTO @table (val) VALUES(NULL) select val from @table where val not in ('a') I would expect this to return b, c, d, NULL but instead it returns b, c, d Why is this the case? Is NULL not evaluated? Is NULL somehow in the set 'a'?

  Read the article

• How to Add a default value in SQL server compact?

  - by Suryakavitha

  Hi , I need to add default value column in SqlServer Compact....i am new to this SQL server compact so Plz anyone tell me the Solution of this.... Thanks In Advance

  Read the article

• how can a databse be created on sql server 2005 using c# vs08.

  - by user287745

  to create new a new databse file start sql server management studio express on db server and create it! i would like to create a database using c# in my web application visual studio 08 is it possible? as connection string has to have a name of database to connect, but i want to create one.

  Read the article

• How to retrieve unicode data stored directly in non-unicode field as varchar format in sql server

  - by Samujjal

  I have to create a C# application which displays unicode data in a textbox. But the SQL server column storage has varchar data which contains unicode data. But since varchar is non-unicode based it displays character strings like "????????". Well the problem i am facing is i cant change the column type as there are other dependent application running on it.

  Read the article

• How to switch from VARCHAR to TEXT in SQL 2000?

  - by MatthewMartin

  What do I need to consider before I switch a bunch of fields from VARCHAR(bignumber) to TEXT? Aside from performance, and sometime in the far future TEXT will be deprecated, and aside from the fact that it looks like I need to drop and recreate the table to alter the column's data type? This is for SQL 2000-- I can't do VARCHAR(max) and VARCHAR(8000) isn't large enough.

  Read the article

• How do I change this query to linq to sql?

  - by Piyush

  Query: select emp.empname as Name, dep.depname as Department from Employee as emp inner join Department as dep on emp.depid=dep.depid where emp.id='2' How can I change this to linq to sql?

  Read the article

• Hyper-V snapshot backup strategy appropriate for production SQL server?

  - by Chuck

  So SQL Server 2008 in Hyper-V is a supported configuration, and should perform well as long as you use fixed or pass-through disks and increase your processor/memory settings appropriately. My question is can I use snapshots as a reliable backup mechanism, or should I use the tried and trusted maintenance plan to do my backups?

  Read the article

• How to ignore noiseXXX.txt files for a specific column in SQL Server 2005?

  - by John MacIntyre

  I have a product table where the description column is fulltext indexed. The problem is, users frequently search a single word, which happens to be in the noiseXXX.txt files. We'd like to keep the noise word functionality enabled, but is there anyway to turn it off just for this one column? I think you can do this in 2008 with the SET STOPLIST=OFF, but I can't seem to find similar functionality in SQL Server 2005.

  Read the article

• Looking for a tool that can return SPs doing a DML on a table in SQL Server 2008

  - by Kiran

  I am working on a big application on SQL Server 2008 with 60 000 stored procedures and over 10 000 tables. Is there a tool through which I can do impact analysis to find out all SPs doing a DML on a table?

  Read the article

• How to convert SQL Statement with TOP, COUNT and GROUP BY to return an object list with LINQ

  - by Junior Mayhé

  Hello guys does anyone know how to convert this SQL statement to a LINQ to a List? SELECT TOP(5) COUNT(CategoryId), CategoryName FROM Tickets GROUP BY CategoryName The result would be something like public static List<Categories> List() { MyEntities db = new MyEntities(); /* here it should return a list o Category type */; return db.Category.GroupBy(...).OrderBy(...); }

  Read the article

• Easiest way to make copy SQL Server DB to test DB?

  - by Curtis White

  What is the easiest way to take a SQL Server database and make a test copy of it? I have looked through some existing topics but not sure if there is an easier way. I have database publisher. I want to be able to keep both database on the same server, potentially.

  Read the article

• SQL: how to predicate over stored procedure's result sets?

  - by Ariel

  Simple question I couldn't figure out (not a SQL expert... sorry): I want to do a select on the result set of sp_who2. How can I? for ex. select SPID from [result set from sp_who2]

  Read the article

• What's the best way to parse an Address field using t-sql or SSIS?

  - by dtaylo04

  I have a data set that I import into a SQL table every night. One field is 'Address_3' and contains the City, State, Zip and Country fields. However, this data isn't standardized. How can I best parse the data that is currently going into 1 field into individual fields. Here are some examples of the data I might receive: 'INDIANAPOLIS, IN 46268 US' 'INDIANAPOLIS, IN 46268-1234 US' 'INDIANAPOLIS, IN 46268-1234' 'INDIANAPOLIS, IN 46268' Thanks in advance! David

  Read the article

• In SQL Server, how can I insert data into a table that has just one column which is of identity type

  - by Yousui

  In SQL Server, how can I insert data into a table that has just one column which is of identity type? Such as insert into the following table t. How can I write the insert statement? CREATE TABLE t ( id INT IDENTITY(1, 1) PRIMARY KEY ) Great thanks.

  Read the article

• Calculating age based on date of birth in SQL and C#? [closed]

  - by Raj

  Possible Duplicates: How to calculate age (in years) based on Date of Birth and getDate() How do I calculate someone’s age in C#? How to calculate the customer age automatically by using their Date of Birth using c# and SQL Server 2005

  Read the article

• XML in SQL Server 2005? Better than JSON in Varchar?

  - by Henry

  What are the benefits of storing XML in SQL Server over storing JSON in a varchar field? Any tutorial available for how to use the XML data type effectively? Do I need to provide the dtd / xml schema somehow? I've heard it is optional, right? Thank you.

  Read the article

• How to make a table Read Only in SQL Server?

  - by Jeyavel

  Hi, i am updating some set of records in that table , after that i need to make this table read only. So How to make a table Read Only in SQL Server? Regards, Jeyavel N

  Read the article

• SQL CE Compact 3.5 Identity columns for a table.

  - by rxm0203

  Is there a query I can write against an INFORMATION_SCHEMA or against the system tables to determine if a column is an identity column in SQL CE version 3.5?

  Read the article

• Copy a table from an SQL Server CE 3.5 database to another in Visual Studio 2008?

  - by ipapasa

  How can I copy a table from an SQL Server CE 3.5 database to another (also CE database) in Visual Studio 2008, using the design tools? Note: When right clicking on a table there is a "copy" command, but I couldn't find any "paste" command so far...

  Read the article

• How to prevent SQL Compact DB to be erased?

  - by Skuta

  Hi, I'm developing an applciation using SQL Compact database in Visual Studio 2008. When I start the application and run the process, the data is being loaded into database for few hours worth of few tens of megabytes. However, when I quite debugging, change something in code (not in DB structure), run the project again, the database is erased. Does anyone know how to prevent this behavior? I need the data to stay in DB to test on it.

  Read the article

• Generate Delete Statement From Foreign Key Relationships in SQL 2008 ?

  - by Element

  Is it possible via script/tool to generate a delete statement based on the tables fk relations. i.e. I have the table: DelMe(ID) and there are 30 tables with fk references to its ID that I need to delete first, is there some tool/script that I can run that will generate the 30 delete statements based on the FK relations for me ? (btw I know about cascade delete on the relations, I can't use it in this existing db) I'm using Microsoft SQL Server 2008

  Read the article

• Is there a way to find out the user that submitted a SQL query?

  - by ProgrammingPope

  I am interested in writing a trigger that would ignore queries from a specific SQL user but take action on all others. Is there any way to do this?

  Read the article

< Previous Page | 152 153 154 155 156 157 158 159 160 161 162 163  | Next Page >