Search Results

Search found 36186 results on 1448 pages for 'sql 11'.

Page 566/1448 | < Previous Page | 562 563 564 565 566 567 568 569 570 571 572 573  | Next Page >

• Assign a post to a user in ASP.NET Membership

  - by Alon

  I'm writing a forum in ASP.NET. I have a table of posts. How can I assign a post to a user? If I had a normal User table, I'd just creating a new field in the post table "UserId" and creating an assocation in the Linq to Sql designer. But now? Should I include the aspnet_Users in the designer? Thanks.

  Read the article

• .NET Message Queuing using SQL Server as Message Storage

  - by Yoann. B

  Hi, I'm looking for a MSMQ alternative which use SQL Server as messages persistance since MSMQ as some limitations : 4Mb Message Size, 1.6Go Queue Size ... Is there any open source or free project doing that ? Thanks.

  Read the article

• SQL DB User's changes

  - by Ajay Kumar Miglani

  Hi, I , unknowingly, create a user in database with loginname of 'windows_user' instead of sql server user , now enable to drop. pl suggest the way .. Regards Ajay Kumar Miglani Delhi-India

  Read the article

• MySQL - connection and security

  - by Phil Jackson

  Hi, I was wondering if someone could tell me if there is any potential security breeches that could occur by connecting to a sql database that does not reside at 'localhost' i.e. via ip address? Regards, Phil

  Read the article

• Caching a user control

  - by Rishabh Ohri

  I have a user control which I want to Output cache( fragment cache) and set the dependency to a query. I mean that on change or modification of data returned by that query the cache should get invalidated. I have read that in the output cache directive in the user control Sqldependency = "CommandNotification" cannot be used. So, how should i proceed in order to add the sql query dependency to the fragment cached user control.

  Read the article

• LINQ Query Help!

  - by rk1962

  Can someone hep me converting the following SQL query into LINQ? select convert(varchar(10),date,110) as 'Date', max(users) as 'Maximum Number of Users', max(transactions) as 'Maximum Number of Transactions' from stats where datepart(Year, Date) = '2010' group by convert(varchar(10),date,110) order by convert(varchar(10),date,110) Thank you in advance!

  Read the article

• Free web based query builder

  - by Pragnesh Patel

  is there any opensource component available like EasyQuery.net ? where we can assign datasource to component and later on we can create custom sql criteria.

  Read the article

• Sqldatareader and rowcount

  - by phenevo

  Hi, I have a query: declare @Code nvarchar(100) select @Code="BMW" select name from NewCars where code=@Code if @@rowcount = 0 Select name from OldCars where code=@Code In Sql managment studio first part give me 0 resuklts, and second 1 one result, and that is ok, but in sqldatareader I use the same query ofcource without: declare @Code nvarchar(100) select @Code="BMW" because I use: cmd.Parameters.AddWithValue("@Code", "BMW"); And using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { Name= reader["Name"].ToString(); } } else { throw new NotSupportedException("Lack of car with this Code"); } } gives me zero result

  Read the article

• t-SQL grant permission for table drop and create

  - by Melody Friedenthal

  How can I Grant some users permission to drop and create a single table only in the SQL 2005 database accessed by our VB.net 2005 Win app? Some articles suggest Granting Control rights to the table but I cannot make this work. If you think this is teh way to go, can you show me the correct syntax?

  Read the article

• Javascript Injection and Sql Script injection

  - by Pranali Desai

  Hi All, I am writing an application and for this to make it safe I have decided to HtmlEncode and HtmlDecode the data to avoid Javascript Injection and Paramaterised queries to avoid Sql Script injection. But I want to know whether these are the best ways to avoid these attacks and what are the other ways to damage the application that I should take into consideration.

  Read the article

• C#.net Mobile Application: SDF to SQL Server data sync

  - by Ashok

  I have created a sdf database in a mobile application. Now I want to synchronize that database to a sql server database. How it is possible? Please help.........

  Read the article

• Finding all Stored procedures calling a function

  - by Abhishek Jain

  Hi, How can I find out all the stored procedures that are calling a particular user defined function in SQL Server 2005. Or how to assign a defult value to a parameter in a user defined function so that when a stored procedure calls that function and does not pass any value to that parameter function assumes the default value. Regards, Abhishek jain

  Read the article

• Relational database question with php.

  - by Oliver Bayes-Shelton

  Hi, Not really a coding question more a little help with my idea of a Relational database. If I have 3 tables in a SQL database. In my php script I basically query the companies which are in industry "a" and then insert a row into a separate table with their details such as companyId , companyName etc is that a type of Relational database ? I have explained it in a simple way so we don't get confused what I am trying to say.

  Read the article

