Search Results

Search found 62701 results on 2509 pages for 'sql function'.

Page 169/2509 | < Previous Page | 165 166 167 168 169 170 171 172 173 174 175 176  | 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

• Go - Generic function using an interface

  - by nevalu

  Since I've a similar function for 2 different data types: func GetStatus(value uint8) (string) {...} func GetStatus(name string) (string) {...} I would want to use a way more simple like: func GetStatus(value interface{}) (string) {...} Is possible to create a generic function using an interface? The data type could be checked using reflect.Typeof(value)

  Read the article

• Difference of function argument as (const int &) and (int & a) in C++

  - by Narek

  I know that if you write void function_name(int& a), then function will not do local copy of your variable passed as argument. Also have met in literature that you should write void function_name(const int & a) in order to say compiler, that I dont want the variable passed as argument to be copied. So my question: what is the difference with this two cases (except that "const" enshures that the variable passes will not be changed by function!!!)???

  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

• JavaScript - Passing a reference to this current anonymous function

  - by Michael

  window.addEventListener('unload', function(e) { MyClass.shutdown(); window.removeEventListener('unload', /* how to refer to this function? */); }, false);

  Read the article

• VB.NET Function Return

  - by waves

  In order to return a value from a VB.NET function one can assign a value to the "Functions Name" or use "return value." I sometimes see these inter-mixed in the same function. Personally, I prefer the return. My question is, what is the internal difference, if any, between the two?

  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

• Solr sort by function

  - by spacemonkey

  Hi, I need to sort query results by the output of some function which takes "score" and couple other fields as an input (50% of the total score comes from similarity score and 50% comes from document's popularity). Is there a way to do this without having to install "Sort by Function" patch? Thanks!

  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

• raise error within MySql function

  - by Don

  Hi, I've created a MySql function and would like to raise an error if the values passed for the parameters are invalid. What are my options for raising an error within a MySql function? Thanks, Don

  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

• js function to get filename from url

  - by Blankman

  Hi, I have a url like http://www.example.com/blah/th.html I need a javascript function to give me the 'th' value from that. All my urls have the same format (2 letter filenames, with .html extension). I want it to be a safe function, so if someone passes in an empty url it doesn't break. I know how to check for length, but I should be checking for null to right?

  Read the article

• How to call DLL function in vbscript

  - by amritad

  I am writing VB script in which I have to call a function of a COM DLL. The fuction which I want to use is in structure and thus I want to create the object of that structure to access the required function. e.g. I have a dll 'BasicCom.dll', in which struct abc { bool xyz(); } Now I want to call xyz(). Is any one have any idea, how to deal with such call in Vb script.

  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

• Call c++ function pointer from c#

  - by Sam

  Is it possible to call a c(++) static function pointer like this typedef int (*MyCppFunc)(void* SomeObject); from c#? void CallFromCSharp(MyCppFunc funcptr, IntPtr param) { funcptr(param); } I need to be able to callback from c# into some old c++ classes. C++ is managed, but the classes are not ref classes (yet). So far I got no idea how to call a c++ function pointer from c#, is it possible?

  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

< Previous Page | 165 166 167 168 169 170 171 172 173 174 175 176  | Next Page >