.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Generate table definition using CLR

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :

Hi Experts,

I have a requirement where i need to generate script for a spefice table from one DB and execute that script on another DB. We are not using any tools and hence i need some help on creating a dll that will generate script for a table. I have never used SQL CLR and hence need all the guidence in order to do this.


Regards, Deven ----------------------------------------- Please vote if you find any of my post helpful.

View Complete Post

More Related Resource Links

generate create script of table using c# and SQL server 7.0, can anyone help me?


I want to generate create table script using c#.net, I want to connect sql server 7.0 and generate table create script. Its urgent kindly help me urgently.

SMO classes to generate alter table script to add columns

How to generate ALTER TABLE script to add columns using SMO and c#.

generate dinamic rows with tetxbox in asp:table

) dynamically generated new rows containing two columns, one with a display name and the other a textbox for the user to enter a value. " ye="Hola, en TablaVenta () genero dinamicamente nuevas filas que contienen dos columnas una con un nombre para mostrar y la otra un textbox para que el usuario ingrese un valor." closure_uid_83htk5="176" mce_style="BACKGROUND-COLOR: #ebeff9">Hello, in TablaVenta (<asp:table>) dynamically generated new rows containing two columns, one with a display name and the other a textbox for the user to enter a value.When I want to retrieve those rows from the code, I notice that there are no rows created in the tableList<BLL.Producto> productos = new List<BLL.Producto>(); for (int i = 0; i <= TablaVenta.Rows.Count; i++) { TableRow tr = new TableRow(); tr = (TableRow)TablaVenta.Rows[i]; for (int c = 1; c <= tr.Cells.Count; i++) { BLL.Producto unProd = new BLL.Producto(); unProd.Nombre = TablaVenta.Rows[i].Cells[c].Text;   Error: Specified argument was out of the range of valid values.Parameter name: index Do you know, what i can will do? Thankss

Wierd case of: Msg 213, Column name or number of supplied values does not match table definition