• SQL server connectivity using ConfigurationManager.ConnectionString

  - by Devashri

  I am not able to use String connectionString = ConfigurationManager.ConnectionStrings["DevBackup"].ConnectionString; I am getting error 'The name 'ConfigurationManager' does not exist in the current context' I have used namespaces using System.Data.SqlClient; using System.Data.Sql; what should be done..?? Am I missing something..??

  Read the article

• can LINQ being used with Sybase database?

  - by 5YrsLaterDBA

  Customer wants to move from SQL server to Sybase database. Don't know if LINQ can still be here? change is big?

  Read the article

• Relational database queestion with php.

  - by Oliver Bayes-Shelton

  Hi, Not really a coding question more a little help with my idea of a Relational database. If I have 3 tables in a SQL database. In my php script I basically query the companies which are in industry "a" and then insert a row into a seperate table with their details such as companyId , companyName etc is that a type of Relational database ? I have explained it in a simple way so we don't get confused what I am trying to say.

  Read the article

• Adding pushpins with coordinates from SQL Server tables

  - by Mike

  Hello, I am a beginner in Silverlight and C# programming and i´m creating a Bing Map application. I try to add pushpins with coordinates and information from a SQL Server, but I can't figure out how to succeed. Mike

  Read the article

• SqlCommandBuilder.DeriveParameters(command) and IsNullable

  - by Andrey

  I have written an O/R database wrapper that generates some wrapper methods for stored procs it reads from the database. Now I need to produce some custom wrapper code if an input parameter of a stored proc is defaulted to NULL. The problem is - I get stored proc parameters using: SqlCommandBuilder.DeriveParameters(command) and it doesn't bring parameter defaults. Is there any way to look up those defaults? Are they stored anywhere in the database? BTW, I'm using SQL Server 2008

  Read the article

• Parse params from an sql query using delphi

  - by Salvador

  How i can parse and extract the parameters from an SQL Query using delphi? example : from this query SELECT * FROM MyTable WHERE Field1=:Param1 AND Field2=:Param2 AND (Field3=:Param3 OR Field4=:Param4) i want to obtain Param1 Param2 Param3 Param4 Thanks in advance.

  Read the article

• What is Ad Hoc Query?

  - by zihado

  Recently, I'm reading a book about SQL. In that book, I can't understand this term - Ad Hoc Query. I want to know what is exactly means "Ad Hoc Query" Help me, plz. Thanks in advance.

  Read the article

• Hibernate: hibernate.hbm2ddl.auto=update show generated sql

  - by FoxyBOA

  I wish to pass to Hibernate's SessionFactory hibernate.hbm2ddl.auto=update and see in log file generated sql statements. Is it possible w/o java coding (know how to achieve the result with SchemaExport, but hope that hibernate has "in box" solution)

  Read the article

• Entity Sql for a Many to Many relationship

  - by Deepak N

  Consider two tables Bill and Product with a many to many relationship. How do you get all the bills for a particular product using Entity Sql?

  Read the article

• I'm missing something

  - by Redi

  declare @servername varchar(2000) set @EmriServerit=(select @@servername) declare @dbname varchar(2000) set @dbname ='Test1' declare @Dir varchar(2000) set @Dir='F:\dataclient.sql' exec master.dbo.xp_cmdshell 'osql -E -S ' + @servername+ ' -d ' + @dbname +' -i ' + @Dir It gives me and error: "incorrect sysntax near +" If i don't use variables it works ok. What am i missing! Thanks in advance

  Read the article

• Read committed Snapshot VS Snapshot Isolation Level

  - by user173552

  Could some one please help me understand when to use SNAPSHOT isolation level over READ COMMITTED SNAPSHOT in SQL Server? I understand that in most cases READ COMMITTED SNAPSHOT works, but not sure when go for SNAPSHOT isolation. Thanks

  Read the article

• How can I drop a SqlServer Backup Device using SMO in C#?

  - by C-Pound Guru

  I can drop a SqlServer Backup Device using SQL-DMO using the following pseudo-code: SQLDMO.SQLServer2 server = New SQLDMO.SQLServer2(); server.Connect("myserver"); server.BackupDevices.Remove("mybackupdevice"); File.Delete("mybackupdevicephysicallocation"); SMO.Server.BackupDevices does not appear to have a Remove() method, so how can I drop a BackupDevice using SMO?

  Read the article

< Previous Page | 562 563 564 565 566 567 568 569 570 571 572 573  | Next Page >