Naslu: Code Snippets from carlos

Home Search

Code Snippets of carlos

UPDATE 
T1
SET {FieldName} = {Value}
FROM 
Table1 AS T1
JOIN Table2 T2 ON T1. = T2.
WHERE {...}

SQL UPDATE WITH JOIN
Uploaded on 7/10/2007 4:31:45 AM
0 comments
Programming Language: SQL

declare @i int
set @i=0
while (@i<600)
begin
 
 -- DO SOMETHING 

set @i=@i+1
end

SQL loop (while sentence)
Uploaded on 6/29/2007 2:27:00 AM
0 comments
Programming Language: SQL

loop while sql

    Dim sqlConn as new SqlConnection("Data Source={0};Initial Catalog={1};
                                      UserID={2};Password={3}")
    Dim sqlda As New SqlDataAdapter
    Dim sqlcomm As New SqlClient.SqlCommand
    With sqlcomm
      .Connection = sqlConn
      .CommandText = "stored_Name"
      .CommandType = CommandType.StoredProcedure
      .Parameters.AddWithValue("@Param1", value1)
      .Parameters.AddWithValue("@Param2", value2)
        End With
    sqlda.SelectCommand = sqlcomm
    sqlConn.Open()
    Try
      sqlda.Fill(ds, TableName)
    Catch ex As SqlException
      Throw ex
    Finally
      sqlConn.Close()
    End Try

fill Dataset calling stored procedure
Uploaded on 6/20/2007 3:42:33 AM
0 comments
Programming Language: VB .NET

.NET Stored procedure SqlDataAdapter

SELECT * FROM
  Information_schema.columns
WHERE
  Table_Name Like '%%' AND Column_Name LIKE '%%'

Search Column in a SQL Server Table
Uploaded on 6/5/2007 6:22:23 AM
0 comments
Programming Language: SQL

SQL Server

SELECT * FROM 
  Information_Schema.Tables
WHERE 
  Table_Name LIKE '% %'

Search Table SQL Server
Uploaded on 6/5/2007 6:19:16 AM
0 comments
Programming Language: SQL

SQL Server

1 2

Help	Help by email

Select language: Español | English