Hi, I'm working on several triggers (that happen after insert or update) in order to log the changes in a different table. They all follow a similar syntax and are working fine, except for this one... I've reduced the next code to the minimum that gives an error, so we can safely assume the other parts of the trigger are working fine. INSERT INTO [Adt].[WardUnitStayLog] SELECT t.* FROM [Adt].[WardUnitStay] t INNER JOIN inserted i ON i.[Id] = t.[Id]; I've used this same syntax (but on different tables) in other triggers, and these are working perfectly fine. The above query provides the next error: Column name or number of supplied values does not match table definition. I've checked both tables for differences in the columns, but to no avail... (I've checked them manually and by outerjoining the information_schema.columns) (I've also checked the order in wich these columns are defined, they match over the two tables) These are the creation scripts for the tables: CREATE TABLE [Adt].[WardUnitStay] ( [Id] [dbo].[Id] IDENTITY(1,1) NOT NULL, [UnifiedUnitStayId] [dbo].[Id] NOT NULL, [WardCd] [dbo].[Cd] NOT NULL, [_FirstAtTm] [dbo].[Dtm] NOT NULL, [_IsReservation] BIT NOT NULL, [_LastAtTm] [dbo].[Dtm] NOT NULL, [_LastBedCd] [dbo].[Cd] NULL, [_LastPhysicianUid]

Schema comparer mistake in table-valued function (Nullability in column definition)

Hello. In my database i have table valued function. In its definition nullability of column is not set directly. This column has a user-defined data type. So the question is: is this column nullable? As i can see here: http://msdn.microsoft.com/en-us/library/ms174979.aspx   When column nullability is not explicitly specified, column nullability follows the rules shown in the following table. Column data type Rule Alias data type The Database Engine uses the nullability that is specified when the data type was created. To determine the default nullability of the data type, use sp_help. It should be not null, as user defined type is declared as not null. SMO says, that column is not null, but schema compare says it is nullable. Who is wrong and why?

generate AccNo in SQL(select min AccNo from table where AccNo>300000000

hi all..., i create a registration form and it'll generate AccounNo for user after they click "SAVE" button. my database AccountNo start from 300000000 it's generate ID after >300000000 if i register a person it will register to 300000001 let's say i have AccountNo- 300000001 300000002 300000004 300000005 i dun have "300000003" i want to get that Account No to my registration... when i click "SAVE" it's have to search the minimum Account No from database and add user... how to do this..can anyone modify this code to read min AccountNo from database.. here's the code that i have using : try { connection.Open(); #region Generating a newAccNo SqlCommand newAccNoCommand = connection.CreateCommand(); newAccNoCommand.CommandText = "SELECT TOP 1 AccNo FROM Debtor ORDER BY AccNo DESC"; newAccNoCommand.CommandType = CommandType.Text; int minCurrentAccNo = 0; try { if (!int.TryParse(newAccNoCommand.ExecuteScalar().ToS tring(), out minCurrentAccNo)) { minCurrentAccNo = defaultAccNo; } } catch { minCurrentAccNo = defaultAccNo; } int newAccNo = minCurrentAccNo + 1; newAccNoCommand.Dispose(); #endregion

Join Tables For Definitions (Data Table/Definition Table)



I am well versed with Join/Outer Join/Inner Join. My question is not related to normal Joining of two tables. Its little complex. Let me see if I can explain well.

There are two tables, were data is stored.

Name_Info : nvarchar(10)
Date_Info : smalldate()
Spec_Info_1 : tinyint
Spec_Info_2 : tinyint
Spec_Info_3 ; tinyint

Name_Data : nvarchar(10)
City_Data : nvarchar(10)
State_Data : nvarchar(10)

To join these two tables, I use the following query (joined on Name_Info ON Name_Data)


SELECT Name, Date=CONVERT(varchar, Date, 101), City, State,
CASE Spec_Info_1 WHEN '0' THEN 'House' WHEN '2' THEN 'Shop' WHEN '3' THEN 'Bay' ELSE '-' END AS Spec_Info_1, 
CASE Spec_Info_2 WHEN '0' THEN '10 Feet' WHEN '2' THEN '20 Feet' WHEN '3' THEN '40 Feet' ELSE '-' END AS Spec_Info_2, 
CASE Spec_Info_3 WHEN '0' THEN '2 Windows' WHEN '2' THEN '4 Windows' WHEN '3' THEN '6 Windows' ELSE '-'  END AS Spec_Info_3
FROM Table_Spec_Data LEFT OUTER JOIN Table_Name_Data On Table_Spec_Data.Name_Info=Table_Name_Data.Name_Data  

SSIS 2005 - Dynamically generate create table statement from source



I have a requirement where i had to migrate the table structure and data from ODBC database to SQL Server. I have dynamic source reader that uses sql query from variable to get the data and the next step is to get the create statement and create table and then to insert data. how can i get Create Statement the destination produces and use sql task to create the table and then insert the data using data flow task.

Please suggest



Use variable in XML table definition

I am trying to use a local variable with html.  Here is the code:



-- SET NOCOUNT ON added to prevent extra result sets from


-- interfering with SELECT statements.





How to auto-generate object initzializer code according to any given class definition?



I think this is at least somewhat connected to reflection so I posted it here.

I work with WCF and Web Services right now. Of course I use the tools provided to generate code from the WSDL documents, hence, for every datatype, a corresponding class is generated. As the WS has loads of types with nested subtypes, I get about 80 usually small classes, only having a few members. In order to implement all that, I have to initialize the classes over and over again.

So I wonder, if there is no way, to use reflection to automatically generate  code (object inizializer) from the class definition, including all subclasses?

Ideal would be a snipped - so that I just enter the name of any random class and dynamically get the full initializer generated. Do snippets actually have the power to do that?

As this will save a lot of stupid typing, I also wonder, if there aren't already any tools, snippets or widgets that do this? I assumed that is is something many programmers might need, but google did not show anything like it.

Thank you very much!

Cannot generate table scripts with DateTime2 datatype in SQL Server 2008


When trying to generate a "CREATE TO" script from a SQL Server 2008 table containing either DATE or DateTime2 data types,  I get the following error:

Script failed for Table 'dbo.tMyTable'.  (Microsoft.SqlServer.Smo)
Column SnapshotDate in object tMyTable contains type DateTime2, which is not supported in the target server version, SQL Server 2005. (Microsoft.SqlServer.Smo)

However, I've checked all my databases (including master, tempdb, etc.) and ALL are cmptlevel=100.


Is Identity? in table definition not available



I'm creating a new table, with an 'id' column, I'm willing to set 'Is Identity?' to true (for autocomplete), but it's greyed out:

generate table using innerHtml



We have a Html table inside a div. We are saving innerHtml of div in an input tag. We read the value of input tag inside controller. Hence, we get div.innerHtml in controller. Now, we want to generate Html table using div.innerHtml. please help us out.

Else, please suggest a way to read Html table in controller.

generate Table script using TSQL Sql Server

This code sample helps you to generate the Table script for the particular table. You can create the function and can generate the script by calling the function by passing the Table name as a parameter.

Export Visio Database Table Names to Excel

If you use the Enterprise Architect edition of Microsoft Visio for data modeling regularly, then there is a good chance that at some point you've wanted to export just the table names into Excel. You might want to do this to map logical ERD entities to physical data model tables, track project status by entity, or track overlap between database versions.

Insert value using Table Value Functions

a real gem in Sql Server 2008. mostly people still using Stored procedure may be they shifted to SQL Server but they are not using TVF right now.

Using jQuery to Filter Table Rows

The project is using the .net GridView control, so I had limited control over the output HTML code. Still, I think this code can work for most tables. One thing to notice: you should use the class "filterable" on your table or on one of its parents for the code to work.
First, we need a text box:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend